Proudly serving the D.C. metro
area for over 25 years.


Softek Services, Inc.
1156 15th Street, NW, Suite 100
Washington, DC 20005
(202) 747-5000

Computer Training Software Consulting Database Programming

Get tips on our Facebook Find us on Google+ Tweet Us Read Reviews on Yelp Softek on Linkedin

  • Instructor-led Training Instructor-led Training
  • Join a Public Class Join a Public Class
  • Private Group Classes Private Group Classes
  • Transition Classes Transition Classes
  • Virtual Training Virtual Training
  • Customization & Documentation Customization & Documentation
  • Web and Database Development Web and Database Development
  • We Have Classrooms We Have Classrooms
     

Intermediate Microsoft Access

Version 2010 • 2013 • 2016

1 Day, 9:00-4:00, 6 Hours

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

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 More Advanced Queries
(cont'd)

  • 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

View Upcoming Schedule or Register for a Class

Not Sure What Level to Take?

Before taking the Intermediate or Advanced level class for this application, we ask that you 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.

Back to Agenda

 

Investment

Public Class

$275 per student
Or one voucher

View Schedule or Register

Private Group Classes

Conducted at Your Office

$850 flat fee for up to 8 students
$950 for up to 12 students
$50 per additional student

Conducted at Softek’s Facility

$1000 flat fee for up to 8 students
$1100 for up to 12 students
$50 per additional student

Have more or fewer students? Or, need to schedule more than one training day? Fill out our quote request form for a price quote based on your training needs. 

Softek also offers a 3-hour series for this application. Visit our agendas page  to view our 3-hour classes. 

Why choose Softek?

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