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

Chapter 14. Pivot Tables and Pivot Charts > Getting Started with Pivot Tables

Getting Started with Pivot Tables

Any table or query can be given a PivotTable view by selecting it from the View drop-down list (see Figure 14.1). But this is merely the launch point for creating a pivot table; your work is just beginning. The virgin PivotTable view in Figure 14.2 can be compared to the Design view that greets you when you build a new form from scratch—but with one vital difference. With a form, you build in Design view, but the display is in Form view. With a pivot table, you build in PivotTable view and display in PivotTable view. The main building blocks of a pivot table are the fields in the field list, which you drag and drop onto specific areas of the table.

Figure 14.1. PivotTable and PivotChart are views in a table, form, or query; they are not separate objects in the Database window.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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