1. Home
  2. Short Courses
  3. Microsoft Access

Microsoft Access

Microsoft Access Courses, Training Classes

The course covers from basic to advance functions and features of Access. Students will learn how to design and create databases; work with tables, fields and records; sort and filter data; and create queries, data entry forms, multilevel reports, and multi-table queries.

Students will learn how to create advance queries, create crosstab, parameter and action queries, import, export and link database objects, work with XML documents. They will also learn to create and modify forms, and configure and format reports.

PRE-REQUISITES: Computer Fundamentals and Microsoft Word, Excel, PowerPoint

NEXT COURSE START DATES

S.IDSTART DATEEND DATEDAYTIMINGDELIVERY LOCATIONSTATUSREGISTER
40737March 5, 2026
Online
March 16, 2026MON, TUE, WED, THU, FRI9:30 AM - 2:30 PMOnlineClass Full
47822March 5, 2026
Online
March 16, 2026MON, TUE, WED, THU, FRI9:30 AM - 2:30 PMOnlineRegister Now
44729March 7, 2026
Online
March 22, 2026SAT, SUN10:00 AM - 5:30 PMOnlineRegister Now
44317March 12, 2026
Online
March 23, 2026MON, TUE, WED, THU, FRI9:30 AM - 2:30 PMOnlineRegister Now
44842April 7, 2026
Online
April 16, 2026MON, TUE, WED, THU, FRI5:00 PM - 10:00 PMOnlineRegister Now
39617April 12, 2026
Online
May 2, 2026SAT, SUN10:00 AM - 5:30 PMOnlineRegister Now
48472April 17, 2026
Online
April 28, 2026MON, TUE, WED, THU, FRI5:00 PM - 10:00 PMOnlineClass Full
44596May 7, 2026
Online
May 19, 2026MON, TUE, WED, THU, FRI5:00 PM - 10:00 PMOnlineRegister Now
44420May 12, 2026
Online
May 22, 2026MON, TUE, WED, THU, FRI5:00 PM - 10:00 PMOnlineClass Full
44870June 15, 2026
Online
June 24, 2026MON, TUE, WED, THU, FRI9:30 AM - 2:30 PMOnlineRegister Now
46710June 25, 2026
Online
July 7, 2026MON, TUE, WED, THU, FRI5:00 PM - 10:00 PMOnlineRegister Now
44624July 13, 2026
Online
July 22, 2026MON, TUE, WED, THU, FRI9:30 AM - 2:30 PMOnlineRegister Now
44454July 15, 2026
Online
July 24, 2026MON, TUE, WED, THU, FRI9:30 AM - 2:30 PMOnlineRegister Now
44898July 27, 2026
Online
August 6, 2026MON, TUE, WED, THU, FRI5:00 PM - 10:00 PMOnlineRegister Now
44743August 16, 2026
Online
September 5, 2026SAT, SUN10:00 AM - 5:30 PMOnlineRegister Now
44646September 11, 2026
Online
September 23, 2026MON, TUE, WED, THU, FRI5:00 PM - 10:00 PMOnlineRegister Now
44489September 16, 2026
Online
September 28, 2026MON, TUE, WED, THU, FRI5:00 PM - 10:00 PMOnlineRegister Now
46561September 26, 2026
Online
October 17, 2026SAT, SUN10:00 AM - 5:30 PMOnlineRegister Now
44760October 17, 2026
Online
November 1, 2026SAT, SUN10:00 AM - 5:30 PMOnlineRegister Now
44926October 20, 2026
Online
October 29, 2026MON, TUE, WED, THU, FRI9:30 AM - 2:30 PMOnlineRegister Now
44671November 12, 2026
Online
November 23, 2026MON, TUE, WED, THU, FRI9:30 AM - 2:30 PMOnlineRegister Now
44527November 18, 2026
Online
November 27, 2026MON, TUE, WED, THU, FRI9:30 AM - 2:30 PMOnlineRegister Now
44774November 29, 2026
Online
December 19, 2026SAT, SUN10:00 AM - 5:30 PMOnlineRegister Now
44954November 30, 2026
Online
December 9, 2026MON, TUE, WED, THU, FRI5:00 PM - 10:00 PMOnlineRegister Now
44693January 22, 2027
Online
February 2, 2027MON, TUE, WED, THU, FRI5:00 PM - 10:00 PMOnlineRegister Now
44562January 27, 2027
Online
February 5, 2027MON, TUE, WED, THU, FRI5:00 PM - 10:00 PMOnlineRegister Now
44787January 30, 2027
Online
February 20, 2027SAT, SUN10:00 AM - 5:30 PMOnlineRegister Now
View All Schedules
Contact us directly for other start dates
Seats Available
Limited Seats
Class Full

COURSE OUTLINE

Getting Started

  • Database Concepts
  • Exploring the Access Environment
  • Import objects or data from other sources
  • Delete database objects

Databases and Tables

  • Planning and Designing Databases
  • Exploring and Creating Tables
  • Display relationships
  • Set primary keys, foreign keys
  • Enforce referential integrity

Fields and Records

  • Finding, Editing and Organizing Records
  • Add validation rules to fields
  • Change field captions, sizes, data types
  • Configure fields to auto-increment

Basic Queries

  • Creating and Using Queries
  • Modifying Query results and queries
  • Performing Operations in Queries

Advanced Queries

  • Creating Crosstab Queries
  • Creating Parameter Queries
  • Using Action Queries
  • Create basic multi-table queries

Using Forms

  • Creating Forms
  • Add, move, and remove form controls
  • Set form control properties
  • Add and modify form labels

Advanced Form Design

  • Modify tab order on forms
  • Sort records by form field
  • Modify form positioning

Importing,Exporting and Linking

  • Importing and Exporting Objects
  • Interacting with XML Documents
  • Linking Access Objects
  • Using hyperlink fields

Working with Reports

  • Reports and Modifying and Printing Reports
  • Format a report into multiple columns
  • Modify report positioning
  • Format report elements
  • Change report orientation

Reports and Printing

  • Customized Headers and Footers
  • Adding Calculated Values
  • Printing and Labels
  • facebook icon
  • facebook icon
  • twitter icon
Duration 40 Hours
Course Fees Contact Us
Faculty IT
Course Level Beginner
Features In Class, Lab, Hands-on Training
Language English

Quick Application Form














Call Now
CIMT College - Mississauga, Brampton, Toronto, Scarborough, Hamilton - Celebrating 20 Years
International Students Click Here

INTERNATIONAL STUDENTS

Promotions from CIMT College Mississauga

OUR PROMOTIONS

Second Career Ontario cimt college

SECOND CAREER

become an agent for cimt college

BECOME OUR AGENT

Download Student Handbook of CIMT College
Download Course Calendar of CIMT College

Careers Start At CIMT College - Mississauga, Brampton, Toronto

AFFILIATED PARTNERS

Our Affiliated Partners