Computer and Business Skills training

Sign Up
Home / Access / Level 3

Microsoft Access Training Course Level 3


Course Description

This hands-on advanced course is suitable for Access 2010/201/2016 users.


Live face-to-face instructor-led training. No minimum class size - all classes guaranteed to run.


You will learn topics such as data validation, macros, advanced queries, form design and reporting, and advanced database tools.


Students should have completed our Intermediate class or have the equivalent knowledge prior to attending.

View our full range of Access training courses, or see below for the detailed outline for Access Level 3.


1 Day | $350.00


Book this course

Detailed course outline

  • Validation Rules and Messages
    • Creating a Field Validation Rule
    • Creating a Field Validation Message
    • Creating a Validation Rule
    • Creating a Validation Message
    • Testing Validation Rules
  • Working with Macros
    • Creating a Before Change Event
    • Working with the Macro Tools Design Tab
    • Working with the Action Catalog
    • Creating an After Event
    • Creating a Named Macro
    • Renaming or Deleting Macros
  • Advanced Query Tasks
    • Using Query Design View
    • Creating Ad Hoc Relationships
    • Creating an Update Query
    • Creating a Parameter Query
    • Comparing Two Tables by Using a Join
  • Designing Forms
    • Common Formatting Tasks
    • Using Themes
    • Working with Controls
    • Adding Header and Footer Elements
    • Arranging Form Elements
    • Formatting Forms
  • Advanced Reporting Tasks
    • Using Report Sections
    • Using Conditional Formatting
    • Grouping and Sorting Data
    • Adding Calculated Controls
    • Creating Labels
  • Advanced Database Tools
    • Using the Database Documenter
    • Analyzing Table Performance
    • Analyzing Database Performance
    • Repairing a Database
    • Compacting a Database
  • Working with the Access Environment
    • Working with Database Properties
    • Encrypting a Database with a Password
    • Using Save Object As
    • Setting Access Options

Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.

Timetable

Chicago

230 W Monroe St
#610
Chicago
IL 60606View Map

Guaranteed to Run Limited Seats Left

Class times: 9.00am to 4.30pm

Servicing Arlington Heights, Aurora, Bollingbrook, Chicago Loop,
Deerfield, Des Plaines, Evanston, Highland Park, Joliet, Naperville,
Schaumburg, Skokie, South Chicago and surrounding areas.

Other Cities

Request onsite training quote

Los Angeles

915 Wilshire Blvd
#1800
Los Angeles
CA 90017View Map

Guaranteed to Run Limited Seats Left

Class times: 9.00am to 4.30pm

Servicing Anaheim, Burbank, Covina, Downtown, Fullerton,
Irvine, Long Beach, Northridge, Pasadena, San Bernardino,
Santa Monica, Van Nuys, Ventura and surrounding areas.

Related courses

Why train with us?Need Group training quotation?Fresh Starbucks brewed every dayBook two levels of Access training and save $100 FREE Class Repeat with each courseBook 3 Level of Access Training and save $150