ACC-207
 Access  2007 Intermediate

Course Length: 1 day

*Prerequisite*
Introduction to Access or equivalent working knowledge

Course Contents

Introduction

 

Lesson 1: Structuring Existing Data

Topic 1A: Analyze Tables

Topic 1B: Create a Junction Table

Topic 1C: Improve Table Structure

 

Lesson 2: Writing Advanced Queries

Topic 2A: Create Sub-queries

Topic 2B: Create Unmatched and Duplicate Queries

Topic 2C: Group and Summarize Records Using Criteria

Topic 2D: Summarize Data Using a Crosstab Query

Topic 2E: Create a PivotTable and a PivotChart

 

Lesson 3: Simplifying Tasks with Macros

Topic 3A: Create a Macro

Topic 3B: Attach a Macro

Topic 3C: Restrict Records Using a Condition

Topic 3D: Validate Data Using a Macro

Topic 3E: Automate Data Entry Using a Macro

 

Lesson 4: Making Effective Use of Forms

Topic 4A: Display a Calendar on a Form

Topic 4B: Organize Information with Tab Pages

Topic 4C: Display a Summary of Data in a Form

 

Lesson 5: Making Reports More Effective

Topic 5A: Include a Chart in a Report

Topic 5B: Print Data in Columns

Topic 5C: Cancel Printing of a Blank Report

Topic 5D: Create a Report Snapshot

 

Lesson 6: Maintaining an Access Database

Topic 6A: Link Tables to External Data Sources

Topic 6B: Manage a Database

Topic 6C: Determine Object Dependency

Topic 6D: Document a Database

Topic 6E: Analyze the Performance of a Database

 

 

 

Home
Solaris Programming Microsoft Desktop Linux Cisco Security
About SYSTEMS Computer Training
Contact Us

 

© 2003-2004 SYSTEMS Computer Training, A Testmasters Company

 

Solaris and Java are registered trademarks of Sun Microsystems.