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 2013, 2016, 2019 and 365 users.

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 2013, 2016, 2019 and 365 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
  • Dec 3 - 4Book
  • Jan 27 - 28Book
  • Mar 11 - 12Book
  • Apr 27 - 28Book


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
  • Nov 25 - 26Book
  • Feb 4 - 5Book
  • Mar 10 - 11Book
  • May 5 - 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 I thoroughly enjoyed taking this class. The instructor made everything we were learning relate-able to "real life" which made learning Access much simpler. I know I'll be able to get back in the office tomorrow with new techniques on how to better improve our current database; making my job more fluid and efficient. Thanks!Monika Kirkiewicz
Family Health Network
5.0 stars AMAZING!!!! I just finished the crash course on Access 2010 and I am ready for the world of Access. I feel confident with the skills I have learned, and know that I will make my organization much more efficient. Thank you, Chris.Jackelinne Melendez
Department of Veteran Affairs
5.0 stars Chris was awesome! I will definitely be recommending this course with Chris some co-workers. He knew his stuff and he definitely tailored the lessons to us. He is great! I can't thank him enough. I am definitely hoping I can come back for more courses with Chris. Thanks! Diana Munoz
BSC Management, Inc
5.0 stars I can honestly say that prior to my access courses with Training Connection I knew absolutely nothing about designing a database. I am now leaving Level III with the confidence to provide my company with the databases being requested. I would highly recommend any of these courses to co-workers and friends. I look forward to starting my databases. :) Sylvia Tao
Morton Grove Pharmaceuticals

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,908 reviews

Fresh Starbucks brewed every day FREE Class Repeat with each course