98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot tables and link to access database
Pivot tables and link to access database
Resolved · Medium Priority · Version 2013
Karen has attended:
Excel Pivot Tables course
Pivot tables and link to access database
In the 2003 version, once a pivot table had been created in Excel, it was possible to go directly back to the access database table query to adjust the fields etc. How is this done in the 2013 version?
RE: pivot tables and link to access database
Hi Karen,
Thank you for the forum question.
You can still amend the connection to an Access DataBase.
You will need to create the connection using MS Query. Go to the Data tab on the ribbon click From Other Sources and click From Microsoft Query. This will open up a connection wizard. Select MS Access Database* to the left and click OK.
In the Select Database dialog box navigate to the database and click OK. In the Query Wizard - Choose Columns dialog box select the columns you want to use in your PivotTable. After you have selected to columns click next. In the Filter Data dialog box you can filter the data. Click next. In the Sort Order dialog box you can sort the data. Click Next.
Click Next in the Finish dialog box.
In the Import Data dialog box select you want to create a PivotTable.
If you want to amend the database query click Connections in the Connections group on the Data tab. Select Query from MS Access Database and click Properties. In the Connection Properties dialog box click on the Definition tab. Click Edit Query bottom left and you will be back in the MS Query.
I hope this has answered your question.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Thu 27 Oct 2016: Automatically marked as resolved.
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. |
Excel tip:Wrapping Text in a Cell in an Excel 2010 WorkbookWhen you have a lot of text you want to put in a particular cell but you can't decrease the font size to fit because the text will then become ineligible, then manually wrap the text in a cell by simply pressing ALT+ENTER. |