Microsoft Access 365 Intermediate: Optimize Queries and Reports

Intended Organizations
Skill LevelIntermediate
Virtual | Live Trainer4 hours/day, 1 Day
In-Person | Onsite6 hours/day, 1 Day
Professionals reviewing database reports and data on multiple monitors

Course Overview

In this course, you will expand your knowledge of relational database design, promote quality input from users, improve database efficiency and promote data integrity, and implement advanced features in tables, queries, forms, and reports. Extending your knowledge of Access will result in a robust, functional database for your users.

Course Prerequisite: Microsoft Access for Office 365 Basic

Next Course: Microsoft Access for Office 365 Advanced

Learning Objectives

  • Provide input validation features to promote the entry of quality data into a database
  • Organize for efficiency and performance
  • Improve the usability of Access tables
  • Create advanced queries
  • Use advanced formatting and controls
  • Use advanced formatting and calculated fields

Who It's For

  • Access users who want to strengthen their database design and management skills.
  • Professionals who need to improve data accuracy and database integrity.
  • Database users who want to create advanced queries and summarize data.
  • Professionals who need to design user-friendly forms and efficient reports.
  • Users preparing to develop advanced Microsoft Access database solutions.

Course Agenda

Six modules · 16 topics
1Promoting Quality Data InputTopics 1–2
  1. Restrict Data Input Through Field Validation
  2. Restrict Data Input Through Forms and Record Validation
2Improving Efficiency and Data IntegrityTopics 3–5
  1. Data Normalization
  2. Associate Unrelated Tables
  3. Enforce Referential Integrity
3Improving Table UsabilityTopics 6–7
  1. Create Lookups Within a Table
  2. Work with Subdatasheets
4Creating Advanced QueriesTopics 8–10
  1. Create Query Joins
  2. Create Subqueries
  3. Summarize Data
5Improving Form PresentationTopics 11–12
  1. Apply Conditional Formatting
  2. Create Tab Pages with Subforms and Other Controls
6Creating Advanced ReportsTopics 13–16
  1. Apply Advanced Formatting to a Report
  2. Add a Calculated Field to a Report
  3. Control Pagination and Print Quality
  4. Add a Chart to a Report

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 Intermediate course about?

This course builds on basic Access knowledge and teaches participants to improve database design, validate data, enhance table usability, create advanced queries, and develop professional forms and reports.

Who should attend Microsoft Access 365 Intermediate training?

The course is suitable for database users, administrative professionals, analysts, and Access users who want to improve their database management, reporting, and data integrity skills.

How does the course help improve data accuracy in Access?

You will learn to restrict data entry using field validation, form validation, and record validation rules. These features help reduce incorrect entries and maintain better data quality.

Will I learn about database normalization and referential integrity?

Yes. The course covers data normalization, associating unrelated tables, and enforcing referential integrity to improve database structure and maintain consistency between related records.

Does the course cover advanced Microsoft Access queries?

Yes. You will learn to create query joins and subqueries, as well as summarize data to retrieve and analyze information from your database more effectively.

Does the course teach advanced report creation in Access?

Yes. You will learn to apply advanced report formatting, add calculated fields and charts, and control pagination and print quality for clearer, more professional reports.

Discover More Ways to Build Your Skills

Microsoft Access 365 Intermediate: Optimize Queries and Reports

Request a Training Quote

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