Enquiry Form

Duration: 1 Day

Access 2003 Intermediate

Relational databases

• Database normalization
• Relating tables
• Implementing referential integrity

Working with related tables

• Using the Lookup Wizard
• Modifying Lookup fields
• Adding data to related tables

Complex queries

• Joining tables in queries
• Creating calculated fields
• Summarizing and grouping values

Advanced form design

• Adding unbound controls
• Adding graphics
• Adding calculations
• Adding combo boxes

Advanced reports

• Creating customized headers and footers
• Adding calculated values
• Working with subreports

Creating charts

• Creating charts in forms
• Creating charts in reports

PivotTables and PivotCharts

• Creating PivotTables
• Modifying PivotTables
• Working with PivotCharts