Jenna has attended:
Excel Intermediate course
Pivot Tables
How do i create a pivot table based on data in Microsoft access?
RE: Pivot Tables
Hi Jenna
To do this you need to connect to the data you want to Pivot Table which is stored in access.
Depending on the version of Microsoft Office you are using, you might be able to do this directly in Access. If you are using MS Access 2002/XP or 2003, you are able to view tables and queries as a Pivot table. To do this, simply click the drop down option next to the DATA / DESIGN VIEW button, and choose PIVOT TABLE. Then continue to use as you would a normal Pivot table.
If you do not have this option, you are probably using a different version of MS Office. In this case you should export the data from Access to excel. 2 ways of doing this.
From Access:
Select the object you want to export the data from.
Click TOOLS > OFFICE LINKS > ANALYSE WITH EXCEL.
This will send the data to excel, where you can then build a Pivot table from.
The other option is a bit more complex, and involves multiple technical steps to connect to the database. If the above two options do not solve your question, then let me know and I will step you through the process.
Regards
Richard
