Microsoft Access

Microsoft Access Courses, Training Classes

The course covers from basic to advance 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, data entry forms, multilevel reports, and multi-table queries.

Students will learn how to create advance queries, create crosstab, parameter and action queries, import, export and link database objects, work with XML documents. They will also learn to create and modify forms, and configure and format reports.

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

NEXT COURSE START DATES

Call for Online Schedule
START DATE END DATE DAY TIMING LOCATION STATUS REGISTER
October 24, 2022 November 2, 2022 MON, TUE, WED, THU, FRI 9:30 AM - 2:30 PM Online Campus Register Now
October 26, 2022 November 4, 2022 MON, TUE, WED, THU, FRI 9:30 AM - 2:30 PM Online Campus Register Now
November 11, 2022 November 22, 2022 MON, TUE, WED, THU, FRI 5:00 PM - 10:00 PM Online Campus Register Now
December 4, 2022 January 7, 2023 SAT, SUN 10:00 AM - 5:30 PM Online Campus Register Now
December 8, 2022 December 19, 2022 MON, TUE, WED, THU, FRI 5:00 PM - 10:00 PM Online Campus Register Now
December 14, 2022 December 23, 2022 MON, TUE, WED, THU, FRI 5:00 PM - 10:00 PM Online Campus Register Now
January 3, 2023 January 12, 2023 MON, TUE, WED, THU, FRI 9:30 AM - 2:30 PM Brampton Campus Register Now
January 17, 2023 January 26, 2023 MON, TUE, WED, THU, FRI 9:30 AM - 2:30 PM Online Campus Register Now
February 9, 2023 February 21, 2023 MON, TUE, WED, THU, FRI 4:00 PM - 9:00 PM Mississauga - Malton Campus Register Now
March 14, 2023 March 22, 2023 MON, TUE, WED, THU, FRI 9:30 AM - 2:30 PM Online Campus Register Now
March 22, 2023 March 31, 2023 MON, TUE, WED, THU, FRI 9:30 AM - 2:30 PM Online Campus Register Now
April 1, 2023 April 22, 2023 SAT, SUN 10:00 AM - 5:30 PM Online Campus Register Now
April 3, 2023 April 13, 2023 MON, TUE, WED, THU, FRI 5:00 PM - 10:00 PM Online Campus Register Now
April 6, 2023 April 18, 2023 MON, TUE, WED, THU, FRI 9:30 AM - 2:30 PM Online Campus Register Now
April 10, 2023 April 19, 2023 MON, TUE, WED, THU, FRI 5:00 PM - 10:00 PM Online Campus Register Now
April 12, 2023 April 20, 2023 MON, TUE, WED, THU, FRI 9:30 AM - 2:30 PM Online Campus Register Now
April 12, 2023 April 20, 2023 MON, TUE, WED, THU, FRI 9:30 AM - 2:30 PM Brampton Campus Register Now
April 17, 2023 April 26, 2023 MON, TUE, WED, THU, FRI 5:00 PM - 10:00 PM Brampton Campus Register Now
May 6, 2023 May 27, 2023 SAT, SUN 10:00 AM - 5:30 PM Online Campus Register Now
May 24, 2023 June 1, 2023 MON, TUE, WED, THU, FRI 5:00 PM - 10:00 PM Online Campus Register Now
June 7, 2023 June 16, 2023 MON, TUE, WED, THU, FRI 5:00 PM - 10:00 PM Online Campus Register Now
June 10, 2023 June 25, 2023 SAT, SUN 10:00 AM - 5:30 PM Online Campus Register Now
June 27, 2023 July 6, 2023 MON, TUE, WED, THU, FRI 5:00 PM - 10:00 PM Online Campus Register Now
July 19, 2023 July 27, 2023 MON, TUE, WED, THU, FRI 9:30 AM - 2:30 PM Online Campus Register Now
August 30, 2023 September 8, 2023 MON, TUE, WED, THU, FRI 9:30 AM - 2:30 PM Mississauga - Malton Campus Register Now
August 30, 2023 September 8, 2023 MON, TUE, WED, THU, FRI 9:30 AM - 2:30 PM Brampton Campus Register Now
September 28, 2023 October 6, 2023 MON, TUE, WED, THU, FRI 5:00 PM - 10:00 PM Online Campus Register Now
October 17, 2023 October 26, 2023 MON, TUE, WED, THU, FRI 9:30 AM - 2:30 PM Mississauga - Malton Campus Register Now
October 26, 2023 November 3, 2023 MON, TUE, WED, THU, FRI 9:30 AM - 2:30 PM Online Campus Register Now
October 26, 2023 November 6, 2023 MON, TUE, WED, THU, FRI 4:00 PM - 9:00 PM Mississauga - Dundas St Campus Register Now
November 28, 2023 December 6, 2023 MON, TUE, WED, THU, FRI 5:00 PM - 10:00 PM Online Campus Register Now
December 4, 2023 December 13, 2023 MON, TUE, WED, THU, FRI 9:30 AM - 2:30 PM Mississauga - Malton Campus Register Now
December 4, 2023 December 13, 2023 MON, TUE, WED, THU, FRI 9:30 AM - 2:30 PM Online Campus Register Now
December 4, 2023 December 13, 2023 MON, TUE, WED, THU, FRI 9:30 AM - 2:30 PM Brampton Campus Register Now
December 15, 2023 January 3, 2024 MON, TUE, WED, THU, FRI 9:30 AM - 2:30 PM Brampton Campus Register Now
January 2, 2024 January 10, 2024 MON, TUE, WED, THU, FRI 5:00 PM - 10:00 PM Online Campus Register Now
February 6, 2024 February 14, 2024 MON, TUE, WED, THU, FRI 9:30 AM - 2:30 PM Brampton Campus Register Now
February 8, 2024 February 20, 2024 MON, TUE, WED, THU, FRI 5:00 PM - 10:00 PM Mississauga - Malton Campus Register Now
October 30, 2024 November 8, 2024 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

COURSE OUTLINE

Getting Started

  • Database Concepts
  • Exploring the Access Environment
  • Import objects or data from other sources
  • Delete database objects

Databases and Tables

  • Planning and Designing Databases
  • Exploring and Creating Tables
  • Display relationships
  • Set primary keys, foreign keys
  • Enforce referential integrity

Fields and Records

  • Finding, Editing and Organizing Records
  • Add validation rules to fields
  • Change field captions, sizes, data types
  • Configure fields to auto-increment

Basic Queries

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

Advanced Queries

  • Creating Crosstab Queries
  • Creating Parameter Queries
  • Using Action Queries
  • Create basic multi-table queries

Using Forms

  • Creating Forms
  • Add, move, and remove form controls
  • Set form control properties
  • Add and modify form labels

Advanced Form Design

  • Modify tab order on forms
  • Sort records by form field
  • Modify form positioning

Importing,Exporting and Linking

  • Importing and Exporting Objects
  • Interacting with XML Documents
  • Linking Access Objects
  • Using hyperlink fields

Working with Reports

  • Reports and Modifying and Printing Reports
  • Format a report into multiple columns
  • Modify report positioning
  • Format report elements
  • Change report orientation

Reports and Printing

  • Customized Headers and Footers
  • Adding Calculated Values
  • Printing and Labels
  • 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, Hamilton - Celebrating 20 Years

Careers Start At Cimt College - Mississauga, Brampton, Toronto

AFFILIATED PARTNERS

Our Affiliated Partners