Let's Get Started
  • Hidden
  • This field is for validation purposes and should be left unchanged.

Request info

Microsoft Access – Beginner, Intermediate, Advanced Courses Certificate

Continuing Education Access Classes – The Best Access Training Courses

Academy of Learning offers two Microsoft Access training levels for every one from pure beginners, to those needing an Outlook refresher, to those who need to upgrade their skills to an expert level. Each course includes everything you need for success.

  • Online access through the ILS (Integrated Learning System) to all materials including text, audio files, videos, and interactive Access training
  • Comprehensive textbooks that include all course material. Plenty of images and screen shots along with room for your own notes
  • One-on-one support from our Learning Coaches who are there to help you over whatever hurdles you may encounter

Each Microsoft Access course is available at the following campuses:

Microsoft Access Course Level 1 - Beginner Intermediate Training - MS Access Level 1

Microsoft Access – Level 1

In this course, you will examine database objects and learn to manage data in a database. Then learn to sort and filter data, display and format data, and use simple queries to retrieve data. You’ll master creating and modifying databases and tables, and work with simple forms and reports. View PDF of Microsoft Access Level 1.

Module 1: Navigation and Dialog Boxes

Introduction to Microsoft Access; What are Access Database Objects and File Types?; Starting and Exiting the Application; Exploring the Access Application Window; Completing Dialog Boxes; Opening and Closing a Database; Getting Help While You Work

Module 2: Objects in Microsoft Access

Examining Database Objects; Looking at Other Objects; Grouping Database Objects; Managing Data; Editing Data in Datasheet View

Module 3: Tables and Fields in Databases

Creating a Database; Creating Tables; Setting Field Properties; Lookup Fields and Indexes; Modifying Tables and Fields

Module 4: Handling Data and Queries

Sorting and Filtering Data; Displaying and Formatting Data; Using Queries to Retrieve Data; Finding Duplicates and Creating a Query in Design View

Module 5: Microsoft Access Forms and Design

Understanding and Creating Forms; Using the Form Wizard; Modifying and Customizing Forms; Using Form Layout and Design Tools; Formatting and Modifying Form Properties

Module 6: All Sorts of Reports!

Understanding Reports; Creating a Report; Using the Report Wizard; Using the Label Wizard; Understanding the Layout and Design Views; Using the Ribbon’s Report Layout Tools; Using the Ribbon’s Report Design Tools; Formatting Reports and Modifying Report Properties; Printing a Report

Microsoft Access Course

Microsoft Access – Level 2

In this course, you’ll work with advanced and complex queries, forms, and reports. Learn to create PivotCharts and PivotTables, import and export data, use macros, and maintain, optimize, and document a database. View PDF of Microsoft Access Level 2.

Module 1: Database Relationships in Microsoft Access

Understanding Database Relationships; Defining a Database Relationship; Viewing Existing Relationships; Viewing Data in Related Tables and Enforcing Referential Integrity; Modifying Table Design

Module 2: Finding and Cleaning Up Your Data

Selecting Data from Tables; Calculating Fields; Understanding Joins; Finding Unmatched Records; Creating Parameter Queries; Creating Action Queries; Summarizing and Grouping Data; Creating a Crosstab Query; Optimizing a Query

Module 3: Advanced Forms and Formatting in MS Access

Creating Advanced Forms; Naming Controls, Applying Conditional Formatting, and Changing the Tab Order; Using Advanced Controls; Creating and Modifying a Subform; Creating a Switchboard Form; Modifying a Switchboard Form

Module 4: Complex Reports and Specialty Commands

Creating Complex Reports; Embedding Objects in a Report, Applying Conditional Formatting, and Using the Find Command; Working with Subreports; Charting Data; Creating PivotTables and PivotCharts

Module 5: Importing and Data Collection PLUS Introducing SharePoint

Importing Data; Linking Data from an External Source; Exporting and Merging; Saving Database Objects and Databases; Data Collection; Introducing Microsoft SharePoint

Module 6: Macros for the Microsoft Access Database

Creating and Using Macros; Working with Macros; Maintaining a Database; Splitting a Database and Error Checking; Optimizing and Documenting a Database

AOLCC’s Integrated Learning System™

All courses in our programs are delivered through our unique Integrated Learning System™ (ILS). Through ILS, you will develop a true proficiency in each topic, no matter your age or skill level upon enrolment. Our learning coaches are with you every step of the way to provide individualized assistance and encouragement in a supportive and non-competitive learning environment. Here’s how it works:

  • You only advance to the next course when you are confident that you have mastered one topic and are ready to move on to the next
  • You participate in hands-on exercises, tasks and practice exams that test your knowledge and give you confidence
Learn More

Each level of Microsoft Outlook includes online/digital resources, interactive practice, remote access for safety, one-on-one Learning Coach assistance, and comprehensive textbooks. These courses are recognized across the province and country. They are also eligible for third party funding including Worksafe, insurance, employer, WorkBC organizations and many more.

Students accomplish the learning objectives for each module through a series of hands-on tasks, for which they are given step-by-step instructions and desired result checkpoints. The tasks provide ample opportunity for students to practice, apply, and develop the skills covered in the course.

A practice exercise and review questions are included at the end of each module to measure progress and reinforce the skills learned. There is also a lab exercise at the end of the course to provide further practice and review to reinforce the topics learned throughout the course, and to help prepare students for the exam.

Duration

Each level 1 - 3 Weeks
Let's Get Started
  • This field is for validation purposes and should be left unchanged.

Kamloops

Kelowna

Victoria

Nanaimo

Accreditations

B.C. Private Training Institutions Branch Logo

B.C. Private Training Institutions Branch

B.C. Education Quality Assurance Logo

B.C. Education Quality Assurance

Receive More Information, With No Obligation!

CONTACT US TODAY