Access 2007 Advanced - Full Day Class Personalize our class outlines. We'll create a class just for you.

Printable Version  |  See Other Class Topics  |  See All Class Outlines


Overview

Upon successful completion of this training class, students will be able to:

  • Restructure data into appropriate tables to ensure data dependency and minimize redundancy
  • Write advanced queries to analyze and summarize data
  • Create and revise Access macros. display data more effectively in a form
  • Customize reports by using various Access features, making them more effective
  • Maintain your database using tools provided by Access

Course content

Lesson 1: Structuring Existing Data

  1. Analyze Tables
  2. Create a Junction Table
  3. Improve the Table Structure

Lesson 2: Writing Advanced Queries

  1. Create Subqueries
  2. Create Unmatched and Duplicate Queries
  3. Group and Summarize Records Using Criteria
  4. Summarize Data Using a Crosstab Query
  5. Create a PivotTable and a PivotChart

Lesson 3: Simplifying Tasks with Macros

  1. Create a Macro
  2. Attach a Macro
  3. Restrict Records Using a Condition
  4. Validate Data Using a Macro
  5. Automate Data Entry Using a Macro

Lesson 4: Making Effective Use of Forms

  1. Display a Calendar on a Form
  2. Organize Information with Tab Pages
  3. Display a Summary of Data in a Form

Lesson 5: Making Reports More Effective

  1. Include a Chart in a Report
  2. Print Data in Columns
  3. Cancel Printing of a Blank Report
  4. Create a Report Snapshot

Lesson 6: Maintaining an Access Database

  1. Link Tables to External Data Sources
  2. Manage a Database
  3. Determine Object Dependency
  4. Document a Database
  5. Analyze the Performance of a Database

If you would like to customize this training class, please contact us at (888) 572-1200.

Have a Question?

Give us a call at (888) 572-1200 or contact us for fast attention.

Get in touch!