PIVOT TABLES

  • Thread starter Thread starter Olden Doode
  • Start date Start date
O

Olden Doode

What is a PIVOT TABLE and how is it used, and what is it used for?

It appears to be one of those Microsoft anomalies that one needs to
memorize a whole bunch of trees before the forest becomes evident.

It appears in Excel and Access documenation, and looks as though it is
merely some form of automated query modification procedure to presnet
data in a number of different display types. ie charts or graphs etc.
 
Pivot Tables are a wonderful feature. They are used to summarizes long lists
of information. The nice part about the pivot table is that is interactive.
You are not limited to just what is originally shown in the returned pivot
table, you can actually move fields around in the grid to get different
summaries.

The best way to learn how to use Pivot Tables is to try them out in Excel
first.

Excel allows you to create the pivot table and use the interactivity in a
non-threathing manner.

When you use a pivot table in Access, it has the same aspects but a slightly
different look.

Try them out in Excel, then when you feel comfortable, try to create one in
Access.

I think you will find the power in this useful tool.

RRLady
 
Back
Top