The following MA2007-2 classes are currently scheduled:

Wed May 14 (day)
Wed Jun 11 (day)
Wed Jul 16 (day)
Wed Aug 13 (day)
Wed Sep 17 (day)

Bad or missing query parameters in request.
Get Extended Forecast!

MA2007-2 - Microsoft Access 2007: Intermediate

Categories	Database Training, Applications Training, MOUS Certification Training, Microsoft Access Training
Duration	1 day (7 hours)
Pre-requisites	To ensure the successful completion of Microsoft Office Access 2007: Intermediate, the completion of the Microsoft Office Access 2007: Introduction course, or equivalent knowledge, is recommended.
Courseware	MA20072-TL (208 pages)
Price	$195
Notes

This course builds on the skills and concepts taught in Access 2007: Basic. Students will learn how to normalize data; work with Lookup fields and subdatasheets; create join queries; add objects to forms, print reports and labels; create charts; and use PivotTables and PivotCharts. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Basic, Intermediate, and Advanced.

---

Relational databases
      Database normalization
      Relating tables
      Implementing referential integrity
Related tables
      Lookup fields
      Modifying lookup fields
      Subdatasheets
Complex queries
      Joining tables in queries
      Calculated fields
      Summarizing and grouping values
Advanced form design
      Adding unbound controls
      Adding Graphics
      Adding calculated values
      Adding combo boxes
      Advanced form types
Reports and printing
      Customized headers and footers
      Adding calculated values
      Printing
      Labels
Charts
      Charts in forms
      Charts in reports
PivotTables and PivotCharts
      PivotTables
      Modifying PivotTables
      PivotCharts
      PivotTable forms