Connecting to an Access database

If you run a small business, you might maintain important business data in…an Access database.…If you do, you can create a PivotTable based on the original database table,…instead of importing the data into Excel.…In this movie, I'll show you how to do just that.…To create a PivotTable, first you click the Insert tab on the ribbon, and then…click the PivotTable button. Then in the Create PivotTable dialog box, select…the Use an external data source option, and then click Choose Connection.…

If the connection we want doesn't appear in the existing connections list, so…we'll click Browse for More and then navigate to my Exercise Files folder, which…is on my Desktop in the Exercise Files folder and in Chapter 01.…And the database that I want to use is called PTDatabase, so I'll click it and click Open.…Now we can create the PivotTable report on an existing worksheet and right now…the location is a Sheet1 cell A1 and that is the highlighted cell here. That's fine.…

So we can click OK and create a link to that data and create a PivotTable…