Question: On the Data tab, click Get Data and then from your downloaded files, import the Microsoft Access Database 4 F _ Sports _ Equipment. accab.

On the Data tab, click Get Data and then from your downloaded files, import the Microsoft Access Database 4F_Sports_Equipment. accab. Load both of the tables in the database. (Mac users, on the Data tab, click From Ttext.From your downloaded files, click Excel_4F._Sports_Equipment_csv.csv, and then click GetData. Use Comma delimiters and General column data format. Put the data in the Existing sheet in A1.)103Insert a PivotTable using the From Data Model option. Verify that Existing Worksheet and Sheet1|SA$1 display, and then click OK.(Mac users, insert a PivotTable in a New worksheet.Select and delete rows 1 and 2, which are blank. Rename the original worksheet as Data) Rename the PivotTable sheet as Sports Equipment

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!