Forum home » Delegate support and help forum » Microsoft Access Training and help » access database course - Pivot tables
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
access database course - Pivot tables
Resolved · Low Priority · Version Standard
Reply Tue 6 Nov 2007, 16:55Delegate Nuno said...
Nuno has attended:
Access Intermediate course
Excel Advanced course
Pivot tables
How do I arrange data to work with excel pivot tables?
For upcoming training course dates see: Pricing & availability
RE: Pivot tables
Hi Nuno
Thank you for your question.
You can select an table or query that you have created in Access, then find the OfficeLinks button on the Database toolbar, and select Analyze it with Microsoft Excel.
This is export the data from the database into an Excel spreadsheet for you. You might find that any numerical values you have in the table or query you export are now stored as text in the Excel spreadsheet, but if you select all the values in Excel and use the SmartTag with the ! symbol on it (that appears automatically) you will be able to choose Convert to Number.
Then go to Data-PivotTable or PivotChart report and follow through the wizard to create your pivottable.
The resulting pivottable will be easier to work with if you are exporting a table or query that contains numerical values; and also if the information is as complete as possible (i.e. as less incomplete records as possible).
I hope this helps.
Amanda
|