Intermediate Access 2003

Note: Although South Hills offers three levels of Access training, each class builds on concepts learned in the previous class. These classes are designed to be taken in series with each preceding level a prerequisite for the next. You need to be completely comfortable with concepts offered in the first Access class before you will benefit from the second or third.

Unit 1: Relational databases
Topic A: Database normalization
Topic B: Relating tables
Topic C: Implementing referential integrity

Unit 2: Working with related tables
Topic A: Lookup fields
Topic B: Modifying Lookup fields
Topic C: Subdatasheets

Unit 3: Complex queries
Topic A: Joining tables in queries
Topic B: Creating calculated fields
Topic C: Summarizing and grouping values

Unit 4: Advanced form design
Topic A: Adding unbound controls
Topic B: Graphics
Topic C: Adding calculated values
Topic D: Adding combo boxes

Unit 5: Advanced reports
Topic A: Customized headers and footers
Topic B: Adding calculated values
Topic C: Subreports

Unit 6: Charts
Topic A: Charts in forms
Topic B: Charts in reports

Unit 7: PivotTables and PivotCharts
Topic A: PivotTables
Topic B: Modifying PivotTables
Topic C: PivotCharts

Unit 8: Internet integration
Topic A: Hyperlink fields
Topic B: Working with data access pages

Appendix A: Microsoft Office Specialist exam objectives map
Topic A: Comprehensive exam objectives