To use the Access 2016 database in an Excel 2016 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

Quizplus · Accepted Answer

Creating a view-equivalent query in Access allows the data to be organized in a way that is conducive to creating a PivotTable in Excel. Storing the data in a worksheet, a Word document, a PowerPoint slide show, or a Visio diagram would not be as helpful for creating a PivotTable.

To Use the Access 2016 Database in an Excel 2016