Module 10 Project 1b question number 3
- Go to the Material worksheet. Lucia wants to display information about products sold according to location and material. She has been tracking this data in an Access database. Import the data from the Access database as follows:
- a. Create a new query that imports data from the Support_EX19_10b_Restore.accdb database.
- b. Select the 2021_Orders, Products, and Sales tables for the import.
- c. Only create a connection to the data and add the data to the Data Model.
On the Material worksheet, Lucia wants to show the material of the products sold in each of the company's five locations during 2021.
- d. In cell B2 of the Material worksheet, use Power Pivot to insert a PivotTable based on the data in the 2021_Orders table.
mentalmavens asked a year ago
