Course Registration
416-978-5462


General Inquiries & Appointments:
416-978-2066



SUBSCRIBE
ODLC Listserv

 

accessibility
Directions

215 Huron Street, 6th floor
odlc@utoronto.ca


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.

 

Register

 

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

 



To Cancel and Check Fees click here


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

 

Back