Microsoft Access 365 Advanced: Expert Database Solutions
Intended Organizations
Intended Organizations
Organizational type shows which workplace or sector each group training program best aligns with. Most courses adapt across settings to support unique goals and outcomes.
Corporate & Business GroupsProfessional development for small groups, large business teams, and enterprises across industries focused on building valuable skills.
Federal GovernmentCreated for federal agencies and employees, with practical training that helps build job-relevant skills for the federal workplace.Course pricing is available for federal agencies through the GSA Schedule.
State & Local GovernmentTraining for state, county, municipal, and other public-sector teams, focused on building skills that support government and public service work.
Intended Organizations
Organizational type shows which workplace or sector each group training program best aligns with. Most courses adapt across settings to support unique goals and outcomes.
Federal GovernmentCreated for federal agencies and employees, with practical training that helps build job-relevant skills for the federal workplace.Course pricing is available for federal agencies through the GSA Schedule.
State & Local GovernmentTraining for state, county, municipal, and other public-sector teams, focused on building skills that support government and public service work.
Corporate & Business GroupsProfessional development for small groups, large business teams, and enterprises across industries focused on building valuable skills.
Intended Organizations
Organizational type shows which workplace or sector each group training program best aligns with. Most courses adapt across settings to support unique goals and outcomes.
State & Local GovernmentTraining for state, county, municipal, and other public-sector teams, focused on building skills that support government and public service work.
Federal GovernmentCreated for federal agencies and employees, with practical training that helps build job-relevant skills for the federal workplace.Course pricing is available for federal agencies through the GSA Schedule.
Corporate & Business GroupsProfessional development for small groups, large business teams, and enterprises across industries focused on building valuable skills.
Skill LevelAdvanced
Virtual | Live Trainer4 hours/day, 1 Day
In-Person | Onsite6 hours/day, 1 Day
Skill Level & Progression
Skill level reflects the recommended course experience and helps match training to your team's needs. Most training courses support all learning levels.
General WorkforceDevelops team-ready capabilities across business roles and experience levels while strengthening skills and organizational results.
FundamentalsBuilds introductory proficiency in essential terminology, core concepts, and workplace best practices for real-world application.
IntermediateStrengthens existing knowledge through advanced functions, skill strategies, and deeper exploration of core concepts.
Advanced(this course)Deepens expertise through complex subject matter, specialized skills, advanced analysis, and higher-level instruction.
Course Formats
Train on your terms. Choose virtual or onsite delivery, schedule sessions around your team’s availability, and align course content with your objectives and real-world challenges.
Virtual Training4 hours/day, 1 DayLive, interactive, instructor-led training delivered through a secure videoconferencing platform.
Onsite Training6 hours/day, 1 DayEngaging, instructor-led training delivered in person at the location of your choice.
Course Duration
Course duration varies by training format and time needed to effectively cover the material, with hours per day and total days listed.
Generates a branded PDF — downloads directly to your device
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.
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
Import and Link Data
Export Data
Create a Mail Merge
2Using Queries to Manage DataTopics 4–5
Create Action Queries
Create Unmatched and Duplicate Queries
3Creating Complex Reports and FormsTopics 6–8
Create Sub-Reports
Create a Navigation Form
Show Details in Sub-Forms and Popup Forms
4Creating Access MacrosTopics 9–12
Create a Standalone Macro to Automate Repetitive Tasks
Create a Macro to Program a User Interface Component
Restrict Records by Using a Condition
Create a Data Macro
5Managing a DatabaseTopics 13–15
Back-Up a Database
Manage Performance Issues
Document a Database
6Using VBA to Extend Database Capabilities Topics 16–17
Getting Started with VBA
Using VBA with Form Controls
7Distributing and Securing a DatabaseTopics 18–21
Split a Database for Multiple-User Access
Implement Security
Convert an Access Database to an ACCDE File
Package a Database with a Digital Signature
About our Trainers
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.
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.
Microsoft Access 365 Advanced: Expert Database Solutions
Request a Training Quote
Share your team’s goals, and we’ll recommend the right skills training.
PTR Training uses 'cookies' to improve your website experience. View our Privacy Policy for details. By continuing, you agree to accept and adhere to our Terms of Use.