Lesson 1: Creating Relational Databases

• Analyzing Table Relationships
• Relating Tables
• Testing Referential Integrity

Lesson 2: Working with Related Tables

• Using the Lookup Wizard
• Modifying Lookup Fields
• Adding Data to Related Tables

Lesson 3: Defining Data Entry Rules

• Working with Input Masks
• Setting Required Properties
• Setting Validation Rules
• Setting Lookup Fields

Lesson 4: Using Advanced Query Features

• Joining Tables in Queries
• Creating Calculated Fields
• Using Action Queries

Lesson 5: Creating Advanced Queries

• Summarizing and Grouping Values
• Creating Crosstab Queries
• Using Parameter Queries
• Using Indexes

Lesson 6: Enhancing Forms

• Adding Graphics to a Form
• Adding Calculations to a Form
• Adding Combo Boxes to a Form
• Adding Unbound Controls

Optional Topic

• Creating Charts
• Creating Charts in Forms
• Creating Charts in Reports