1.0 Introduction
1.1 Starting Access
1.2 The Access Window, Menu Bar, Tool Bars and Task Pane
1.3 Help in Access
1.4 Creating a Database – Fields, Properties, and Datasheet View
1.5 Copying Databases

2.0 Working with an Existing Database
2.1 Viewing & Navigating Table Data
2.2 Widening Datasheet Columns and 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
3.1 Using a Form Wizard and Moving from Record to Record
3.2 Finding Data
3.3 Sorting Data
3.4 Filtering Data
3.5 AutoForms

4.0 Report Basics
4.1 AutoReports & the Report Wizard
4.2 Zooming In & Out
4.3 Moving from Page to Page
4.4 Viewing Multiple Pages
4.5 Printing

1.0 Planning & Designing a Database
1.1 Copy Database for Intermediate Lessons
1.2 Creating a Database Using a Wizard

2.0 Building & Modifying Tables
2.1 Evaluating Inputs and Outputs
2.2 Creating Tables Using a Wizard
2.3 Creating Tables without the Use of a Wizard, Field Properties, Input Masks
2.4 The Lookup Wizard
2.5 Format, Default Value, Validation Rules and Validation Text

3.0 Working with Relationships
3.1 Introduction to Relationships
3.2 Setting Primary Keys
3.3 Indexes, Relationships and Normalization
3.4 Printing Relationships

1.0 Designing Simple Queries
1.1 Selecting Fields in Single and Multiple Tables
1.2 Ordering the Query Result & Refining Queries with Criteria
1.3 Updatability of Query Results

2.0 Building and Modifying Forms
2.1 Adding Controls
2.2 Selecting, Moving, Sizing, Deleting and Aligning Controls
2.3 Changing Control Properties
2.4 Changing the Tab Order Controls and Form Properties
2.5 Working with Combo Boxes & List Boxes

3.0 Building & Modifying Reports
3.1 Creating Groups and Total Reports
3.2 Understanding Report Bands
3.3 Working with Controls
3.4 Working with Report Properties
3.5 Modifying Selection Criteria

4.0 Managing Databases
4.1 Identify Object Dependencies
4.2 Import Data to Access
4.3 Export data from Access
4.4 Create and Modify Calculated Fields and Aggregate Functions
4.5 Create a Data Access Page
4.6 Back up a database
4.7 Compact and repair databases