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.
Each Microsoft Access course is available at the following campuses:
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
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
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.