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

NEXT COURSE START DATES

START DATE END DATE DAY TIMING CAMPUS STATUS REGISTER
January 25, 2020 February 22, 2020 SAT, SUN 10:00 AM - 3:00 PM Mississauga - Malton Campus Register Now
February 10, 2020 February 19, 2020 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Mississauga - Malton Campus Register Now
February 24, 2020 March 4, 2020 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Mississauga - Malton Campus Register Now
March 2, 2020 March 11, 2020 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Mississauga - Dundas St Campus Register Now
March 6, 2020 March 19, 2020 MON, TUE, WED, THU, FRI 5:00 PM - 9:00 PM Mississauga - Dundas St Campus Register Now
March 7, 2020 March 29, 2020 SAT, SUN 10:00 AM - 3:00 PM Brampton Campus Register Now
March 9, 2020 March 17, 2020 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Brampton Campus Register Now
March 18, 2020 March 27, 2020 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Brampton Campus Register Now
April 7, 2020 April 17, 2020 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Brampton Campus Register Now
April 9, 2020 April 21, 2020 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Mississauga - Dundas St Campus Register Now
May 1, 2020 May 12, 2020 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Scarborough Campus Register Now
May 25, 2020 June 5, 2020 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Brampton Campus Register Now
May 26, 2020 June 12, 2020 MON, TUE, WED, THU, FRI 6:00 PM - 9:00 PM Mississauga - Malton Campus Register Now
June 5, 2020 June 15, 2020 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Mississauga - Malton Campus Register Now
June 5, 2020 June 16, 2020 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Mississauga - Malton Campus Register Now
June 8, 2020 July 10, 2020 MON, WED, FRI 6:00 PM - 9:00 PM Brampton Campus Register Now
July 10, 2020 July 20, 2020 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Brampton Campus Register Now
July 14, 2020 July 24, 2020 MON, TUE, WED, THU, FRI, SAT 5:00 PM - 9:00 PM Scarborough Campus Register Now
July 17, 2020 July 28, 2020 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Mississauga - Malton Campus Register Now
August 14, 2020 August 20, 2020 MON, TUE, WED, THU, FRI 9:00 AM - 5:00 PM Mississauga - Dundas St Campus Register Now
August 28, 2020 September 9, 2020 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Scarborough Campus Register Now
September 12, 2020 October 4, 2020 SAT, SUN 10:00 AM - 3:00 PM Brampton Campus Register Now
October 4, 2020 October 31, 2020 SAT, SUN 10:00 AM - 4:00 PM Mississauga - Dundas St Campus Register Now
October 20, 2020 November 2, 2020 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Brampton Campus Register Now
October 20, 2020 November 2, 2020 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Brampton Campus Register Now
October 24, 2020 November 14, 2020 SAT, SUN 9:30 AM - 3:30 PM Scarborough Campus Register Now
November 24, 2020 December 4, 2020 MON, TUE, WED, THU, FRI, SAT 5:00 PM - 9:00 PM Scarborough Campus Register Now
February 1, 2021 February 10, 2021 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Scarborough Campus Register Now
February 2, 2021 February 11, 2021 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Mississauga - Dundas St Campus Register Now
February 28, 2021 March 21, 2021 SAT, SUN 10:00 AM - 4:00 PM Mississauga - Dundas St Campus Register Now
March 21, 2021 April 17, 2021 SAT, SUN 9:30 AM - 3:30 PM Scarborough Campus Register Now
March 25, 2021 April 8, 2021 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Brampton Campus Register Now
View All Schedules
Contact us directly for other start dates
Seats Available
Limited Seats
Class Full

COURSE OUTLINE

BASIC

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

INTERMEDIATE

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

AFFILIATED PARTNERS

Our Affiliated Partners