Microsoft Access Level 3 Training Class

Training Menu

Microsoft Access Level 3: Advanced

This is a one day, advanced class. It assumes you have take both the Access Level 1 and Access Level 2 classes (or you have gained equivalent knowledge on your own).

Target Student:

Students enrolling in this course should have a good, basic understanding of Microsoft Access.

Course outline:

Lesson 1: Parameter and Action Queries

Topic 1A: Creating Parameter Queries

Topic 1B: Creating Action Queries

Lesson 2: Query Joins and Crosstab Queries

Topic 2A: Joining Tables and Working with Join Properties

Topic 2B: Creating Crosstab Queries

Topic 2C: Editing Limitations in Query Datasheets

Lesson 3: Using Advanced Form Techniques

Topic 3A: Organizing Field Placement

Topic 3B: Using Functions to Control Data Entry

Topic 3C: Adding an Option Group to a Form

Topic 3D: Using a Form as the User Interface

Topic 3E: Creating a Form that Contains a Subform

Lesson 4: Creating Basic Macros to Automate Forms

Topic 4A: Macro Basics

Topic 4B: Attaching a Macro to a Command Button

Topic 4C: Revising a Macro

Lesson 5: Using Macros to Provide User Interaction and Automate Tasks

Topic 5A: Using a Macro to Provide User Interaction

Topic 5B: Using Macros to Automate Data Entry

Topic 5C: AutoKeys and AutoExec Macros

Lesson 6: Using Advanced Report Techniques

Topic 6A: Customizing the Appearance and Functionality of a Report

Lesson 7: Web Capabilities and Data Integration

Topic 7A: Creating and Using Hyperlinks

Topic 7B: Data Integration

Appendix A: Replicating Databases

Using Simple Replication

Appendix B: Encrypting Databases

Encrypting and Decrypting a Database

Appendix C: Mailing Labels

The Mailing Label Report Wizard