Access Intermediate - $125

• July 22 & 24, 9:00 - 12:00 Noon
• August 4 & 6, 5:30 - 8:30 pm
• October 28 & 30, 1:00 - 4:00 pm
• December 15 & 17, 5:30 - 8:30 pm

• Access Basics or equivalent experience

• 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 Pivot Charts
  Topic A: PivotTables
  Topic B: Modifying PivotTables
  Topic C: Pivot Charts


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