What is a pivot table in access?
A pivot table in Microsoft Access 2007 is a visual representation of data in a database program. You can customize the look of the pivot table in this version or in earlier versions, including MS Access 2003.FunctionThe MS Access 2007 Pivot Table/Pivot Chart feature enables users to rearrange data using a crosstab query. The table includes two sets of values, one on the horizontal axis and one on the vertical axis.BenefitsAccording to TechRepublic, using the pivot table enables the programmer to avoid the step of building a query before developing the pivot table. The programmer looks at a data table and programs the values for data to be displayed in the pivot table.SummariesA pivot table not only sorts data, it also provides summaries. Examples of summaries for data include the sum, the average, the percent and the standard deviation of a data set. You can build a pivot table using tables of data in Access or in MS Excel.LayoutThe Pivot Table/Pivot Chart feature enables the user to c
