To use Access 2016 data in an Excel 2016 PivotTable,we use the ________.
A) "To Excel" command on the Access Data command tab
B) "To Excel" command on the Excel Data command tab
C) "From Access" command on the Access Data command tab
D) "From Access" command on the Excel Data command tab
E) "Get Data" command on the Excel Data command tab

Question

Quizplus · Accepted Answer

To use Access 2016 data in an Excel 2016 PivotTable, you use the "From Access" command located on the Excel Data command tab. This allows you to import data from an Access database directly into Excel, where it can be used in a PivotTable.

To Use Access 2016 Data in an Excel 2016 PivotTable,we