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

Acute bronchitis is an inflammation of the breathing tubes (bronchi), which causes increased mucus production and other changes. It is usually caused by bacteria or viruses, can be serious in people who have pulmonary or cardiac diseases, and can lead to pneumonia.

Did you know?

In 2010, opiate painkllers, such as morphine, OxyContin®, and Vicodin®, were tied to almost 60% of drug overdose deaths.

Did you know?

Though “Krazy Glue” or “Super Glue” has the ability to seal small wounds, it is not recommended for this purpose since it contains many substances that should not enter the body through the skin, and may be harmful.

Did you know?

The Food and Drug Administration has approved Risperdal, an adult antipsychotic drug, for the symptomatic treatment of irritability in children and adolescents with autism. The approval is the first for the use of a drug to treat behaviors associated with autism in children. These behaviors are included under the general heading of irritability and include aggression, deliberate self-injury, and temper tantrums.

Did you know?

Serum cholesterol testing in adults is recommended every 1 to 5 years. People with diabetes and a family history of high cholesterol should be tested even more frequently.

Young adults with low levels of parental support report significantly better scores on measures of ... Young adults with low levels of parental support report significantly better scores on measures of ...
After the death of a loved one, family members report concerns about last place of care. After the death of a loved one, family members report concerns about last place of care.
Two stubby screwdrivers used to access screws that have limited space above. A straight blade is on ... Two stubby screwdrivers used to access screws that have limited space above. A straight blade is on ...
Circular friction to the broad iliotibial band. The heel of the hand is used to create friction ... Circular friction to the broad iliotibial band. The heel of the hand is used to create friction ...
Circling the forearm to create movement at the elbow. Circling the forearm to create movement at the elbow.
Jump Right In: Essential Computer Skills Using Microsoft Office 2013 (2nd Edition) Jump Right In: Essential Computer Skills Using Microsoft Office 2013 (2nd Edition)
Video: Hormonal regulation of blood pressure - RAA system

For a complete list of videos, visit our video library