Revision -
Database design and Basic Table Structures
Basic Queries
Basic form Creation
Review - Basic Report Creation

Table Structures
Importing external data (Excel, Access etc)
Validating data
Field formats
Custom input masks
Renaming tables

Joining Tables
Defining relationships between tables - One to one - One to many - Many to many
Referential integrity
Different types of Table joins

Working with Queries
Parameter queries
Calculated queries
Summary queries
Update
Delete
Append
Make table

Forms and Subforms
Parent and child forms
Adding controls to forms
Combo boxes
Option groups
Labels
Unbound fields

Building a User Interface
Command buttons
Designing menus
Controlling form behaviour
Form properties

Using Advanced Reporting
Now()
Page()
Sum()
Group totals
Sub reports
Mailing Labels

Macros
Creating Macros
Expression builder
Using conditions

Useful Functions
IIF()