Friday, June 10, 2011

How Do Cross Tabs And Pivot Tables Differ In Microsoft Access?

Microsoft Access can show grouped and summarised data in two similar ways, using Cross Tabs and Pivot Tables. Cross Tabs are created use queries and Pivot Tables can be created directly from tables or queries, or by creating a Pivot Table on a form. This article describes how each are created and summaries their differences. Cross Tabs and Pivot Tables both sort and group data and produce a neat row by column table with a calculation for each row and column intersect.

The full article appears here:
http://www.microsofttraining.net/article-1707-cross-tabs-and-pivot-tables-differ-in-microsoft-access.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com

0 Comments:

Post a Comment

<< Home