13.16: Aggregating Data
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.
Contributors and Attributions
CC licensed content, Original
- Aggregating Data. Authored by : Robert Danielson. Provided by : Lumen Learning. License : CC BY: Attribution