Course Info

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