4. qryCustomer Relations - Create query that will list customers, the territories they are in and...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
4. qryCustomer Relations - Create query that will list customers, the territories they are in and the salesperson assigned to the customer's given territory. Concatenate the sales person's first and last names so that they appear in one column along with a meaningful column caption. Only show results where customers are in or near Durham. 5. qrySearchInvoiceByDate - Create a parameter query that will accept two dates and return all invoices that occurred within the range of the dates entered. Include the invoice id, invoice date, order date and customer company in the result. Also include a calculated fields titled "Days to Fulfillment", which will display the number of days between an order being placed and a related invoice being created. 6. qrySearchProduct DescriptionsByKeyword - Create a parameter query that will search through product descriptions and return related records. Display product name, msrp and the description for all results. 4. qryCustomer Relations - Create query that will list customers, the territories they are in and the salesperson assigned to the customer's given territory. Concatenate the sales person's first and last names so that they appear in one column along with a meaningful column caption. Only show results where customers are in or near Durham. 5. qrySearchInvoiceByDate - Create a parameter query that will accept two dates and return all invoices that occurred within the range of the dates entered. Include the invoice id, invoice date, order date and customer company in the result. Also include a calculated fields titled "Days to Fulfillment", which will display the number of days between an order being placed and a related invoice being created. 6. qrySearchProduct DescriptionsByKeyword - Create a parameter query that will search through product descriptions and return related records. Display product name, msrp and the description for all results.
Expert Answer:
Answer rating: 100% (QA)
The following codes work as per the requirements 4 qryCustomerRelations SELECT CustomersCustome... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these accounting questions
-
Display the customer ID, name, and order ID for all customer orders. For those customers who do not have any orders, include them in the display once by showing order ID 0.
-
Show the customer ID and name for all the customers who have ordered both products with IDs 3 and 4 on the same order.
-
Display the customer ID, name, and order ID for all customer orders. For those customers who do not have any orders, include them in the display once. Display the EmployeelD and EmployeeName for...
-
For a certain company, the cost function for producing x items is C(x)=30x+100 and the revenue function for selling x items is R(x)=0.5(x70)^2+2,450 . The maximum capacity of the company is 100...
-
1. Explain how you would execute your roles as project manager of this project. 2. As the project manager, how would you manage trade - offs? 3. How would you recommend this project be organized?...
-
On January 1, 2023, Holland Corporation paid $7 per share to a group of Zeeland Corporation shareholders to acquire 60,000 shares of Zeeland's outstanding voting stock, representing a 60 percent...
-
Estimate the rate (in gal/hr) that your car uses gasoline when it is being driven on an interstate highway. Determine how long it would take to empty a 12-oz soft-drink container at this flowrate....
-
1. What are the key structural issues that Alan Mulally encountered as the incoming President and CEO of Ford Motor Company? 2. How has Alan Mulally addressed the structural issues identified in the...
-
What John Medina writes about stress and its impact on the brain and How might your childhood experiences impact your brain and how it learns? How might sleep, exercise, and stress impact you?
-
Snowden Industries produces two electronic decoders, P and Q. Decoder P is more sophisticated and requires more programming and testing than does Decoder Q. Because of these product differences, the...
-
Interpret the results below in both a time-series and cross-sectional manner (by separating the operating drivers of ROE from the financial drivers of ROE). RATIO ANALYSIS LOCKHEED 2021 Profitability...
-
In the face of your supervisor's directive to eliminate certain sections of findings from the report, how would you apply the Ethical Decision-Making Model to align your response with the NASW Code...
-
Write to Oriental Bank of Commerce, Civil Lines, Bhopal, to make enquiries about the credit standing of Messrs. Rajpal Brothers, Raja Bazar, Bhopal, for a sum of Rs.5,00,000. The party's bankers are...
-
d) The following diagram shows a TTT-diagram of pure iron. Draw a realistic cooling curve after full austenitization in this diagram in order to produce the highest possible content of martensite....
-
Tricia Rose claims that hip hop is characterized by rupture, flow, and layering. Explain her argument in your own words. Provide an example of each aspect (rupture, flow, and layering) using any one...
-
Assume that the government is unable to change the amount of public debt that the private sector holds. Consider both fixed and flexible exchange rate regimes. Explain how would the nominal and real...
-
The statement of financial position for Tight and its subsidiary Loose, as at 31 December 2022 is stated below: Assets Non-current Assets: Property plant and Equipment Investment in Loose Current...
-
C- Consider the following scenario:- A supermarket needs to develop the following software to encourage regular customers. For this, the customer needs to supply his/her residence address, telephone...
-
Clifford Johnson has a limited partnership investment and a rental condominium. Clifford actively manages the rental condominium. During 2012, his share of the loss from the limited partnership was...
-
In 2012, Gale and Cathy Alexander hosted an exchange student, Axel Muller, for 9 months. Axel was part of International Student Exchange Programs (a qualified organization). Axel attended tenth grade...
-
Larry Gaines, age 42, sells his personal residence on November 12, 2012, for $144,000. He lived in the house for 7 years. The expenses of the sale are $10,500, and he has made capital improvements of...
-
One of the main fears that retail startups have is if they will be able to compete against Walmart, Home Depot, and the other big-box stores. This is a legitimate fear. Big-box stores continue to...
-
Influencer marketing is a type of marketing where companies partner with influencers, who have a significant following on social media platforms, to promote their products or services. Influencers...
-
In the summer of 2015, Stephen Kuhl and Kabeer Chopra made their way to Philadelphia to prepare for business school. It was their first semester in the Wharton MBA program. They were both in an...
Study smarter with the SolutionInn App