subject

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. Required:
For the purpose of grading the project you are required to perform the following tasks:

1. Start Access. Open the downloaded Access file named exploring_a03_Grader_h1.
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.
3. 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.
4. Add criteria to limit the query results to include any order that took more than 30 days to ship.

ansver
Answers: 2

Other questions on the subject: Computers and Technology

image
Computers and Technology, 22.06.2019 03:40, plzhelpmeasap46
Hello my name is mihai and i need your : )i have to do a python project in computer science and i’m really busy with my mocks this period of time besides this i’m not good at coding so could someone pls pls pls sort me out ? i actually beg ; ))
Answers: 1
image
Computers and Technology, 22.06.2019 19:30, bstine6678
When creating a presentation in libre office impress, where does the editing of slides take place? a. the slides panel b. the center panel c. the tasks panel, under the masters pages tab d. the tasks panel, under the layouts tab
Answers: 1
image
Computers and Technology, 22.06.2019 19:30, Jbutler15
When creating a presentation in libre office impress, where does the editing of slides take place?
Answers: 1
image
Computers and Technology, 23.06.2019 14:30, soapai
Select the correct answer. sean is a computer programmer. he has programmed an application for toddlers that plays nursery rhymes. however, a logic error has occurred in the program. which problem is a likely consequence of the error? a. the program crashes every time the user wants to play the nursery rhymes. b. the program crosses its buffer boundaries and overwrites an adjacent program. c. the program plays a different nursery rhyme than the one the user intended to play. d. the program shows different structures in its programming language code. e. the program introduces new viruses every time the user plays a nursery rhyme.
Answers: 1
You know the right answer?
Northwind Traders, an international gourmet food distributor, hired a new CEO. She asked for your as...

Questions in other subjects:

Konu
Mathematics, 21.04.2021 01:50
Konu
Biology, 21.04.2021 01:50