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

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

Creating a Pivot Table or Pivot Chart from a Form

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 forms: PivotTable and PivotChart. These views are available for your conventional Jet applications (MDB) forms, not for ADP forms.

Creating the Form to Display in Pivot Table or Pivot Chart View

The first thing you must do is build a form that is appropriate to display in Pivot Table or Pivot Chart view. Forms that lend themselves to be displayed in pivot table or pivot chart view provide many ways for users to manipulate their data. An example of such a forms 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 2002. As you can see, the idea of pivot tables is to let you slice and dice the data in any way you need to at a given moment in time.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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