Skip to main content
Business LibreTexts

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.

    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.

    Contributors and Attributions

    CC licensed content, Original
    • Aggregating Data. Authored by: Robert Danielson. Provided by: Lumen Learning. License: CC BY: Attribution