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

There are 20 feet of blood vessels in each square inch of human skin.

Did you know?

More than 30% of American adults, and about 12% of children utilize health care approaches that were developed outside of conventional medicine.

Did you know?

Hippocrates noted that blood separates into four differently colored liquids when removed from the body and examined: a pure red liquid mixed with white liquid material with a yellow-colored froth at the top and a black substance that settles underneath; he named these the four humors (for blood, phlegm, yellow bile, and black bile).

Did you know?

When intravenous medications are involved in adverse drug events, their harmful effects may occur more rapidly, and be more severe than errors with oral medications. This is due to the direct administration into the bloodstream.

Did you know?

Once thought to have neurofibromatosis, Joseph Merrick (also known as "the elephant man") is now, in retrospect, thought by clinical experts to have had Proteus syndrome. This endocrine disease causes continued and abnormal growth of the bones, muscles, skin, and so on and can become completely debilitating with severe deformities occurring anywhere on the body.

Desert shrubs create distinctive thermal microclimates in the desert landscape Desert shrubs create distinctive thermal microclimates in the desert landscape
Needle-nose pliers are used where there is limited access to a wire or pin that needs to be ... Needle-nose pliers are used where there is limited access to a wire or pin that needs to be ...
The primary ignition system is used to trigger and therefore create the secondary (high-voltage) ... The primary ignition system is used to trigger and therefore create the secondary (high-voltage) ...
The 10 Deadliest Hurricanes to Strike the U.S. Mainland, 1900-2013 The 10 Deadliest Hurricanes to Strike the U.S. Mainland, 1900-2013
Regional Variation in Income and Access to the Sea Regional Variation in Income and Access to the Sea
Exploring Microsoft Office 2010, Volume 1 (2nd Edition) 2nd Edition Exploring Microsoft Office 2010, Volume 1 (2nd Edition) 2nd Edition
Video: Digestive chemicals - types & enzymes

For a complete list of videos, visit our video library