Reference no: EM131420231
Northwinds database in MS Access
Using the Northwinds database in MS Access, write the following queries and provide the results. (10 points each)
1. Write a query that returns the number of customers in the customers table.
2. Write a query that returns the number of customers in each job title.
3. Write a query that returns the job titles having greater than 5 customers.
4. Write a query that returns customer name, company, job title, phone, city and state for customers in Minnesota.
5. Write a query that returns the Orders for Customer "Company AA".
6. Write a query that returns the order numbers for customer "Company AA" and the date of the orders.
7. Write a query that returns the products ordered by "Company AA" for orders that are "Closed".
8. Write a query to return the quantity and sales total for each item on the "Company AA" open orders.
9. Write a query to return the total sales amount for each of "Company AA" open orders.
10. Write a query that returns who created and approved the purchase order for "Company AA" "Closed" orders along with the internal notes on the purchase order.
|
Which projects should firm implement based on your analysis
: Use the IRR approach to select the best group of projects. Which projects should the firm implement based on your analysis of both techniques and given the capital rationing amount?
|
|
Do you agree or disagree with the above statement
: Do you agree or disagree with the above statement? Be sure to discuss the period after Reconstruction and support your answer with precise and relevant examples from all of the class readings by Foner, Buder, Plunkitt, Etulain, and the class lect..
|
|
Determine the time required to turn the taper
: A tapered surface is to be turned on an automatic lathe. The workpiece is 750 mm long with minimum and maximum diameters of 100 mm and 200 mm at opposite ends.
|
|
Competitive forces model and the value chain model
: What is the relationship between the competitive forces model and the value chain model. Analyze how government agencies develop and implement rules to implement the provisions of laws. Discuss why nonverbal communication is so important. How can you..
|
|
Write a query that returns the number of customers
: Write a query that returns the number of customers in the customers table. Write a query that returns the number of customers in each job title. Write a query that returns the job titles having greater than 5 customers
|
|
Purpose of lincoln emancipation proclamation
: What was the purpose of Lincoln's Emancipation Proclamation? In what ways was the proclamation both important and successful?
|
|
Slaveholders pursued in the postwar south
: Identify the visions of freedom the former slaves and slaveholders pursued in the postwar South.
|
|
The great planes radio-controlled plane company
: The Great Planes radio-controlled plane company is slowly gaining in its sales. Last year the company increased its presence and share in the R/C airplane model market by 10%. Great Planes set a sales objective for the next year to increase its marke..
|
|
Establish a whs management system
: ICT50115 Diploma of Information Technology Identify duty holders and define WHS responsibilities for all workplace personnel in the work area according to WHS legislation, policies, procedures and programs and Identify and approve financial and h..
|