Connecting to an Access database


show more Connecting to an Access database provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth show less
please wait ...

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 c...

Connecting to an Access database
Video duration: 2m 11s 3h 43m Intermediate

Viewers:

Connecting to an Access database provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth

Subject:
Business
Software:
Excel
Author:
please wait ...