Keystone Learning Systems

Beginning Access (2 Hrs 6 Mins)

1.0 Introduction (26 Mins)

1.1 Starting Access

1.2 Opening an Existing Database

1.3 The Access Desktop

1.4 The Database Window

1.5 A Preview of the Database Components

2.0 Working with an Existing Database (33 Mins)

2.1 Viewing & Navigating Table Data

2.2 Editing Table Data

2.3 Adding Records to a Table

2.4 Selecting & Deleting Records

2.5 Find & Replace

2.6 Modifying the Appearance of a Datasheet

2.7 Spell-Check & Auto-correct

3.0 Form Basics (25 Mins)

3.1 Moving from Record to Record

3.2 Finding

3.3 Sorting

3.4 Filtering

3.5 AutoForms

3.6 Using a Form Wizard

3.7 Conditional Formatting

4.0 Report Basics (15 Mins)

4.1 Moving form Page to Page

4.2 Zooming In & Out

4.3 Viewing Multiple Pages

4.4 Printing

4.5 AutoReports & the Report Wizard

4.6 Page Setup

5.0 Printing Database Objects (5 Mins)

5.1 Printing Table Datasheets

5.2 Printing Queries

5.3 Printing Forms

5.4 Printing Reports

6.0 Getting Help (8 Mins)

6.1 The Office Assistant & Index Searching

6.2 Context-Sensitive Help & Printing Help Topics

7.0 Database Maintenance & Shortcuts (12 Mins)

7.1 Backing Up & Restoring a Database

7.2 Compacting & Repairing a Database

7.3 Converting a Database to a Previous Version

7.4 Organizing Database Objects into Groups