Microsoft Access Classes – The Best Access Training Courses
Academy of Learning offers two Microsoft Access training levels for everyone 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
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 – 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
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.
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.