Microsoft 365 - Access Level 3

Overview

This 1-day, hands-on course is based on the current Microsoft 365 Access application. Participants using Access 2016 or later will be able to follow along, although some of the newest features may not be available in older versions.

This course is designed for learners with advanced experience using Access or databases equivalent to On-Track Microsoft 365 Access Level 2. Self-taught users may find this course a valuable refresher.

Microsoft Access is a powerful relational database application that enables users to store, organize, and analyze data efficiently. This course introduces participants to the fundamentals of database design and progresses through advanced techniques for creating queries, forms, reports, and automation tools. Learners will gain practical skills to build and manage databases, integrate Access with other Microsoft applications, and apply best practices for data integrity and security. By the end of the series, participants will be equipped to use Access confidently for real-world business and data management tasks.

Prerequisites

• Familiarity with Microsoft Access equivalent to Level 2.

Learning Objectives

Through the use of hands-on exercises participants will learn to:

• Automate tasks using macros.
• Optimize database performance.
• Create advanced reports and dashboards.
• Apply security and privacy considerations in database management.
• Integrate Access with other Microsoft Office applications for workflow efficiency.
• Troubleshoot common issues and maintain database reliability.

Course Outline

Module 1 - Quick Review of Fundamentals

Database Creation

Tables, Queries, Forms and Reports

Module 2 - Macros and Automation

Creating and running macros

Automating tasks and events

Module 3 - Advanced Reporting

Subreports and charts

Dashboards and summary reports

Module 4 - Performance Optimization

Compact and repair

Indexing strategies

Module 5 - Integration

Linking Access with Excel and Outlook

Exporting and importing data

Module 6 - Security and Best Practices

User-level security

Data validation and error handling

ON-TRACK Corporate Training has a diverse and flexible schedule that can be customized to your needs. We offer group courses (both public and corporate), one-on-one training, virtual (on-line) classroom (Zoom etc.) and on-site training options. We also have easily accessible on-line training videos on OnTrackTV.