This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: Describe how to create an OLAP report for a Microsoft Access 2013 database in Microsoft Excel 2013. ... (Read 216 times)

ARLKQ

  • Hero Member
  • *****
  • Posts: 571
on: Jul 7, 2018
Describe how to create an OLAP report for a Microsoft Access 2013 database in Microsoft Excel 2013.
 
  What will be an ideal response?

Question 2

Given the functional dependency (A, B)  C, then it is true that A  C and B  C.
 
  Indicate whether the statement is true or false


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

Anonymous

  • Sr. Member
  • ****
  • Posts: 317
Reply #1 on: Jul 7, 2018
Answer to Question 1

To create an OLAP report for an Access 2013 database in Excel 2013, we use the Excel PivotTable tool. It is useful to have all the data for the PivotTable in one object, so we can create a view equivalent query in Access to organize the data. Excel 2013 provides a direct connection to an Access 2013 database via the From Access command on the Excel Data command tab. Once we open the database, we can select the view equivalent query object as the data source. This makes all the data columns available for use as rows or columns in the Excel PivotTable.

Answer to Question 2

FALSE


ARLKQ

  • Hero Member
  • *****
  • Posts: 571
Reply #2 on: Jul 7, 2018
Thank you


Anonymous

  • Sr. Member
  • ****
  • Posts: 317
Reply #3 on: Jul 7, 2018
No problemo


« previous next »
 

Did you know?

The most common treatment options for addiction include psychotherapy, support groups, and individual counseling.

Did you know?

Alcohol acts as a diuretic. Eight ounces of water is needed to metabolize just 1 ounce of alcohol.

Did you know?

Today, nearly 8 out of 10 pregnant women living with HIV (about 1.1 million), receive antiretrovirals.

Did you know?

Although the Roman numeral for the number 4 has always been taught to have been "IV," according to historians, the ancient Romans probably used "IIII" most of the time. This is partially backed up by the fact that early grandfather clocks displayed IIII for the number 4 instead of IV. Early clockmakers apparently thought that the IIII balanced out the VIII (used for the number 8) on the clock face and that it just looked better.

Did you know?

The use of salicylates dates back 2,500 years to Hippocrates’s recommendation of willow bark (from which a salicylate is derived) as an aid to the pains of childbirth. However, overdosage of salicylates can harm body fluids, electrolytes, the CNS, the GI tract, the ears, the lungs, the blood, the liver, and the kidneys and cause coma or death.

Language Access Services Language Access Services
Tall pad extensions can also be used to gain access to the frame of a vehicle. This position is ... Tall pad extensions can also be used to gain access to the frame of a vehicle. This position is ...
Apply oil or lotion across shoulders and to posterior neck. Turn the head to one side to access the ... Apply oil or lotion across shoulders and to posterior neck. Turn the head to one side to access the ...
Exploring Microsoft Office 2010, Volume 1 (2nd Edition) 2nd Edition Exploring Microsoft Office 2010, Volume 1 (2nd Edition) 2nd Edition
The Kinsey Report on American Women The Kinsey Report on American Women
List transformations and Create a table of values for the following log function: List transformations and Create a table of values for the following log function:
Video: The primary factors that affect circulation - MABP, CO and SVR

For a complete list of videos, visit our video library