Course Info

MA2007-3 - Microsoft Access 2007: Advanced

Categories Applications Training, MOUS Certification Training, Microsoft Access Training, Database Training

Duration 1 day (7 hours)

Pre-requisites To have equivalent knowledge of Access 2007: Introduction and Access 2007: Intermediate levels, that is familiarity with basic and intermediate features of Access tables, relationships, queries, forms, and reports.

Courseware MA20073-EK (100 pages)

Price $195

Notes

This course builds on the skills and concepts taught in Access 2007: Intermediate. Students will learn how to query with SQL; create crosstab, parameter, and action queries; create macros; import, export, and link database objects; work with XML documents; work with Windows SharePoint Services; optimize databases; password-protect and encrypt databases; set Access options and properties; create hyperlink fields; and use Outlook 2007 to update data. 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.

Structuring Existing Data
      Analyze Tables
      Create a Junction Table
      Improve Table Structure
Writing Advanced Queries
      Create Subqueries
      Create Unmatched and Duplicate Queries
      Group and Summarize Records Using Criteria
      Summarize Data Using a Crosstab Query
      Create a PivotTable and a PivotChart
Simplifying Tasks with Macros
      Create a Macro
      Attach a Macro
      Restrict Records Using a Condition
      Validate Data Using a Macro
      Automate Data Entry Using a Macro
Making Effective Use of Forms
      Display a Calendar on a Form
      Organize Information with Tab Pages
      Display a Summary of Data in a Form
Making Reports More Effective
      Include a Chart in a Report
      Print Data in Columns
      Cancel Printing of a Blank Report
      Create a Report Snapshot
Maintaining an Access Database
      Link Tables to External Data Sources
      Manage a Database
      Determine Object Dependency
      Document a Database
      Analyze the Performance of a Database