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.

Datasheet table showing the word "Total" on the bottom on the far left of the sheet.

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

Datasheet table with a cell selected in the "Total" row, prompting a dialogue box to appear with the following options: None, Sum, Average, Count, Maximum, Minimum, Standard Deviation, and Variance.

From this approach, Access offers a Sum, Average, Count, Maximum, Minimum, Standard Deviation, and Variance aggregation option.

Practice Question