Register Now      202-747-5000

Intermediate 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 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 or at Softek
Per student $275
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 or Softek
1-4 students $850
5-8 students $1000
9-12 students* $1100
*$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 $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, virtual or in-person training
  • Instructors with 10+ years of experience
  • Detailed training guide
  • Certificate of completion
  • Money-back guarantee