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

S.ID START DATE END DATE DAY TIMING STATUS REGISTER
31520 June 27, 2024 July 9, 2024 MON, TUE, WED, THU, FRI 9:30 AM - 2:30 PM Class Full
37885 June 27, 2024 July 9, 2024 MON, TUE, WED, THU, FRI 5:00 PM - 10:00 PM Class Full
30345 July 10, 2024 July 19, 2024 MON, TUE, WED, THU, FRI 5:00 PM - 10:00 PM Register Now
37640 July 14, 2024 August 3, 2024 SAT, SUN 10:00 AM - 5:30 PM Register Now
24927 July 26, 2024 August 7, 2024 MON, TUE, WED, THU, FRI 5:00 PM - 10:00 PM Register Now
37403 August 29, 2024 September 10, 2024 MON, TUE, WED, THU, FRI 5:00 PM - 10:00 PM Class Full
38661 October 22, 2024 October 31, 2024 MON, TUE, WED, THU, FRI 9:30 AM - 2:30 PM Register Now
24205 October 24, 2024 November 4, 2024 MON, TUE, WED, THU, FRI 5:00 PM - 10:00 PM Register Now
21824 October 30, 2024 November 8, 2024 MON, TUE, WED, THU, FRI 5:00 PM - 10:00 PM Register Now
38610 November 20, 2024 November 29, 2024 MON, TUE, WED, THU, FRI 9:30 AM - 2:30 PM Register Now
24959 November 22, 2024 December 3, 2024 MON, TUE, WED, THU, FRI 9:30 AM - 2:30 PM Register Now
37426 January 3, 2025 January 14, 2025 MON, TUE, WED, THU, FRI 5:00 PM - 10:00 PM Register Now
39897 January 9, 2025 January 20, 2025 MON, TUE, WED, THU, FRI 9:30 AM - 2:30 PM Class Full
39190 January 15, 2025 January 24, 2025 MON, TUE, WED, THU, FRI 5:00 PM - 10:00 PM Register Now
36794 January 22, 2025 January 31, 2025 MON, TUE, WED, THU, FRI 5:00 PM - 10:00 PM Register Now
38683 February 14, 2025 February 26, 2025 MON, TUE, WED, THU, FRI 9:30 AM - 2:30 PM Register Now
38161 March 11, 2025 March 20, 2025 MON, TUE, WED, THU, FRI 9:30 AM - 2:30 PM Register Now
38078 March 14, 2025 March 25, 2025 MON, TUE, WED, THU, FRI 9:30 AM - 2:30 PM Register Now
38387 March 18, 2025 March 27, 2025 MON, TUE, WED, THU, FRI 9:30 AM - 2:30 PM Register Now
37654 March 22, 2025 April 6, 2025 SAT, SUN 10:00 AM - 5:30 PM Register Now
39183 April 21, 2025 April 30, 2025 MON, TUE, WED, THU, FRI 5:00 PM - 10:00 PM Register Now
38707 May 1, 2025 May 12, 2025 MON, TUE, WED, THU, FRI 5:00 PM - 10:00 PM Register Now
35621 May 10, 2025 May 31, 2025 SAT, SUN 10:00 AM - 5:30 PM Register Now
38422 May 13, 2025 May 23, 2025 MON, TUE, WED, THU, FRI 5:00 PM - 10:00 PM 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