Management Information Systems ADMN 410-1

User Generated

zvxb0303

Computer Science

Description

you need to read the instruction and finish the assess question step by step . i need people know how to use ACCESS well, i need 100% correct answer ,thanks for helping.

Unformatted Attachment Preview

Management Information Systems ADMN 410 MICROSOFT ACCESS ASSIGNMENT 2 Instructions 1. Download the Access Database named Assignment 2 Data from myCourses. 2. Answer all the questions below. Be sure to save each query. Each query should be named e.g. for question 1 name the query Question 1, for question 2 name the query Question 2 for question 3 name the query that you create Question 3 etc. 3. Once you are done answering each of the questions, save the database as follows: YourLastname_YourFirst.aacdb 4. Go to the Assignment 2 Submission page on myCourses, answer all the questions that appear on the submission quiz. Please note that you will also be prompted to submit your Access Database. ASSIGNMENT QUESTIONS 1. Create a query that shows a list of all the products (i.e. product id and product description) and the number of times that each product has been ordered. How many products have been order less than 10 times? 2. Create a query that shows the customer id, customer name, and order ID for all customers with the words furniture in their name. How many records are there in your result set (Hint: for this one, you need to use the wildcard *)? Only enter the numeric value below. e.g. 12 3. Create a query that shows the order number and order quantity for all customer orders for which the order quantity is greater than the average order quantity of that product. How many such orders are there? Only enter the numeric value below. e.g. 12 4. Create a query that the name of the sales person who sold the most number of computer desks between 1 January 2004 and 31 December 2005 (Hint: for this one, the difficulty is to figure out which tables you need for the query. Make sure that your tables on the query grid are connected)? 5. Who supervises employees with the skill “12 in BandSaw”? (Hint: for this one, you need to find out the supervisor ID first, then figure out the supervisor’s name.) 6. Create a query that shows the name of the customer who placed the most number of orders in 2006. How many different orders did that customer place in 2006? 7. Create a query that shows the Customer Name, Address and State of all customers who did not place any orders. How many customers did not place any orders? 8. Create a query that shows the Customer Name, Address and State of all customers who did not place any orders. How many customers did not place any orders? 9. Create a query that show the product description product finish and product standard price for all the products that have a standard price between $200 and $300. How many products have a standard price between $200 and $500? 10. Create a query that shows the total dollar value of orders for each sales territory from 10/21/2004 to 10/29/2011. What is the total dollar value of orders for the North East sales territory during this period? (Hint: for this one, you need to create a query (part 1) to figure out the total dollar value (order qty*standard Price) for each order first. Then you need to query a second query based on part 1 query to figure out what is the total for each territory.) 11. Create a query that shows the name and the addresses of the customer that placed order number 1008. What is the name of that customer? Assignment 2 need to finsh !!.accdb
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

The solution is attached but first you have to complete t...


Anonymous
Great content here. Definitely a returning customer.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags