Days of training: 1

Prerequisites: Access 2007 Basic or equivalent experience

Relational databases
Database normalization
Relating tables
Implementing referential integrity

Related tables
Lookup fields
Modifying lookup fields
Subdatasheets

Complex queries
Joining tables in queries
Calculated fields
Summarizing and grouping values

Advanced form design
Adding unbound controls
Adding Graphics
Adding calculated values
Adding combo boxes
Advanced form types

Reports and printing
Customized headers and footers
Adding calculated values
Printing
Labels

Charts
Charts in forms
Charts in reports

PivotTables and PivotCharts
PivotTables
Modifying PivotTables
PivotCharts
PivotTable forms