Search Courses
Class Details         [printable version]
Access 2003: Intermediate Register     
Course Number: AP0009
Category: Business & Office Applications
Location: ExecuTrain of Wichita
Duration: 1.00 day
Price: $225
Date: 06/11/2010
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