Access 2003 Training (Intermediate)

Description:

This ILT Series course, rated 4.9/5.0 in overall quality by ProCert Labs, teaches intermediate-level features and functions of Access 2003. 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.

Outline:

• 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

--------------

Please note that the material taught at some locations may differ slightly from the outline shown above. Please contact your local ExecuTrain office if you have any questions about specific course content.