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/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