I’m stuck on a Excel question and need an explanation.
EX16_AC_CH03_GRADER_CAP_HW - Northwind Traders
Project Description:
Northwind Traders, an international gourmet food distributor, hired a new CEO. She asked for your assistance in providing summaries of data that took place before she started with the company. To help her with her strategic planning, you will create queries to perform data analysis. Based on your meeting, you plan on creating four queries. One query will find orders with minor delays. Another query will summarize the cost impact of customer discounts. A third query will be used to help evaluate financing. The final query will calculate the total sales by country.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step
Instructions
Points Possible
1
Start Access. Open the downloaded Access file named exploring_a03_Grader_h1.
0
2
Create a query using Query Design. From the Customers table, include the fields CompanyName, ContactName, ContactTitle, 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.