A pivot table in Access is a data processing tool used to summarize large amounts of data quickly and easily. It is a feature also found in spreadsheets and business intelligence programs.
A pivot table can sort, filter and group data. It is also useful in analyzing totals and viewing different summaries of data. Users can alter the structure of a summary by pivoting and dragging fields; hence the name "pivot table."
A pivot table consists of column, row and data fields. The fields allow aggregation functions including standard deviation, average, sum and count. Aggregations allow users to easily display data.