Access 2003: Beginner Level

• 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

Access 2003: Intermediate Level

• 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

Access 2003: Advanced Level

• 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