Microsoft Access 365 Advanced: Expert Database Solutions

Intended Organizations
Skill LevelAdvanced
Virtual | Live Trainer4 hours/day, 1 Day
In-Person | Onsite6 hours/day, 1 Day
Professional on a laptop with digital folders and files representing database records

Course Overview

This course teaches advanced Access® features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multiple-user access, and more. Knowledge of these features separates database professionals from casual database users or occasional designers.

Course Prerequisite: Microsoft Access for Office 365 Intermediate

Learning Objectives

  • Share data across applications
  • Use action, unmatched, and duplicate queries
  • Create complex reports and forms
  • Use macros to improve user interface design
  • Use VBA to extend database capabilities
  • Backup, compact, repair, perform analysis, check object dependencies, and document

Who It's For

  • Access users who want to develop advanced database management skills.
  • Database professionals who create complex forms, queries, and reports.
  • Professionals who want to automate database tasks using macros and VBA.
  • Teams responsible for securing and sharing multi-user databases.
  • Users who need to improve database performance, maintenance, and documentation.

Course Agenda

Seven modules · 21 topics
1Importing and Exporting Table DataTopics 1–3
  1. Import and Link Data
  2. Export Data
  3. Create a Mail Merge
2Using Queries to Manage DataTopics 4–5
  1. Create Action Queries
  2. Create Unmatched and Duplicate Queries
3Creating Complex Reports and FormsTopics 6–8
  1. Create Sub-Reports
  2. Create a Navigation Form
  3. Show Details in Sub-Forms and Popup Forms
4Creating Access MacrosTopics 9–12
  1. Create a Standalone Macro to Automate Repetitive Tasks
  2. Create a Macro to Program a User Interface Component
  3. Restrict Records by Using a Condition
  4. Create a Data Macro
5Managing a DatabaseTopics 13–15
  1. Back-Up a Database
  2. Manage Performance Issues
  3. Document a Database
6Using VBA to Extend Database Capabilities Topics 16–17
  1. Getting Started with VBA
  2. Using VBA with Form Controls
7Distributing and Securing a DatabaseTopics 18–21
  1. Split a Database for Multiple-User Access
  2. Implement Security
  3. Convert an Access Database to an ACCDE File
  4. Package a Database with a Digital Signature

About our Trainers

PTR training instructor headshot
PTR training instructor headshot
PTR training instructor headshot

Our Mission

Our facilitators are committed to delivering the latest industry trends, job-specific best practices, and the essential soft and hard skills needed in today’s workforce. PTR offers small and large organizations the choice between onsite and virtual training. Collaborate with our specialists to address challenges, bridge skill gaps, and tailor the learning experience to meet your company’s goals.

Frequently Asked Questions

What is the Microsoft Access 365 Advanced course about?

This course explores advanced Microsoft Access features for managing databases, creating complex forms and reports, automating tasks with macros, extending functionality with VBA, and securing databases for distribution and multi-user access.

Who should attend Microsoft Access 365 Advanced training?

The course is suitable for database professionals, experienced Access users, database designers, and business professionals who want to build more sophisticated database solutions.

What will I learn in this advanced Access training?

You will learn to import and export data, create action and specialized queries, design complex forms and reports, automate tasks with macros, use VBA, maintain databases, and prepare databases for secure distribution.

Will I learn how to create advanced queries in Microsoft Access?

Yes. The course covers action queries, unmatched queries, and duplicate queries to help manage records and perform specific database operations.

Does the course cover advanced forms and reports?

Yes. You will learn to create sub-reports, navigation forms, sub-forms, and popup forms to organize information and improve the user experience.

Can I automate tasks in Microsoft Access using macros?

Yes. The course teaches you to create standalone macros, automate repetitive tasks, program user interface components, restrict records using conditions, and create data macros.

What are the benefits of Microsoft Access 365 Advanced training?

This training can help you build more capable database solutions, automate repetitive operations, improve data management, strengthen database security, and prepare Access applications for distribution and shared use.

Discover More Ways to Build Your Skills

Microsoft Access 365 Advanced: Expert Database Solutions

Request a Training Quote

Share your team’s goals, and we’ll recommend the right skills training.