What Is a Pivot Table in Access?


Quick Answer

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.

Continue Reading
Related Videos

Full Answer

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.

Learn more about Software

Related Questions