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

Astigmatism is the most common vision problem. It may accompany nearsightedness or farsightedness. It is usually caused by an irregularly shaped cornea, but sometimes it is the result of an irregularly shaped lens. Either type can be corrected by eyeglasses, contact lenses, or refractive surgery.

Did you know?

The average adult has about 21 square feet of skin.

Did you know?

Vital signs (blood pressure, temperature, pulse rate, respiration rate) should be taken before any drug administration. Patients should be informed not to use tobacco or caffeine at least 30 minutes before their appointment.

Did you know?

Illness; diuretics; laxative abuse; hot weather; exercise; sweating; caffeine; alcoholic beverages; starvation diets; inadequate carbohydrate consumption; and diets high in protein, salt, or fiber can cause people to become dehydrated.

Did you know?

The modern decimal position system was the invention of the Hindus (around 800 AD), involving the placing of numerals to indicate their value (units, tens, hundreds, and so on).

Japanese farmers create pentagon-shaped oranges Japanese farmers create pentagon-shaped oranges
Computed tomography (CT) uses X-rays to create a CT scan of the brain. Computed tomography (CT) uses X-rays to create a CT scan of the brain.
Slap the foot bottom with the back of the hand. Rapid, light slaps create a stimulating sensation. Slap the foot bottom with the back of the hand. Rapid, light slaps create a stimulating sensation.
How to create a frequency table and histogram from raw data How to create a frequency table and histogram from raw data
Hydroelectric power: 2013 Global Market Hydroelectric power: 2013 Global Market
Describe the development of atherosclerosis, including its role in the risk of heart disease Describe the development of atherosclerosis, including its role in the risk of heart disease
Video: Osmosis - water transport

For a complete list of videos, visit our video library