Course Overview
TOPMicrosoft Access Training - Access Part 2 (Advanced) develops the skills to design and optimize robust relational databases beyond the basics. You will strengthen data integrity and performance through normalization, validation rules, indexing, and efficient relational design. The course guides you in implementing advanced features across tables, queries, forms, and reports, including subqueries, action queries, conditional formatting, calculated fields, and charts. Emphasis is placed on usability and scalability, with hands-on practice in macros, introductory VBA, data import/export, and database management. By the end, you can build reliable, user-friendly Access solutions that retrieve complex data faster and support effective decision-making.
Scheduled Classes
TOP| 12/10/26 - EVT - Virtual Classroom - Virtual Instructor-Led | (click to enroll)
 |
| 03/03/27 - EVT - Virtual Classroom - Virtual Instructor-Led | (click to enroll)
|
| 05/03/27 - EVT - Virtual Classroom - Virtual Instructor-Led | (click to enroll)
|
| 07/12/27 - EVT - Virtual Classroom - Virtual Instructor-Led | (click to enroll)
|
| 09/09/27 - EVT - Virtual Classroom - Virtual Instructor-Led | (click to enroll)
|
| 11/08/27 - EVT - Virtual Classroom - Virtual Instructor-Led | (click to enroll)
|
| 12/22/27 - EVT - Virtual Classroom - Virtual Instructor-Led | (click to enroll)
|
What You'll Learn
TOPIn this course, you will optimize an Access database.
You will:
- Provide input validation features to promote the entry of quality data into a database.
- Organize a database for efficiency and performance, and to maintain data integrity.
- Improve the usability of Access tables.
- Create advanced queries to join and summarize data.
- Use advanced formatting and controls to improve form presentation.
- Use advanced formatting and calculated fields to improve reports.
Outline
TOP- Improving Table Usability
- Create lookups within a table
- Work with subdatasheets
- Creating Advanced Queries
- Create query joins
- Create subqueries
- Summarize data
- Improving Form Presentation
- Apply conditional formatting
- Create tab pages with subforms and other controls
- Creating Advanced Reports
- Apply advanced formatting to a report
- Add a calculated field to a report
- Control pagination and print quality
- Importing and Exporting Table Data
- Import and link data
- Export data
- Using Queries to Manage Data
- Create action queries
- Create unmatched and duplicate queries
- Creating Complex Reports and Forms
- Create subreports
- Create a navigation form
- Show details in subforms and popup forms
- Creating Access Macros
- 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
- Using VBA to Extend Database Capabilities
- Getting started with VBA
- Using VBA with form controls
- Managing a Database
- Back up a database
- Manage performance issues
- Document a database
- Distributing and Securing a Database
- Split a database for multiple-user access
- Implement security
- Convert an Access database to an ACCDE file
- Package a database with a digital signature
- Microsoft Copilot Chat in Action
- What Is Microsoft Copilot Chat?
- The Magic Prompt Formula
- Work Smarter with AI
Prerequisites
TOPAccess - Part 1 or equivalent experience.
Who Should Attend
TOPThis course is ideal for administrative staff, analysts, developers, and data managers looking to move beyond basic Access skills into optimization, automation, and complex reporting. It benefits professionals who design or maintain databases and need stronger query, form, and report capabilities to improve performance, integrity, and usability.
