Amazon no longer offers textbook rentals. We do!

New Perspectives on Microsoft Office Access 2003, Brief, CourseCard Edition

by: ADAMSKI/FINNEGAN

New Perspectives on Microsoft Office Access 2003, Brief, CourseCard Edition

by: ADAMSKI/FINNEGAN

ISBN 13:
9781418839079
ISBN 10:
1418839078
Edition: Brief
Format: Paperback
Copyright: 03/29/2005
Publisher: Cengage Learning
Newer Edition

Rent

Sorry, this item is currently unavailable.

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

Extend or Purchase Your Rental at Any Time

Need to keep your rental past your due date? At any time before your due date you can extend or purchase your rental through your account.

Summary

Part of the New Perspectives series, this text offers a case-based, problem-solving approach and innovative technology for meaningful learning of Microsoft Access 2003. A great case-based, problem-solving approach to learning Access, this text covers the basics such as creating queries, forms, and reports. Perfect for any introductory course or used in conjunction with our other Microsoft Office application books.

Preface

iii

Office

(2)

Read This Before You Begin

(1)

Using Common Features of Microsoft Office 2003

Preparing Promotional Materials

(1)

Exploring Microsoft Office 2003

(1)

Integrating Office Programs

(1)

Starting Office Programs

(4)

Switching Between Open Programs and Files

(1)

Exploring Common Window Elements

(1)

Using the Window Sizing Buttons

(2)

Using Menus and Toolbars

(3)

Viewing Personalized Menus and Toolbars

(3)

Using Task Panes

(2)

Opening and Closing Task Panes

(1)

Navigating Among Task Panes

(1)

Using the Research Task Pane

(2)

Working with Files

(5)

Creating a File

(1)

Saving a File

(2)

Closing a File

(1)

Opening a File

(1)

Getting Help

(6)

Using ScreenTips

(1)

Using the Type a Question for Help Box

(2)

Using the Help Task Pane

(2)

Using Microsoft Office Online

(2)

Printing a File

(1)

Exiting Programs

(1)

Quick Check

(1)

Tutorial Summary

(1)

Key Terms

(1)

Review Assignments

(1)

SAM Assessment and Training

(1)

Quick Check Answers

Access

(1)

Read This Before You Begin

(1)

Introduction to Microsoft Access 2003

(32)

Viewing and Working with a Table Containing Employer Data

(1)

Session 1.1

(1)

Introduction to Database Concepts

(3)

Organizing Data

(1)

Databases and Relationships

(1)

Relational Database Management Systems

(1)

Opening an Existing Database

(3)

Exploring the Access and Database Windows

(1)

Opening an Access Table

(2)

Navigating an Access Datasheet

(1)

Printing a Datasheet

(1)

Saving a Database

(1)

Session 1.1 Quick Check

(1)

Session 1.2

(1)

Working with Queries

(5)

Opening an Existing Query

(1)

Creating, Sorting, and Navigating a Query

(3)

Creating and Navigating a Form

(2)

Creating, Previewing, and Navigating a Report

(4)

Printing Specific Pages of a Report

(1)

Managing a Database

(4)

Backing up and Restoring a Database

(1)

Compacting and Repairing a Database

(1)

Compacting a Database Automatically

(1)

Converting an Access 2000 Database

(1)

Session 1.2 Quick Check

(1)

Tutorial Summary

(1)

Key Terms

(1)

Review Assignments

(1)

Case Problems

(3)

Internet Assignments

(1)

SAM Assessment and Training

(1)

Lab Assignments

(1)

Quick Check Answers

(1)

Creating and Maintaining a Database

(46)

Creating the Northeast Database, and Creating, Modifying, and Updating the Position Table

(1)

Session 2.1

(1)

Guidelines for Designing Databases

(2)

Guidelines for Setting Field Properties

(3)

Naming Fields and Objects

(1)

Assigning Field Data Types

(1)

Setting Field Sizes

(1)

Setting Field Captions

(1)

Creating a New Database

(1)

Creating a Table

(11)

Defining Fields

(7)

Specifying the Primary Key

(2)

Saving the Table Structure

(1)

Session 2.1 Quick Check

(1)

Session 2.2

(1)

Adding Records to a Table

(3)

Modifying the Structure of an Access Table

(9)

Deleting a Field

(1)

Moving a Field

(1)

Adding a Field

(1)

Changing Field Properties

(1)

Updating Field Property Changes

(4)

Obtaining Data from Another Access Database

(3)

Copying Records from Another Access Database

(2)

Importing a Table from Another Access Database

(1)

Updating a Database

(3)

Deleting Records

(1)

Changing Records

(2)

Session 2.2 Quick Check

(1)

Tutorial Summary

(1)

Key Terms

(1)

Review Assignments

(2)

Case Problems

(5)

Internet Assignments

(1)

SAM Assessment and Training

(1)

Quick Check Answers

(1)

Querying a Database

(48)

Retrieving Information About Employers and Their Positions

(1)

Session 3.1

(1)

Introduction to Queries

(1)

Query Window

(2)

Creating and Running a Query

(3)

Updating Data Using a Query

(1)

Defining Table Relationships

(6)

One-to-Many Relationships

(1)

Referential Integrity

(1)

Defining a Relationship Between Two Tables

(4)

Creating a Multi-table Query

(2)

Sorting Data in a Query

(5)

Using a Toolbar Button to Sort Data

(1)

Sorting Multiple Fields in Design View

(4)

Filtering Data

100

(2)

Session 3.1 Quick Check

102

(1)

Session 3.2

102

(1)

Defining Record Selection Criteria for Queries

102

(5)

Specifying an Exact Match

103

(2)

Changing a Datasheet's Appearance

105

(1)

Using a Comparison Operator to Match a Range of Values

106

(1)

Defining Multiple Selection Criteria for Queries

107

(5)

The And Logical Operator

108

(1)

Using Multiple Undo and Redo

109

(2)

The Or Logical Operator

111

(1)

Performing Calculations

112

(9)

Creating a Calculated Field

113

(4)

Using Aggregate Functions

117

(2)

Using Record Group Calculations

119

(2)

Session 3.2 Quick Check

121

(1)

Tutorial Summary

121

(1)

Key Terms

121

(1)

Review Assignments

122

(1)

Case Problems

123

(4)

Internet Assignments

127

(1)

SAM Assessment and Training

128

(1)

Quick Check Answers

128

(1)

Creating Forms and Reports

129

Creating a Position Data Form, an Employer Positions Form, and an Employers and Positions Report

129

(1)

Session 4.1

130

(1)

Creating a Form Using the Form Wizard

130

(3)

Changing a Form's AutoFormat

133

(2)

Finding Data Using a Form

135

(3)

Previewing and Printing Selected Form Records

138

(1)

Maintaining Table Data Using a Form

139

(2)

Session 4.1 Quick Check

141

(1)

Session 4.2

142

(1)

Creating a Form with a Main Form and a Subform

142

(5)

Modifying a Form in Design View

145

(2)

Creating a Report Using the Report Wizard

147

(11)

Checking Errors in a Report

155

(3)

Inserting a Picture in a Report

158

(2)

Session 4.2 Quick Check

160

(1)

Tutorial Summary

161

(1)

Key Terms

161

(1)

Review Assignments

161

(2)

Case Problems

163

(5)

Internet Assignments

168

(1)

SAM Assessment and Training

168

(1)

Quick Check Answers

168

Glossary/Index

(6)

Task Reference

Amazon no longer offers textbook rentals. We do!

New Perspectives on Microsoft Office Access 2003, Brief, CourseCard Edition

New Perspectives on Microsoft Office Access 2003, Brief, CourseCard Edition

9781418839079

1418839078

Summary

Table of Contents

Supplemental Materials

Write a Review

Amazon no longer offers textbook rentals. We do!

New Perspectives on Microsoft Office Access 2003, Brief, CourseCard Edition

New Perspectives on Microsoft Office Access 2003, Brief, CourseCard Edition

9781418839079

1418839078

Summary

Table of Contents

Supplemental Materials

Write a Review

Related Products