Where the Experience is Beyond the Academics Photo Gallery

Microsoft Access

Microsoft Access

Overview

The Microsoft Access course at CTS College is a hands-on programme that teaches you to build and manage professional databases with confidence. You'll learn to design efficient tables, create queries, develop user-friendly forms, and generate insightful reports. Perfect for business users and aspiring database managers, this practical training transforms complex data into organised, accessible information through real-world exercises and expert guidance.

Note: Students can choose to do the entire suite of Microsoft Office applications (6 in total) at a disounted rate.

Benefits

Upon completion of this programme, students would be able to:

  • Use Microsoft Access

Features

Below are some of the main features of this course:

  • Short duration -can be completed in only 3 weeks with 2 classes per week
  • Competitive rates with flexible payment plans
  • Experienced lecturer with excellent student support
  • Online classes which are also recorded for further review
  • Support group via WhatsApp with the lecturer, programme manager and students

Target Audience

This course is perfect for:

  • Persons interested in learning Microsoft Access
  • Office Assistants
  • Secretaries
  • Business Owners and Entrepreneurs

Entry Requirements

In order to enrol for this programme, students are expected to be computer literate.

Course Content

The following would be covered in this course:

Office workspace basics

  • Basic window elements
  • Exploring Office backstage
  • Working with the ribbon
  • Customising the quick access toolbar
  • Working with keytips
  • Using the status bar
  • Getting help

Introduction to Access

  • What is an Access database
  • Opening a database file
  • Exploring database objects
  • Creating a database
  • Changing views
  • Printing database objects
  • Saving and closing a database file

Working with tables

  • What is a table
  • Working with datasheets
  • Moving among records
  • Updating records
  • Adding records to a table
  • Selecting rows and columns
  • Finding records
  • Sorting records
  • Filtering records

Designing tables

  • Adding a table to a database
  • Adding fields to a table
  • Adding a lookup field
  • Setting a primary key
  • Saving design changes
  • Importing data
  • Exporting data
  • Performing database maintenance

Creating and running queries

  • What is a query
  • Creating a query
  • Working with queries
  • Saving and running a query
  • Creating calculated fields
  • Understanding query properties
  • Creating multi-table select queries
  • Joining tables
  • Enforcing referential integrity

Using forms

  • What is a form
  • Using the form tool
  • Creating a form with the form wizard
  • Working in design view
  • Changing the form layout
  • Using calculated controls
  • Working with records on a form

Generating reports

  • What is a report
  • What is a report tool
  • Previewing and printing a report
  • Saving a report
  • Designing a report
  • Changing a report layout
  • Understanding controls
  • Using a calculated control
  • Analysing dependencies

Completing the desktop application

  • Designing the navigation form
  • Creating a database password
  • Creating a backup of database

Schedule

Course Offering

Day Time Duration Contact Hours Cost Lecturer
Monday, Thursday 05:30 pm to 08:30 pm 3 Weeks 18 hours Hours $350.00 Ms. Gail Pettier

Session - Monday, Thursday (05:30 pm to 08:30 pm)

Session Start Date End Date
2025 - Microsoft Access - Online Classes Thursday, May 29, 2025 Monday, June 16, 2025
2025 - Microsoft Access - Online Classes Thursday, September 4, 2025 Wednesday, October 22, 2025
2025 - Microsoft Access - Online Classes Thursday, December 4, 2025 Monday, December 22, 2025

Delivery Mode

Online Classes

This course will be delivered via live online classes. Students will be provided with a link to join the class as well as other relevant instructions at least one day before the start of each class. These classes are also recorded - therefore students have the option to review the course content as often as they like.

Additional Info

Assessment

Students would be required to complete the following assessment(s) for this course:

  • A practical exam

Certification

In order to receive the CTS College certificate of completion or participation for this course, students must attend a minimum of 75% of classes and pay any outstanding fees. Where applicable, students who do not meet the necessary assessment requirements, but attended the required number of classes would receive a CTS College certificate of participation.

Certificates would be provided in digital format which would allow students to access, print and share their certificates 24/7 on demand. For more information on our digital certificates please click here.

Note: Certificates would be provided for each module completed.

Resources

CTS College will provide all handouts in digital format for this programme.

Interactive Course Calendar

Explore our comprehensive Interactive Course Calendar, with a list of all our courses and their costs and delivery modes offered throughout the year.

View Calendar »

Fees & Payment

Cost

This course is offered at the affordable price of $350 or a discounted rate of $1,500 for all 6 Microsoft Office applications (Access, Excel, OneNote, Outlook, Powerpoint and Word). In order to start the course, students must pay a minimum of 50% before the first class.

Payment Plans

Students can be given a payment plan where the initial downpayment is made, with an arrangement for the remaining balance to be paid over the duration of the course. Please feel free to contact us to discuss a payment plan customised for you.

Payment Methods

The following table shows the details for the 4 convenient ways to pay the CTS College fees for this programme:

Payment Method Details
Linx Paid at the Administration Office
Credit Card Paid at the Administration Office
Cheque

Paid at the Administration Office

Made Payable to CTS College

Online Bank Transfer

Paid via Online Banking

Click to view full instructions »

Student Support

Facilitator

At CTS College, we believe in crafting an extraordinary student experience. This is why we have selected Ms. Gail Pettier to facilitate the Microsoft Access course. Ms. Pettier not only imparts knowledge, but creates a learning experience where students feel valued and appreciated. She is also committed to shaping a transformative learning journey and creating an educational adventure that goes beyond the ordinary.

Gail Pettier, a Software Training Specialist, currently serves as a Software/Technology Consultant at CTS College. In addition to her role at the college, she freelances as a Graphic/Web Designer and Writer, showcasing her versatility in the tech and creative domains. Recognised as an effective team player, Gail is celebrated for her creativity, flexibility, sense of humor, pride and unwavering company loyalty. Her skills encompass time management, interpersonal relationships, teamwork and a strong commitment to moral and ethical standards.

Gail's aspirations include fostering a friendly and casual work environment, leading a talented team and tackling cutting-edge technical challenges. She aims to focus on building social platforms tailored for leaders in both educational and corporate environments, demonstrating her dedication to innovation and excellence.

Programme Management

The programme management team is responsible for the management of this course. If you would like further information or clarification on this programme please contact:

Mr. Matthew Christian
Programme Manager
Phone: (868) 720-2939 / (868) 740-9095

E-mail: Certifications@CTSCollege.com

We are an ACTT recognised institution and partner with international awarding bodies

Affiliates