Advanced Microsoft Access 365 Training (ACC365.2)
Develop advanced Microsoft Access 365 skills in queries, relationships, data integration, forms, reports, macros, navigation, and database maintenance.
Register or Request Training
- Private class for your team
- Live expert instructor
- Online or on‑location
- Customizable agenda
- Proposal responses same day as request
- On-Demand 24/7
- Readings, Video Presentations, Exercises
- Quizzes to knowledge check
- Life-Time Access
Course Overview
Build on your Microsoft Access experience to create powerful, efficient, and maintainable desktop databases. Designed for power users, analysts, developers, and teams, this advanced course covers relationships, complex queries, external data exchange, and the creation of polished forms and reports.
You will also learn to automate tasks with macros, create navigation forms, split databases for distribution, and apply maintenance practices that support user-friendly Access applications.
Course Benefits
- Create table relationships and apply referential integrity to improve data accuracy and consistency.
- Build parameter, select, and action queries for analyzing and managing data.
- Import, link, and export data using Excel, other databases, and external sources.
- Design and refine forms with effective layouts, formatting, properties, and subforms.
- Create professional reports with grouping, sorting, controls, special fields, and subreports.
- Use macros to automate repetitive database tasks.
- Build navigation forms and configure them as application interfaces.
- Split, distribute, and maintain desktop Access databases.
Delivery Methods
Delivered for your team at your site or online.
Learn at your own pace with 24/7 access.
Microsoft Certified Partner
Webucator is a Microsoft Certified Partner. We design and deliver training that aligns directly with Microsoft's official technologies, standards, and learning objectives.
Course Outline
- Relationships
- Review
- Referential integrity
- Relationships
- Naming conventions
- Creating relationships exercise
- Advanced Queries
- Query Design view
- Review of select queries
- Select queries with criteria
- Logical operators
- Parameter queries
- Action queries
- Creating select and action queries exercise
- Creating a parameter query exercise
- Table Functions
- Importing data
- Linking tables from external sources
- Importing tables from other databases
- Tables from templates and Application Parts
- Importing data from Excel exercise
- Exporting data
- Exporting data to Excel exercise
- Advanced Forms
- Design view
- Formatting
- Tab order and properties
- Creating forms with Application Parts
- Creating a subform
- Creating forms exercise
- Modifying a form
- Advanced Reports
- Design view
- Report sections
- Arranging fields on a report
- Resizing the detail section
- Grouping and sorting
- Setting report properties
- Special report fields
- Controls
- Subreports
- Application Parts
- Deleting a report
- Formatting a report
- Creating reports exercise
- Macros
- Macro basics
- Running a macro
- Creating simple macros exercise
- Completing the Desktop Application
- Navigation forms
- Running macros from a navigation form
- Setting a navigation form as the default form
- Creating a navigation form exercise
- Splitting the database
- Distributing the front-end database
- Database maintenance
Class Materials
Each student receives a comprehensive set of materials, including course notes and all class examples.
Class Prerequisites
Experience in the following is required for this Microsoft Access class:
Participants should have prior experience with Microsoft Access and be comfortable creating and working with basic tables, queries, forms, and reports.
Prerequisite Courses
Courses that can help you meet these prerequisites:
Follow-on Courses
Have questions about this course?
We can help with curriculum details, delivery options, pricing, or anything else. Reach out and we’ll point you in the right direction.