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-EK (100 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.

Controlling Data Entry
      Restrict Data Entry Using Field Properties
      Establish a Pattern for Entering Field Values
      Create a List of Values for a Field
Joining Tables
      Create Query Joins
      Join Unrelated Tables
      Relate Data Within a Table
Creating Flexible Queries
      Set Select Query Properties
      Create Parameter Queries
      Create Action Queries
Improving Forms
      Design a Form Layout
      Enhance the Appearance of a Form
      Restrict Data Entry in Forms
      Add a Command Button to a Form
      Create a Subform
Customizing Reports
      Organize Report Information
      Format the Report
      Set Report Control Properties
      Control Report Pagination
      Summarize Report Information
      Add a Subreport to an Existing Report
      Create a Mailing Label Report
Sharing Data Across Applications
      Import Data into Access
      Export Data
      Analyze Access Data in Excel
      Export Data to a Text File
      Merge Access Data with a Word Document