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
August 8, 2019 August 19, 2019 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Brampton Campus Register Now
August 23, 2019 September 4, 2019 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Mississauga - Malton Campus Register Now
August 28, 2019 September 11, 2019 MON, TUE, WED, THU, FRI 9:30 AM - 2:00 PM Mississauga - Dundas St Campus Class Full
August 30, 2019 September 11, 2019 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Scarborough Campus Register Now
September 12, 2019 September 24, 2019 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Mississauga - Dundas St Campus Register Now
September 23, 2019 October 2, 2019 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Brampton Campus Register Now
September 24, 2019 October 7, 2019 MON, TUE, WED, THU, FRI 5:00 PM - 9:00 PM Mississauga - Dundas St Campus Register Now
October 7, 2019 November 8, 2019 MON, WED, FRI 6:00 PM - 9:00 PM Mississauga - Dundas St Campus Register Now
October 22, 2019 October 31, 2019 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Mississauga - Dundas St Campus Register Now
November 7, 2019 November 18, 2019 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Mississauga - Malton Campus Register Now
November 18, 2019 December 5, 2019 MON, TUE, WED, THU, FRI 6:00 PM - 9:00 PM Mississauga - Malton Campus Register Now
December 11, 2019 December 20, 2019 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Brampton Campus Register Now
December 19, 2019 January 9, 2020 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Mississauga - Malton Campus Register Now
December 20, 2019 January 10, 2020 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Mississauga - Malton Campus Register Now
February 3, 2020 February 12, 2020 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Brampton 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 11, 2020 February 21, 2020 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Mississauga - Dundas St 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 9, 2020 March 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 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
July 10, 2020 July 20, 2020 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