Course Description

Microsoft Access Level 3 teaches students how to use advanced commands to work with forms, reports, designing tables, manipulating queries, as well as using subforms or subreports.

Students will learn a variety of commands, functions, and database capabilities.

Course Details


Registrations within 24 hours of course start time must be made by phone (403-220-2866).

Course Content

Course Level Learning Outcomes

Upon successful completion of this course, you will be able to:

  • Create advanced forms and reports
  • Create visual basic controls in forms and reports
  • Export, import and share data from different applications
  • Split the databases
  • Use protect tools associated with database
  • Create modules and built-in macros

Topics of Instruction

  • Advanced Reports and Forms
  • Set Report Controls
  • Display, Share, Import, and Export Data
  • Database Tools
  • Recovering data from a backups
  • Encrypting databases with a password
  • Splitting databases
  • Setting a form as the startup option
  • Using navigation forms
  • Add images and backgrounds to forms
  • Analyze database


  • Students must be familiar with the personal computer, keyboard and mouse.
  • Students must have Microsoft Windows skills and knowledge, and be able to perform the following tasks:
    • start and run Windows
    • use the taskbar, Start button and Help feature
    • use Minimize, Maximize, Restore Down/Up and Close
    • use the left and right mouse buttons appropriately
    • understand file management techniques
    • navigate between files, folders, or drives

Applies Towards the Following Certificate(s)


Enrol Now - Select a section to enrol in

8:30AM to 4:30PM
Jun 11, 2021 to Jun 18, 2021
Schedule and Location
Delivery Options
Course Fees
Flat Fee non-credit $575.00
Reading List / Textbook

Title: Microsoft Access 2016 Certification Guide
Edition: 2016
Publisher: CCI Learning
ISBN: 978-1-55332-479-9

Please visit CCI Learning 

Section Notes

You will require access to a computer with the required software: Microsoft Access

This course uses Desire2Learn (D2L), an online learning management system. The instructor will post your course outline and other materials in D2L. For more information about D2L, please visit our Online Learning Resources.

Unless otherwise stated, notice of withdrawal or transfer from a course must be received at least seven calendar days prior to the start date of the course.

Required fields are indicated by .