Although Access is a powerful database tool, you may wish to be able to Visualize you data in the form of a well-constructed Chart. For instance, let’s say that you have your net sales quantified by region, and you would like to slap together a quick Pie Chart for your presentation to the board. Here is where Excel is your app of choice!
With Excel 2013 open, do the following:
1. Open your Data ribbon
2. Click on the Get External Data down arrow
3. Select From Access
4. Click on the Access File you wish to view
5. Choose the Table you want to import and click OK
Your Access data will then be imported in a contemporary Excel Table from which you can select the data from which to make your Pie Chart.
Simple as that! Importing and manipulating your Access data in Excel has never been easier. Totally Cool!