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
Contribute!
Did you have an idea for improving this content? We’d love your input.
Candela Citations
CC licensed content, Original
- Aggregating Data. Authored by: Robert Danielson. Provided by: Lumen Learning. License: CC BY: Attribution