Question: (Based on the Northwind database) Create an appropriate query and return it as a pivot table. This pivot table should allow you to see the

(Based on the Northwind database) Create an appropriate query and return it as a pivot table. This pivot table should allow you to see the number of orders shipped by each shipper during each month.

For example, you should find that the shipped date was July 1997 for 13 orders shipped by Speedy Express. (Note: Microsoft Query recognizes primary key-foreign key relationships if the primary key and foreign key have the same name. However, it doesn't recognize the relationship in this case because the primary key is ShipperID and the foreign key is ShipVia. Therefore, you must drag a link between these two in the top pane of the Microsoft Query screen.)

Step by Step Solution

3.37 Rating (169 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Count of CompanyName Column Labels Row Labels Federal Shipping Speed... View full answer

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

Document Format (3 attachments)

PDF file Icon

1209_60bca5b764ca5_564978.pdf

180 KBs PDF File

Excel file Icon

1209-M-S-D-A(9008).xlsx

300 KBs Excel File

Word file Icon

1209_60bca5b764ca5_564978.docx

120 KBs Word File

Students Have Also Explored These Related Statistics Questions!