Select the External Data

Microsoft Access databases have Tables as well as Queries. When you connect to an Access database, you will be prompted to Select a Table or Query.

 

3. Try it: Select a Table of Query

Select Table: tblCustomers.

Keep going...!

 

 

Memo to Self: A Query is a way to use formulas and filters to present the data in your tables.

Exam 77-888: Microsoft Excel Expert 2010

3. Presenting Data Visually

3.4. Apply and manipulate PivotCharts: Use an External Data Source

Insert-> Table-> PivotChart->Use an External Data Source