Go to the Stores worksheet. Jacob wants to display information about lighting products purchased according to store and manufacturer. He 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_EX365_2021_CT10c_LD.accdb database.
b. Select the 2024_Orders, Products, and Purchases tables for the import.
c. Only create a connection to the data, and then add the data to the Data Model. On the Stores worksheet, Jacob wants to show the categories of products sold in each of the company's five stores during 2024.
d. In cell A2 of the Stores worksheet, use Power Pivot to insert a PivotTable based on the data in the 2024_Orders table.
