Computer and Business Skills training

Sign Up
888.815.0604
Home / Access / Level 3

Microsoft Access Advanced Training Course


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.

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


1 Day | $450.00


Book this course

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.

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