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 Key Office Applications


November 09, 2017 November 20, 2017 2 Weeks Mon, Tue, Wed, Thu, Fri 9:30 AM - 1:30 PM Mississauga - Dundas St Campus Register Now
November 11, 2017 November 21, 2017 4 weeks M T W Th F 9:00am- 2:00pm Scarborough Campus Register Now
November 22, 2017 December 13, 2017 4Weeks Mon, Tue, Wed, Thu 6:00 PM - 9:00 PM Mississauga - Dundas St Campus* Register Now



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

Careers Start At Cimt College - Mississauga, Brampton, Toronto


Our Affiliated Partners