Computer and Business Skills training

Sign Up
888.815.0604
Home / Microsoft Access Training

Access Training Classes

Chicago, Los Angeles

Looking for an instructor-led Microsoft Access training class in Chicago or Los Angeles?

We offer 2 Access courses - a Fundamentals course and an Advanced course. The training is hands-on and taught by a live instructor present in the room.

Learning MS Access face-to-face from a live instructor is still the best way to learn. All our Access classes are taught by experienced database developers.

We also include the following with each Access course:

  • a printed Access manual
  • certificate of course completion
  • and most importantly a 6 month free repeat.

Book a Microsoft Access course today. All classes guaranteed to run!

Onsite training available countrywide.

Access classes for all levels

access logo

Access Fundamentals

This class is for students new to Microsoft Access. You will learn basic database concepts, and create and modify databases and their various objects using the Microsoft Access database application.

2 Days | $895.00

Course Description

This hands-on beginners course is suitable for new users of Access 2010/2013/2016.

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

After this class you will have a very good working knowledge of Microsoft access, including how to design and build an efficient relational database, construct data fields and tables, run queries, design forms and build reports.

Detailed course outline

  • Database Fundamentals
    • Understanding general database terms
    • Database management systems
    • Table Overview
    • Data types
    • Table metadata
    • Queries and SQL
    • SQL Statements
    • Relational databases
    • Flat file databases
    • NoSQL databases
    • Advantages of relational databases
    • Access interface and objects
    • New databases
    • Existing databases
    • The navigation Pane
    • Access objects: Tables, Queries, Forms and Reports
  • Database Design
    • Fundamentals of efficient design
    • Modeling
    • The logical model
    • The physical model
    • Normal forms
    • Creating and Modifying databases
    • Choosing data types: Numeric, String, Other
    • Constraints
    • Changing table structure
    • Changing data types
    • Adding and deleting fields
    • Relationships and Keys
  • Tables
    • Creating a simple table
    • Creating tables in Design View
    • Creating fields
    • Creating fields in Datasheet view
    • Creating fields in Table Design view
    • Setting a Primary Field
    • Data Validation using Field Properties
    • Setting validation rules
    • Setting table-level validation
    • Relationships and keys
    • The importance of primary keys and indexes
    • Deciding whether you need unique indexes
    • Creating relationships
  • Queries
    • Creating basic queries
    • Select queries
    • Action queries
    • Adding data sources to a query
    • Selecting query fields
    • Query criteria
    • Adding mutiple criteria conditions
    • Parameter queries
    • Total queries
    • Cross tab queries
    • Append queries
    • Update queries
    • Delete queries
    • Modifying queries
    • Sorting query results
    • Query field formatting
    • Using calculated fields
    • Creating calculated Yes/No fields
    • Calculated text fields
  • Forms
    • Creating simple forms
    • Basic form design options
    • Bound and unbound form controls
    • Using the Form Wizard
    • Form Design
    • Displaying form properties
    • Form sections
    • Form controls
    • Adding bound controls to a form
    • Adding controls form the field list
    • Types of controls
    • Test box and label controls
    • List controls
    • Adding a command button
    • Changing the layout of controls
  • Reports
    • Creating Reports
    • Report basics
    • Setting up data sources
    • Filtering and ordering reports
    • Automatic report generators
    • Using the Report Wizard
    • Report Controls
    • Calculated fields
    • Grouping and summarizing
    • Formatting Reports
    • Report Page Setup options
    • Images and other objects
    • Themes

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.

access logo

Access Advanced

This course is aimed at Intermediate users of Access and covers topics such as building advanced forms, writing advanced queries, creating advanced reports and to automate operations using Macros.

1 Day | $450.00

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 about advanced queries, forms and reporting, creating Macros, importing and exporting data from Access, and important database management tasks such as compressing and restoring a database, data encryption and more.

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

Detailed course outline

  • Advanced Queries
    • Grouping and summarizing
    • About grouping
    • Building totals queries
    • Totals query design
    • Where totals
    • Expression totals
    • Common aggregate functions
    • Updating, deleting, and relationships
    • Referential integrity
    • Cascading practices
    • About cascading deletes
    • Allowing deletes in key fields
    • Allowing updates in key fields
    • Indexing for performance
    • About indexes
    • How an index works
    • Index planning
    • Creating indexes in tables
    • Setting index properties
    • Maximizing performance
    • Specialized query types
    • Pass-Through Queries
    • Data Definition Query
  • Advanced Forms
    • About subforms
    • Creating the main form and subform using the Form Wizard
    • Creating a subform using the SubForm Wizard
    • Using an existing form as a subform
    • Nested subforms
    • Linking forms
    • Main form–subform data relationships
    • The hyperlink control
    • Adding a hyperlink to a form
    • The Web Browser control
    • The attachment control
    • Managing attachments in a form
    • The chart control
    • Specialized form types
    • About navigation forms
    • Creating a navigation form
    • Modal dialog forms
    • Creating a database start-up form
  • Advanced Reports
    • About subreports
    • Subreport record sources
    • Main and subreport with the same record source
    • Main and subreport with related record sources
    • Using an unbound main report as a container
    • Advanced grouping
    • Date ranges
    • Running sums
    • Advanced formatting
    • Banded reports
    • Formatting and design options
    • Showing Username name
    • Using a logo
    • Showing and hiding for printing
  • Macros
    • Creating a macro
    • Planning macros
    • Using the Macro Builder
    • Using Macro Builder features
    • Embedded macros
    • Assigning macros to events
    • Data macros
    • Using variables
    • Variable scope
    • Choosing variable sources
    • When to use variables
    • Creating macros with variables
    • Troubleshooting macros
    • Error handling basics
    • Stepping through macros
    • Displaying variable values
    • Using the OnError action
    • Using the MacroError Object
    • Designing robust macros
    • Logging Debug info
  • Importing and Exporting Data
    • Data exchange basics
    • Choosing which parts of Access to use
    • Other database applications
    • OCDB databases
    • Saving import and export procedures
    • Import options
    • Export basics
    • Exchanging data with other Access databases
    • Linking to Access tables
    • Importing data in Access
    • Exporting Access objects
    • Exchanging data with Excel
    • Importing from Excel
    • Linking to Excel data
    • Appending Excel data
    • Exporting data to Excel
    • Using Text and XML data files
    • Exporting to text files
    • Exporting to XML
    • Importing from text files
    • Importing from XML files
  • Database Management
    • Preparing and running Compact & Repair
    • Running Compact & Repair automatically
    • Restoring a database
    • Other maintenance tasks
    • Encrypting a database
    • Creating an executable file
    • Documenting the database structure

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.

Package deals

Training Package

Access Training Package - 2 Levels

$1145.00

Book both our Access classes and save $200.

Book this package

Timetable

Chicago

230 W Monroe St
#610
Chicago
IL 60606View Map

  • Access Fundamentals
  • Sep 3 - 4Book
  • Oct 21 - 22Book
  • Dec 3 - 4Book
  • Access Advanced
  • Sep 5Book


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.

Los Angeles

915 Wilshire Blvd
#1800
Los Angeles
CA 90017View Map

  • Access Fundamentals
  • Aug 1 - 2Book
  • Sep 4 - 5Book
  • Oct 14 - 15Book
  • Nov 25 - 26Book
  • Access Advanced
  • Sep 6Book


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.

Other Cities

Request onsite training quote

Choosing the right course

Recent student feedback

5.0 stars Rich provided an amazingly productive training course. There was an equal balance between understanding concepts and then applying these concepts hands on. It seems that each class in uniquely designed to accommodate the student's current needs. I am looking forward to coming back for my Access Training Class - Level III. Sylvia Tao
Morton Grove Pharmaceuticals
5.0 stars Chris was a wonderful teacher. Access had confused me in the past... but he put it in a way that I would understand! I really enjoyed this class... and would definitely recommend it to other coworkers. Shannen Herbert
BSC Management
5.0 stars Chris was a great instructor! I came in with limited amount of ACCESS knowledge and I am now walking out with enough ACCESS training to begin queries and reports that I can then exercise for my work requirements. Thanks Chris! I will now recommend that my company also sends me to the LEVEL 2 training ... I hope to be here in August!Maria G. Chagoya
Turning Point Foundation
5.0 stars This class was a great experience. The instructor was very helpful and engaged. Well worth the investment of time away from the office to focus on "out of the box" thinking from a Finance professional viewpoint.Sharon Roulo

How to Register

Register here

Access Resources

Introduction to Databases
Getting started in Access
Database Terms
Database Table Relationships
Formatting Text in MS Access

Basic Tasks in Access
Working with Tables
Working with Records
Opening Database Objects
Managing Objects
Formatting Tables Part A
More Microsoft Office Training Resources

Why train with us?

4.7 / 5

based on 1,895 reviews

Fresh Starbucks brewed every day FREE Class Repeat with each course