Intermediate Microsoft Access

1 Day, 9:00-4:00

Course Overview

This instructor-led course, through lecture and hands-on exploration, will teach students how to create more complex databases that link multiple tables; work with more advanced elements in tables, forms, queries, and reports; and import and export data to and from Access. This course is geared for users who are comfortable creating basic tables, forms, queries, and reports.

Course Objectives

Import and export data from various sources
Use lookup lists, input masks, and default values to control data entry
Enhance data entry forms and use shortcuts for aligning objects
Create queries that “prompt” for criteria
Write a variety of action queries to calculate and change data
Add more sophisticated elements to reports

Course Outline

Importing Information from Other Sources

Understanding Data Sources Access Can Import
Importing Excel Workbooks
Importing Text Files
Importing Access Tables
Appending Records from One Table to Another

Applying Field Properties to Validate Data Entry

Creating Lookup Lists
Creating Table or Query Lookup Lists
Creating Value Lookup Lists
Modifying Value Lookup Fields
Specifying Default Values
Creating Input Masks

Enhancing Data Entry Forms

Updating Fields with Property Changes
Shortcuts for Selecting Objects
Automatically Sizing Objects
Automatically Aligning Objects
Automatically Spacing Objects
Adjusting the Tab Order
Adding Command Buttons to Forms

Creating More Advanced Queries

Using Parameters to Prompt for Criteria
Prompting for One Value
Prompting for Two Values
Writing Expressions or Calculations Queries
Creating Total Queries
Working with Update Queries
Globally Change Data
Transfer Matching Data
Running Queries to Archive Information
Creating Make Table Queries
Creating Delete Queries

Enhancing Reports

Creating Reports Using the Report Tool
Sorting and Grouping Data
Inserting Graphic Lines
Previewing Pages in Print Preview
Keeping Records Together
Repeating Group Headers on the Top of Every Page
Writing Expressions and Calculations on Reports
Writing Expressions
Writing Calculations

Exporting Information Out of Access

Exporting Tables and Queries to Excel
Exporting Reports to Word
Using Access Tables or Queries in a Mail Merge

Cost and Delivery Format Options

We offer the above listed class on our public schedule and as a private group class in the following delivery formats:

Public Class: Live Virtual
Per student	$325

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

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

Private Group Training

Private group classes are cost effective when you have a group of students who need the same course. 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.