Introduction

• Review of basic concepts:
• Design concepts
• Relationships between tables

Designing Queries

• Using And and Or statements
• Totals Queries
• Creating calculations in queries
• Parameter Queries
• Autolookup Queries

Designing Forms

• Adding controls
• Working with combo boxes
• Working with calculated controls
• Control properties
• Working with subforms

Report Design

• Creating a report using the Wizard
• Designing grouped reports
• Adding sub-totals to reports

Macros

• Creating simple macros
• Creating grouped macros
• Creating conditional macros
• Assigning macros to command buttons
• Creating a Switchboard
• Using macros to pass conditions between forms
• Using macros to pass conditions to run reports