Microsoft Access Advanced

1 Day
Versions 2007 and 2010 (View Version 2003 Agenda)

This instructor-led course, through lecture and hands-on exploration, will teach you 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.  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.  You should feel comfortable creating basic queries, forms and reports in Access.

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

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

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

 

Related Courses

Access - Introduction Agenda

Access - Intermediate Agenda

Access - Advanced Agenda

Access - VBA Programming Agenda

Database Design


Not Sure What Level to Take?

Before taking the Intermediate or Advanced level class for this application, we ask that you take our free assessment to determine whether you are comfortable with the topics covered in the Introductory level class. Or, feel free to contact our office at (202) 747-5000 to speak with a representative to discuss the prerequisites.

Find us
Find us on Facebook  Find us on Twitter

Register online

Are you interested in a class for one or a few students? Consider taking a public class. View our public training schedule for dates.

Or, are you interested in scheduling a private group class at your office or at Softek? Learn more about our private group training.

Top of Page
Softek Services, Inc.