Access – Part 2
5 Based on 213 reviews- 85,890 Learners
- 287 Courses
Professionals using advanced query design techniques complete complex data retrieval tasks up to 40% faster and with greater accuracy than those relying only on basic tools. The Microsoft Access Training – Access Part 2 course equips you with the advanced features, queries, reports, and relational design practices that make this level of efficiency possible.
Request More InfoUpcoming Class Schedule
$590.00
Oct 06 - Oct 07, 2026
9:00 AM - 5:00 PM America/New_York- VILT
- Dec 10 - Dec 11, 2026
- 9:00 AM - 5:00 PM America/New_York
- VILT
In this course, you will expand your knowledge of relational database design, promote quality input from users, and learn how to improve database efficiency while strengthening data integrity. You’ll also implement advanced features in tables, queries, forms, and reports, giving you the ability to build databases that are more reliable, usable, and scalable.
The training focuses on optimization of Access databases, including performance tuning, normalizing data, applying data validation rules, and improving usability.
- 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.
Who should attend Access – Part 2 Course
This Microsoft Access training is designed for administrative staff, analysts, developers, and data managers who want to advance beyond the basics into optimization, automation, and complex reporting.
Prerequisites for Access – Part 2 Course
Access – Part 2 Course Outline
- Create lookups within a table
- Work with subdatasheets
- Create query joins
- Create subqueries
- Summarize data
- Apply conditional formatting
- Create tab pages with subforms and other controls
- Apply advanced formatting to a report
- Add a calculated field to a report
- Control pagination and print quality
- Import and link data
- Export data
- Create action queries
- Create unmatched and duplicate queries
- Create subreports
- Create a navigation form
- Show details in subforms and popup forms
- 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
- Getting started with VBA
- Using VBA with form controls
- Back up a database
- Manage performance issues
- Document 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
- What Is Microsoft Copilot Chat?
- The Magic Prompt Formula
- Work Smarter with AI
Resources
FAQs on Access – Part 2
Participants should have completed Access – Part 1 or have equivalent hands-on experience with basic Access functions like tables, simple queries, forms, and reports.
This course targets administrative staff, analysts, developers, and data managers looking to move beyond basic Access skills into optimization, automation, and advanced reporting techniques.
You’ll learn to build advanced queries and joins, improve table usability with lookups, enhance forms with conditional formatting, create complex reports with calculated fields, automate tasks with macros, and extend functionality using VBA.
Yes, the course includes creating standalone and data macros to automate repetitive tasks, as well as an introduction to VBA for extending database capabilities and working with form controls.
The course covers advanced query techniques (joins, subqueries, action queries, unmatched/duplicate queries), importing and exporting data, and creating complex reports and forms including subreports, navigation forms, and popup forms.