Course Registration

General Inquiries & Appointments:

ODLC Listserv



215 Huron Street, 6th floor

Toastmasters (SALUT)

  Print help
Previous month Previous day Next day Next month
See by year See by month See by week Search Jump to month

Access 2016 Level 3

Tuesday, August 27, 2019, 09:00am - 04:00pm


This 6-hour course focuses on advanced queries, creating and modifying reports, importing and exporting data, designing menu systems and creating and running macros.


Topics include:


  • Creating Multi-Table Queries, Totals Queries, Parameter Queries, Find Duplicates Queries and Find Unmatched Records Queries
  • Working with Action Queries (Make-Table Query, Append Query, Update Query, Delete Query)
  • Using Calculations in Queries
  • Working with the Expression Builder
  • Modifying Query Joins
  • Changing Query Properties
  • Importing Data from Text Files, from Excel, and from another Access Database
  • Linking to Data in Another Database
  • Exporting Data to Excel, to Word, to a Text file, to a PDF File, to another Access Database and to a Word Mail Merge
  • Creating Reports using the Report Wizard
  • Using Design View, Report View and Layout View
  • Working with Report Sections
  • Adding Controls to a Report
  • Creating Calculated Controls
  • Changing Control Properties
  • Sorting and Grouping Data in a Report
  • Applying Themes and Conditional Formatting to a Report
  • Modifying Report Setup
  • Printing Reports
  • Creating Mailing Labels Using the Label Wizard
  • Creating and Using a Switchboard
  • Creating a Navigation Form
  • Setting Access Startup Options
  • Working with Macros


Requirement: Completion of Access 2016 Level 2 or equivalent experience with Access or any other database program.




To Cancel and Check Fees click here

Location: 256 McCaul Street , Room 109
Presenter: Simone Hubers