Register Now      202-747-5000

Advanced Microsoft Access

365 | 2019 | 2016
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/Investment

Public Course at Softek Private Course at Your Office Private Course at Softek
$275 per student $850 flat fee up to 8 students $1000 flat fee up to 8 students
or 1 voucher $950 flat fee up to 12 students $1100 flat fee up to 12 students
10% discount when 3+ attend $50 per additional student $50 per additional student

Private Group Training

Private group courses are cost effective when you have a group of students who need the same course. Pricing is based on the maximum number of students anticipated per day per course. Volume discounts of 5% to 20% are available when five or more training days are scheduled. For classes conducted at your office, you are responsible for the classroom setup, including student computers, instructor station, LCD projector, and software installation. For courses conducted at Softek, we take care of classroom setup.

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 $125 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. There is a 2-hour minimum fee for customization.

Why Choose Softek?

  • Live, in-person training
  • Instructors with 10+ years of experience
  • Detailed training guide
  • Certificate of completion
  • Money-back guarantee