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

Question

Quizplus · Accepted Answer

Microsoft Excel 2016 is the best choice for creating an OLAP report for an Access 2016 database using PivotTables. Excel has powerful tools for analyzing and presenting data, including PivotTables and PivotCharts, which can be used to create dynamic, interactive reports based on OLAP cubes. Access can also be used to create OLAP queries and cubes, but Excel is generally more user-friendly and flexible for creating reports. Word, Visio, and PowerPoint are not well-suited for creating OLAP reports.

To Create an OLAP Report for an Access 2016 Database,we