Multiple Choice
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
Correct Answer:
Verified
Correct Answer:
Verified
Q3: OLAP provides the ability to sum,count,average,and perform
Q20: Snowflake schemas have normalized _.<br>A)fact tables<br>B)dimension tables<br>C)map
Q58: Business Intelligence (BI)reporting systems can analyze data
Q59: To arrange the PivotTable columns and rows
Q60: To deal with historical data values,dimensional databases
Q62: The simplest way to lease cloud services
Q65: A(n)_ is an information system that helps
Q67: Data warehouses use a(n)_.<br>A) operational database<br>B) dimensional
Q68: A data warehouse database differs from an
Q69: Distributed databases can be distributed by partitioning