How to Access a Database PivotTable
- 1). Click "Start" on your desktop and select "Programs." Choose "Microsoft Office" and click "Microsoft Access" to open your database program.
- 2). Click "File" and then "Open" from the menu bar. Click "Browse" to go to the location where your database file is saved and click "Open."
- 3). Click on "Objects" in the database window. Choose between "Queries," "Reports" or "Forms" from the list of objects.
- 4). Click "Open" to view the database object.
- 5). Select "View," then choose "PivotTable View" to view the object as a PivotTable.
Source...