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 144 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?

Colchicine is a highly poisonous alkaloid originally extracted from a type of saffron plant that is used mainly to treat gout.

Did you know?

Street names for barbiturates include reds, red devils, yellow jackets, blue heavens, Christmas trees, and rainbows. They are commonly referred to as downers.

Did you know?

Fungal nail infections account for up to 30% of all skin infections. They affect 5% of the general population—mostly people over the age of 70.

Did you know?

The National Institutes of Health have supported research into acupuncture. This has shown that acupuncture significantly reduced pain associated with osteoarthritis of the knee, when used as a complement to conventional therapies.

Did you know?

There are approximately 3 million unintended pregnancies in the United States each year.

Alternate sites that can be used to create a new opening (-ostomy) in the colon. Alternate sites that can be used to create a new opening (-ostomy) in the colon.
Microsoft Word Attachments Microsoft Word Attachments
Workshop of Kane Kwei, Coffin in the shape of a film projector, Teshi area, Ghana, Africa. 2013. Workshop of Kane Kwei, Coffin in the shape of a film projector, Teshi area, Ghana, Africa. 2013.
Reinstall the spark plug wires and all brackets that were removed to gain access to the valve ... Reinstall the spark plug wires and all brackets that were removed to gain access to the valve ...
A replaceable PROM used in an older General Motors computer. Notice that the sealed access panel ... A replaceable PROM used in an older General Motors computer. Notice that the sealed access panel ...
Exploring Getting Started With Microsoft Windows 8 Exploring Getting Started With Microsoft Windows 8
Video: Hormonal regulation of pregnancy - weeks 17 through 38

For a complete list of videos, visit our video library