Using Pivot Tables to View Data in Access 2007

A good overview and introduction to using Access database pivot tables. This video tutorial gives you enough to get you going and experiment with the flexible options of a pivot table and is clearly explained – hence the 10 minute video.

The key thing to remember is that you need to think about the grouping and analysis of the data required for this type of report which probably means a query and not a table in which your pivot table will be based.

Using the RDBMS (see my eBook offers for more help) is ever more present and important here too to help collate the correct field arrangement.

Finally, users tend to lean towards using Excel pivot tables (because they are used to it)  but Access is generally much better!

This entry was posted in Database Theory, MS Access, Queries, Tables and tagged , , , , . Bookmark the permalink.

One Response to Using Pivot Tables to View Data in Access 2007

  1. Ben says:

    Thanks for a marvelous posting! I actually enjoyed reading it, you happen to be a great author.I will be sure to bookmark your blog and may come back at some point. I want to encourage you to ultimately continue your great posts, have a nice weekend!

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Confirm you are human.