Question: 1 0 Use Power Pivot to import the Transactions table from the Access database e 1 0 c 1 PledgeDollars.accdb into a PivotTable. Place the

10 Use Power Pivot to import the Transactions table from the Access database e10c1PledgeDollars.accdb into a PivotTable. Place the PivotTable on a new worksheet named Pledge Dollars. Add the Date field to the Filters area, add Operator_ID to the Rows area, and add Pledge_Amount to the Values area. Save the workbook.
11 Create a relationship between the Operator_ID in the Transactions table and the Operator_ID in the Volunteer Information worksheet.

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!