EX$19\_$AC$\_$CH$03\_$GRADER$\_$CAP$\_$HW$\_$Instructions $-$ Protected View $+$ Soned to this RC

References

Mailings

Review

View

Help

viruses. Unless you need to edit it's safer to stay in Protected Vicw,

Enable Editing

Perform:

Instructions

Start Access. Open the downloaded Access file named

Exp$19\_$Access$\_$Cho$3\_$Car$\_$Briton$\_$Madley$\_$Games.accob. Grader has automatically added your last name to the beginning of the filename.

Create a query using Query Design. From the Customers table, include the fields FirstName, LastName, and Phone $($in that order$).$ From the Orders table, include the fields OrderID, OrderDate, and ShippedDate $($in that order$).$ Run the query and then examine the records. Save the query as Shipping Efficiency.

Add a calculated field named DaysToShip to calculate the number of days taken to fill each order. $($Hint: the expression will include the OrderDate and ShippedDate fields; the results will not contain negative numbers.$)$ Run the query and then examine the results. Save the query.

Add criteria to limit the query results to indude any order that took more than $30$ days to ship.

Add the Quantity field from the Orders table and the ProductName field from the Products table to the query $($in that order$).$ Sort the query by ascending LastName.

Add the caption Days to Ship to the DaysToShip field. Switch to Datasheet view to view the final results. Save and close the query.

Create a query using Query Design and add the Customers, Orders, and Products tables. Add the Country field from the Customers table. Set the field's Total row to Group By$.$ Save the query as Revenue and Cost by Country.

Add a calculated field in the second column. Name the field TotalRevenue. This field should multiply the quantity ordered $($from the Orders table$)$ by the unit price for that item $($from the Products table$).$ Format the calculated field as Currency and change the caption to Total Revenue. Change the Total row for the TotalRevenue field to Sum.

Add a calculated field in the third column. Name the field TotalCost. The field should multiply the quantity ordered $($from the Orders table$)$ by the unit cost for that item $($from the Products table$).$ Format the calculated field as Currency and add a caption of Total Cost. Change the Total row to Sum. Run the query. Save the query. Return to Desian view.