CERTIFICATIONS

PROGRAMS

LEARN > Find a Class > Class Summary

APAC033 - Microsoft Office Access 2003 Level 3

If you have any questions about registering for this class, please call (877) 832-0688 Ext. 1493 or email us at getsmart@LRS.com

Students will create complex Access databases using forms, reports, and macros.

Prerequisites

Course APAC031: Microsoft Office Access 2003 Introduction or equivalent knowledge

Detailed Class Syllabus

Lesson 1: Structuring Existing Data

Import Data

Analyze Tables

Create a Junction Table

Improve Table Structure

Lesson 2: Writing Advanced Queries

Create Unmatched and Duplicates Queries

Group and Summarize Records Using the Criteria Field

Summarize Data with a Crosstab Query

Create a PivotTable and a PivotChart

Display a Graphical Summary on a Form

Lesson 3: Simplifying Tasks with Macros

Create a Macro

Attach a Macro to a Command Button

Restrict Records Using a Where Condition

Lesson 4: Adding Interaction and Automation with Macros

Require Data Entry with a Macro

Display a Message Box with a Macro

Automate Data Entry

Lesson 5: Making Forms More Effective

Change the Display of Data Conditionally

Display a Calendar on a Form

Organize Information with Tab Pages

Lesson 6: Making Reports More Effective

Cancel Printing of a Blank Report

Include a Chart in a Report

Arrange Data in Columns

Create a Report Snapshot

Lesson 7: Maintaining an Access Database

Link Tables to External Data Sources

Back Up a Database

Compact and Repair a Database

Protect a Database with a Password

Determine Object Dependency

Document a Database

Analyze the Performance of a Database