Why Rent from Knetbooks?

Because Knetbooks knows college students. Our rental program is designed to save you time and money. Whether you need a textbook for a semester, quarter or even a summer session, we have an option for you. Simply select a rental period, enter your information and your book will be on its way!

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

1

(2)

Read This Before You Begin

2

(1)

Using Common Features of Microsoft Office 2003

3

Preparing Promotional Materials

3

(1)

Exploring Microsoft Office 2003

4

(1)

Integrating Office Programs

5

(1)

Starting Office Programs

5

(4)

Switching Between Open Programs and Files

8

(1)

Exploring Common Window Elements

9

(1)

Using the Window Sizing Buttons

9

(2)

Using Menus and Toolbars

11

(3)

Viewing Personalized Menus and Toolbars

11

(3)

Using Task Panes

14

(2)

Opening and Closing Task Panes

14

(1)

Navigating Among Task Panes

15

(1)

Using the Research Task Pane

16

(2)

Working with Files

18

(5)

Creating a File

19

(1)

Saving a File

19

(2)

Closing a File

21

(1)

Opening a File

22

(1)

Getting Help

23

(6)

Using ScreenTips

23

(1)

Using the Type a Question for Help Box

23

(2)

Using the Help Task Pane

25

(2)

Using Microsoft Office Online

27

(2)

Printing a File

29

(1)

Exiting Programs

30

(1)

Quick Check

31

(1)

Tutorial Summary

31

(1)

Key Terms

31

(1)

Review Assignments

31

(1)

SAM Assessment and Training

32

(1)

Quick Check Answers

32

Access

1

(1)

Read This Before You Begin

2

(1)

Introduction to Microsoft Access 2003

3

(32)

Viewing and Working with a Table Containing Employer Data

3

(1)

Session 1.1

4

(1)

Introduction to Database Concepts

4

(3)

Organizing Data

4

(1)

Databases and Relationships

5

(1)

Relational Database Management Systems

6

(1)

Opening an Existing Database

7

(3)

Exploring the Access and Database Windows

9

(1)

Opening an Access Table

10

(2)

Navigating an Access Datasheet

11

(1)

Printing a Datasheet

12

(1)

Saving a Database

12

(1)

Session 1.1 Quick Check

13

(1)

Session 1.2

13

(1)

Working with Queries

13

(5)

Opening an Existing Query

14

(1)

Creating, Sorting, and Navigating a Query

15

(3)

Creating and Navigating a Form

18

(2)

Creating, Previewing, and Navigating a Report

20

(4)

Printing Specific Pages of a Report

23

(1)

Managing a Database

24

(4)

Backing up and Restoring a Database

24

(1)

Compacting and Repairing a Database

25

(1)

Compacting a Database Automatically

26

(1)

Converting an Access 2000 Database

27

(1)

Session 1.2 Quick Check

28

(1)

Tutorial Summary

29

(1)

Key Terms

29

(1)

Review Assignments

29

(1)

Case Problems

30

(3)

Internet Assignments

33

(1)

SAM Assessment and Training

33

(1)

Lab Assignments

34

(1)

Quick Check Answers

34

(1)

Creating and Maintaining a Database

35

(46)

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

35

(1)

Session 2.1

36

(1)

Guidelines for Designing Databases

36

(2)

Guidelines for Setting Field Properties

38

(3)

Naming Fields and Objects

38

(1)

Assigning Field Data Types

38

(1)

Setting Field Sizes

39

(1)

Setting Field Captions

40

(1)

Creating a New Database

41

(1)

Creating a Table

42

(11)

Defining Fields

43

(7)

Specifying the Primary Key

50

(2)

Saving the Table Structure

52

(1)

Session 2.1 Quick Check

53

(1)

Session 2.2

53

(1)

Adding Records to a Table

53

(3)

Modifying the Structure of an Access Table

56

(9)

Deleting a Field

57

(1)

Moving a Field

58

(1)

Adding a Field

59

(1)

Changing Field Properties

60

(1)

Updating Field Property Changes

61

(4)

Obtaining Data from Another Access Database

65

(3)

Copying Records from Another Access Database

65

(2)

Importing a Table from Another Access Database

67

(1)

Updating a Database

68

(3)

Deleting Records

68

(1)

Changing Records

69

(2)

Session 2.2 Quick Check

71

(1)

Tutorial Summary

71

(1)

Key Terms

72

(1)

Review Assignments

72

(2)

Case Problems

74

(5)

Internet Assignments

79

(1)

SAM Assessment and Training

80

(1)

Quick Check Answers

80

(1)

Querying a Database

81

(48)

Retrieving Information About Employers and Their Positions

81

(1)

Session 3.1

82

(1)

Introduction to Queries

82

(1)

Query Window

82

(2)

Creating and Running a Query

84

(3)

Updating Data Using a Query

87

(1)

Defining Table Relationships

87

(6)

One-to-Many Relationships

88

(1)

Referential Integrity

89

(1)

Defining a Relationship Between Two Tables

89

(4)

Creating a Multi-table Query

93

(2)

Sorting Data in a Query

95

(5)

Using a Toolbar Button to Sort Data

95

(1)

Sorting Multiple Fields in Design View

96

(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