Microsoft Access Advanced

1 Day
Versions XP, 2003 and 2007

Course Description

This instructor-led, hands-on course teaches the basic skills needed to create complex queries to validate and analyze data, add advanced elements to existing forms and reports, and work with features that automate the database and allow for multi-user access.

Prerequisites

This course is designed for users who are comfortable working in the Design View of queries, forms and reports in Microsoft Access and need to expand their knowledge. In order to successfully complete this course, we recommend that you first take Softek’s Introduction to Access and Intermediate Access courses or have equivalent knowledge.

Creating Queries to Validate and Analyze Data

Creating Crosstab Queries

Finding Duplicate Records

Finding Matches and Non-matches Between Tables

Creating a Union Query

Adding Advanced Form Elements

Changing the View of Subforms

Creating a Form Using the New Object Function

Using Tab Controls on a Form

Creating Reports from a Form

Adding Advanced Report Elements

Viewing and Changing Report's Record Source

Modifying a Query from Within the Report Designer

Including Parameters in a Report Title

Hiding Duplicate Detail Values

Creating Basic Macros

Creating a Macro to Preview/Print a Report While Viewing a Form

Attaching a Macro to a Command Button

Running a Macro

Creating a Macro to Open a Form

Creating a Switchboard or Main Menu

Creating a Main Menu Switchboard

Creating a Second Switchboard to Serve as a Reports Menu

Opening the Report Switchboard from the Main Menu

Opening a Switchboard

Understanding the Switchboard Items Table

Displaying the Switchboard When the Database Opens

Sharing and Maintaining a Database

Sharing a Database on a Network

Opening a Database in Exclusive Mode

Setting a Database Password

Linking to Tables in Another Database

Compacting and Repairing a Database

Backing Up a Database

Printing Information About Database Objects

Is this the right level for you? Please contact our office at 202.682.4500 if you have any questions.