Microsoft Access

Microsoft Access Courses, Training Classes

Basic: Covers the basic 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, forms and reports.

Intermediate: Students will learn how to normalize data; work with lookup fields and sub datasheets; create join queries; add objects to forms, print reports and labels.

Advanced: For additional training on advanced Microsoft Access topics, students can continue with the Microsoft Access Advanced course.

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


Call for Online Schedule
July 28, 2021 August 9, 2021 MON, TUE, WED, THU, FRI 9:30 AM - 2:30 PM Online Campus Register Now
August 6, 2021 August 17, 2021 MON, TUE, WED, THU, FRI 4:00 PM - 9:00 PM Online Campus Register Now
November 2, 2021 November 11, 2021 MON, TUE, WED, THU, FRI 5:00 PM - 10:00 PM Online Campus Register Now
View All Schedules
Contact us directly for other start dates
Seats Available
Limited Seats
Class Full



Unit 1: Getting Started

  • Database Concepts
  • Exploring the Access Environment and Getting Help

Unit 2: Databases and Tables

  • Planning and Designing Databases
  • Exploring and Creating Tables

Unit 3: Fields and Records

  • Changing the Design of a Table
  • Finding, Editing and Organizing Records

Unit 4: Data Entry Rules

  • Setting Field Properties
  • Working with Input Masks and Setting Validation Rules

Unit 5: Basic Queries

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

Unit 6: Using Forms

  • Creating Forms, Using Design View and Sorting and Filtering Records

Unit 7: Working with Reports

  • Reports and Modifying and Printing Reports


Unit 1: Relational Databases

  • Database Normalization
  • Relating Tables and Implementing Referential Integrity

Unit 2: Related Tables

  • Lookup Fields and Modifying Lookup Fields
  • Subdatasheets

Unit 3: Complex Queries

  • Joining Tables in Queries
  • Calculated Fields and Summarizing and Grouping Values

Unit 4: Advanced from Design

  • Adding Unbound Controls, Graphics, Calculated Values, Combo Boxes and Form Types

Unit 5: Reports and Printing

  • Customized Headers and Footers
  • Adding Calculated Values
  • Printing and Labels

Unit 6: Charts

  • Charts in Forms and Reports
  • 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 - Celebrating 20 Years

Careers Start At Cimt College - Mississauga, Brampton, Toronto


Our Affiliated Partners