Advanced Microsoft Access

1 Day, 9:00-4:00

Course Overview

This instructor-led course, through lecture and hands-on exploration, will teach students the 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. This course is geared for users who are comfortable creating basic tables, forms, queries, and reports.

Course Objectives

Create advanced queries that generates crosstabs, find duplicates, and unions data
Customize subforms and add tab controls to layer data
Adjust report sources and add on-the-fly print titles
Create macros to run commands via a button
Create a main menu that allows users to easily navigate through database functions
Understand best practices for working with a shared database

Course Outline

Creating Queries to Validate and Analyze Data

Creating Crosstab Queries
Editing Crosstab Queries
Creating Crosstabs Using Dates
Finding Duplicate Records
Finding Matches and Non-Matches Between Tables
Creating Union Queries

Adding Advanced Form Elements

Changing the View of Subforms
Working with Tab Controls
Adding Tab Controls
Adding or Moving Fields into Tab Controls
Resizing Tab Controls
Modifying the Caption Property
Inserting and Deleting Page Tabs
Changing the Order of Page Tabs
Saving Forms as Reports

Adding Advanced Report Elements

Changing the Record Source of Objects
Including Parameters in Report Titles

Creating Basic Macros

Creating Macros to Preview Reports from Forms
Attaching Macros to Command Buttons
Running Macros

Creating a Switchboard or Main Menu

Creating Main Menu Switchboards
Adding Items to Switchboards
Opening Switchboards
Creating Additional Switchboards
Navigating Between Switchboards
Viewing Switchboard Items
Displaying Switchboards on Startup

Sharing and Maintaining a Database

Sharing Databases on a Network
Refraining from Design Changes
Finding Out if Other Users are in the Database
Opening Databases in Exclusive Mode
Setting Database Passwords
Linking Tables Between Databases
Compacting and Repairing Databases
Using the Back Up Database Feature
Printing Database Object Information

Cost and Delivery Format Options

We offer the above listed class as a private group class in the following delivery formats:

Live Virtual
1-4 students	$700
5-8 students	$850
9-12 students*	$950
*$50 per additional student

At Your Location
1-4 students	$950
5-8 students	$1100
9-12 students*	$1200
*$50 per additional student

Private Group Training

Volume discounts of 5% to 20% are available when five or more training days are scheduled. For classes conducted at your location, you are responsible for the classroom setup which should include:

A computer for each student (with the appropriate software installed), and
An instructor workstation connected to a visual display (e.g., projector, smartboard, etc.).

Customization

Softek can easily customize a training course that covers the specific topics you require and integrate examples relevant to your work environment. Course customization is billed at $150 per hour and covers time needed to meet, discuss, prepare, and incorporate any specific examples into the training program. Once we have a better idea of what you have in mind, we will be glad to provide a specific price quote for the customization.