need the answers for this project with all the steps.

 

Ofce 2013 – myitlab:grader – InstructionsExploring - Access Chapter 3: Homework Project 1Northwind TradersProject Description:Northwind Traders, an international gourmet food distributor, is concerned about shipping delaysover the last six months. Review the orders over the past six months and identify any order thatwas not shipped within 30 days. Each customer that falls within that time frame will be called toinquire about any problems the delay may have caused. In addition, you will create an ordersummary and an order summary by country. You have created a smaller version of the database,which you will use for testing purposes.Instructions:For the purpose o± grading the project you are required to per±orm the ±ollowing tasks:StepInstructionsPointsPossible1Start Access. Open the downloaded Access ²le namedexploring_a03_Grader_h1.02Create a query using Query Design. From the Customers table, include the ²eldsCompanyName, ContactName, ContactTitle, and Phone (in that order). From theOrders table, include the ²elds OrderID, OrderDate, and ShippedDate (in thatorder). Run the query and then examine the records. Save the query asShippingEfciency.53Add a calculated ²eld named DaysToShip to calculate the number o± days taken to²ll each order. (Hint: subtract OrderDate ±rom the ShippedDate; the results will notcontain negative numbers.) Run the query and then examine the results. Save thequery.104Add criteria to limit the query results to include any order that took more than25days to ship.55Add the Quantity ²eld ±rom the Order Details table and the ProductName ²eld ±romthe Products table to the query (in that order). Sort the query by ascendingCompanyName.56Switch to Datasheet view to view the ²nal results. In Design view, add the captionDays to Shipto the DaysToShip ²eld. Save and close the query.57Create a query using Query Design and add the Customers, Orders, Order Details,and Products tables. Add the ²elds OrderID and OrderDate (in that order) ±rom theOrders table. Set both ²elds' Total rows to Group By.58Add a calculated ²eld in the third column. Name the ²eldExtendedAmount. This²eld should multiply the number o± items ordered by the price per item. This willcalculate the total amount ±or each order. Format the calculated ²eld as Currencyand change the caption toTotal Dollars. Change the Total row to Sum.109Add a calculated ²eld in the ±ourth column. Name the ²eldDiscountAmount. The²eld should multiply the number o± items ordered, the price per item, and thediscount ²eld. This will calculate the total discount ±or each order. Format thecalculated ²eld as Currency, and add a caption o±Discount Amt. Change the Totalrow to Sum. Run the query. Save the query asOrder Summary. Return to Design10Updated: 

 

Attachments:

• 1494492453-A_CH03_EXPV1_H1_Instructions.docx