Multiple Choice
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.
Correct Answer:
Verified
Correct Answer:
Verified
Q2: OLAP reports can be created using the
Q3: To create an OLAP report for an
Q4: Data warehouses use a(n):<br>A) operational database.<br>B) dimensional
Q6: When creating an OLAP report based on
Q7: Data Mining uses sophisticated statistical and mathematical
Q10: Although Excel 2013 will create a PivotTable
Q17: The term _ refers to the capability
Q45: BI reporting systems summarize the current status
Q69: Distributed databases can be distributed by partitioning
Q102: Operational databases contain a fact table.