To use the Access 2013 database in an Excel 2013 PivotTable, it ...

[Charlie]

To use the Access 2013 database in an Excel 2013 PivotTable, it is generally useful to:
 
  A) create a view-equivalent query in Access to organize the data.
  B) store the needed data in an Excel worksheet.
  C) store the needed data in a Word document.
  D) store the needed data in a PowerPoint slide show.
  E) store the needed data in a Visio diagram.

Question 2

To create an OLAP report for an Access 2013 database, we can build a PivotTable in:
 
  A) Microsoft Access 2013.
  B) Microsoft Word 2013.
  C) Microsoft Visio 2013.
  D) Microsoft Excel 2013.
  E) Microsoft PowerPoint 2013.

[perkiness]

Answer to Question 1

A

Answer to Question 2

D