• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 2. What Every Developer Needs to... > Creating a Pivot Table or Pivot Char...

Creating a Pivot Table or Pivot Chart from a Table

Pivot tables and pivot charts provide great ways for you to summarize detailed data stored in your Jet and SQL Server databases. Pivot tables present your data in a spreadsheet-like format, whereas pivot charts automatically render pivot table views as line, bar, or area charts. Access 2002 and Access 2003 provide two new views for tables: PivotTable and PivotChart. These views are available for both your conventional Jet applications (MDB) and your Access Projects (ADP).

Creating the Table to Display in PivotTable or PivotChart View

The first thing you must do is build a table that is appropriate to display in PivotTable or PivotChart view. Tables that lend themselves to be displayed in PivotTable or PivotChart view provide many ways for users to manipulate their data. An example of such a table is one that contains information about country, city, salesperson, sales, and date of sale. You could determine sales by city and salesperson for each month, or you could determine sales in each country for each salesperson during the year of 2002. As you can see, the idea of pivot tables is to let you slice and dice the data any way you need to at a given moment in time. A table ideal for you to display as a pivot table generally would not be very normalized.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint