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 2

Monday, August 19, 2019, 09:00am - 04:00pm


This 6-hour course focuses on creating and managing tables and designing forms.


Topics include:

  • Working with Database Relationships (One-to-One, One-to-Many, Many-to-Many)
  • Enforcing Referential Integrity
  • Creating Tables from Scratch
  • Creating Tables using Application Parts
  • Designing Tables in Datasheet View
  • Setting Primary Keys
  • Adding, Rearranging, Formatting, Indexing, Inserting and Deleting Fields
  • Creating Calculated Fields, Lookup Fields and Multiple Field Values
  • Working with Validation Rules, Input Masks and Value Lists
  • Changing Field Properties
  • Creating Forms using the Form Wizard
  • Using Design View and Layout View
  • Adding Fields, Controls, Graphics, Headers and Footers to Forms
  • Changing Form and Control Properties
  • Adding and Modifying Subforms
  • Aligning Controls and Changing the Tab Order
  • Creating Option Groups

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




You can also access the self paced learning at free for staff at UofT


To Cancel and Check Fees click here

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