We are enrolling new students for upcoming programs and courses via phone, SMS, online and email while our physical campuses are temporarily closed due to Covid 19. Our students are continuing their education through online interactive instructor led virtual classes and getting ready for the employment in the field of study.

  1. Home
  2. Short Courses
  3. Microsoft Access

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

Call for Online Schedule

Select Campus/Location

START DATE END DATE DAY TIMING CAMPUS STATUS REGISTER
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 2, 2020 October 14, 2020 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Online 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
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