How to Create Aggregate Queries MS Access

Updated on:

May 12, 2026

By:

Use this interactive demo to learn how to build aggregate queries using Query Design in MS Access.

Quick summary

This tutorial shows how to create aggregate queries in Microsoft Access using the Query Design view. You will learn how to add tables, select fields, enable the Totals row, and apply aggregate functions to summarize data.

Steps

Go to the Create tab in the MS Access ribbon.
Select the Query Design button to open the query builder.
Add the tables or queries you want to use, then click Add Selected Tables.
Drag the desired field into the query grid.
Click the Totals button in the Query Design toolbar to enable the Total row.
For each column in the query, select an aggregate function in the Total row (e.g. Sum, Count, Avg).
Click the Run button to execute the query and view the aggregated results.

📌 Why this matters

Aggregate queries in Microsoft Access allow users to summarize, group, and calculate data across large datasets without writing manual SQL. Using the Query Design view and built-in aggregate functions like Sum, Count, and Average, Access users can quickly generate meaningful reports and insights from relational data. This capability is essential for analysts, administrators, and business users who rely on Access to manage and interpret structured data. Mastering aggregate queries in Access reduces manual data processing and enables faster, more accurate decision-making.

Your product deserves an interactive demo

Start free

How to Integrate a Microsoft Excel Database with Excel

How to Integrate Google Calendar with an MS Access Database

How to Integrate Google Sheets with an MS Access Database