search for books and compare prices
Tables of Contents for New Perspectives on Microsoft Access 2000
Chapter/Section Title
Page #
Page Count
Preface
iii
 
Tutorial Tips
viii
 
Microsoft Access 2000---Level I Tutorials
1
1
Read This Before You Begin
2
1
Introduction to Microsoft Access 2000
3
 
Session 1.1
4
10
Introduction to Database Concepts
4
1
Organizing Data
4
1
Databases and Relationships
5
1
Relational Database Management Systems
6
1
Starting Access
7
2
Opening an Existing Database
9
1
The Access and Database Windows
10
1
Opening an Access Table
11
1
Navigating an Access Datasheet
12
1
Printing a Table
13
1
Exiting Access
13
1
Quick Check
13
1
Session 1.2
14
 
Creating and Printing a Query
14
3
Creating and Printing a Form
17
2
Getting Help
19
1
Finding Information with the Office Assistant
19
4
Creating, Previewing, and Printing a Report
23
2
Compacting a Database
25
1
Compacting and Repairing a Database
25
1
Compacting a Database Automatically
26
1
Backing Up and Restoring a Database
27
1
Session 1.2 Quick Check
27
1
Review Assignments
27
1
Case Problems
28
3
Internet Assignments
31
1
Lab Assignments
31
1
Quick Check Answers
32
 
Maintaining a Database
1
1
Session 2.1
1
20
Guidelines for Designing Databases
2
2
Guidelines for Designing Access Tables
4
1
Naming Fields and Objects
4
1
Assigning Field Data Types
4
1
Assigning Field Sizes
5
1
Creating a Table
6
2
Defining Fields
8
6
Specifying the Primary Key
14
2
Saving the Table Structure
16
1
Adding Records to a Table
17
3
Saving a Database
20
1
Session 2.1 Quick Check
20
1
Session 2.2
21
 
Modifying the Structure of an Access Table
21
1
Deleting a Field
21
1
Moving a Field
22
1
Adding a Field
23
1
Changing Field Properties
24
3
Copying Records from Another Access Database
27
2
Using the Office Clipboard
29
1
Updating a Database
30
1
Deleting Records
30
1
Changing Records
31
3
Session 2.2 Quick Check
34
1
Review Assignments
34
2
Case Problems
36
5
Internet Assignments
41
1
Quick Check Answers
41
 
Querying a Database
1
1
Session 3.1
2
17
Introduction to Queries
2
1
Query Window
2
2
Creating and Running a Query
4
2
Defining Table Relationships
6
1
One-to-Many Relationships
7
1
Referential Integrity
8
1
Defining a Relationship Between Two Tables
8
4
Sorting Data in a Query
12
1
Using a Toolbar Button to Sort Data
13
1
Sorting Multiple Fields in Design View
14
3
Filtering Data
17
2
Session 3.1 Quick Check
19
1
Session 3.2
19
 
Defining Record Selection Criteria for Queries
20
1
Specifying an Exact Match
20
3
Changing a Datasheet's Appearance
23
1
Using a Comparison Operator to Match a Range of Values
24
2
Defining Multiple Selection Criteria for Queries
26
1
The And Logical Operator
27
1
The Or Logical Operator
28
2
Performing Calculations
30
1
Creating a Calculated Field
30
4
Using Aggregate Functions
34
2
Using Record Group Calculations
36
1
Session 3.2 Quick Check
37
1
Review Assignments
38
1
Case Problems
39
3
Internet Assignments
42
1
Quick Check Answers
42
 
Creating Forms and Reports
1
1
Session 4.1
2
13
Creating a Form Using the Form Wizard
2
3
Changing a Form's AutoFormat
5
2
Navigating a Form
7
1
Finding Data Using a Form
8
3
Previewing and Printing Selected Form Records
11
1
Maintaining Table Data Using a Form
12
2
Session 4.1 Quick Check
14
1
Session 4.2
15
 
Creating a Form with a Main Form and a Subform
15
3
Creating a Report Using the Report Wizard
18
9
Inserting a Picture in a Report
27
5
Converting an Access 2000 Database to a Previous Version
32
1
Session 4.2 Quick Check
32
1
Review Assignments
33
1
Case Problems
34
3
Internet Assignments
37
1
Quick Check Answers
38
 
Index
1
5
Task Reference
6
2
File Finder
8