Do you have the right personality for College?Take Assessment!
- Why AOLCC
- Contact Us!
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.
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
Examining Database Objects; Looking at Other Objects; Grouping Database Objects; Managing Data; Editing Data in Datasheet View
Creating a Database; Creating Tables; Setting Field Properties; Lookup Fields and Indexes; Modifying Tables and Fields
Sorting and Filtering Data; Displaying and Formatting Data; Using Queries to Retrieve Data; Finding Duplicates and Creating a Query in Design View
Understanding and Creating Forms; Using the Form Wizard; Modifying and Customizing Forms; Using Form Layout and Design Tools; Formatting and Modifying Form Properties
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.
Understanding Database Relationships; Defining a Database Relationship; Viewing Existing Relationships; Viewing Data in Related Tables and Enforcing Referential Integrity; Modifying Table Design
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
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
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
Importing Data; Linking Data from an External Source; Exporting and Merging; Saving Database Objects and Databases; Data Collection; Introducing Microsoft SharePoint
Creating and Using Macros; Working with Macros; Maintaining a Database; Splitting a Database and Error Checking; Optimizing and Documenting a Database
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:
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.
B.C. Private Training Institutions Branch
B.C. Education Quality Assurance