13.16: Aggregating Data
- Page ID
- 46646
Learning Outcomes
- Aggregate data
To aggregate data in Access, start by selecting the “Totals” button in the tool bar to create a “Total” row at the bottom of the datasheet table view.

Then move the cursor to the field you wish to aggregate and right-click to expose the options.

From this approach, Access offers a Sum, Average, Count, Maximum, Minimum, Standard Deviation, and Variance aggregation option.
PRactice Question
Contributors and Attributions
CC licensed content, Original
- Aggregating Data. Authored by: Robert Danielson. Provided by: Lumen Learning. License: CC BY: Attribution