Access 2003: Intermediate

Course Outline

Duration: 1 Day

Prerequisites: Access 2003: Basic or equivalent experience

Description: Students will learn how to set table relationships, work with Lookup fields and subdatasheets, create join queries, create PivotTables and PivotCharts, and use hyperlink fields and data access pages. This course is approved courseware for Microsoft Office Specialist certification.

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: Creating 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: Pivot Tables and PivotCharts

Topic A: Pivot Tables

Topic B: Modifying Pivot Tables

Topic C: Pivot Charts

Unit 8: Internet integration

Topic A: Hyperlink fields

Topic B: Working with data access pages

Appendix A: MOUS exam objectives map

Topic A: Comprehensive exam objectives