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

Chapter 5. Creating PivotTable Queries > What Is a PivotTable?

What Is a PivotTable?

To understand PivotTables, you need to see how they fit in with Access's other database-analysis features. Database analysis has several levels of complexity. The simplest level involves the basic lookup and retrieval of information. For example, if you have a database that lists the company sales reps and their territory sales, you can use a datasheet or form to search for a specific rep and to look up the sales in that rep's territory.

The next level of complexity involves more sophisticated lookup and retrieval techniques based on the querying tools you've seen in the previous chapters, particularly the use of totals and calculated fields. For example, suppose that each sales territory is part of a larger region, and you want to know the total sales in the eastern region. You can either subtotal by region or set up your criteria to match all territories in the eastern region and use the Sum function to get the total. To get more specific information, such as total eastern region sales in the second quarter, you just add the appropriate conditions to your criteria.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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