ADMN410 UNHS Management Information System Questions I post the instruction for you to do the assignment. plz record your work and video so that i can watc

ADMN410 UNHS Management Information System Questions I post the instruction for you to do the assignment. plz record your work and video so that i can watch it. INH
Assignment 2 – Management Information Systems ADMN 410-1-1 (1).docx
…
??
??
??
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_Your First.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 15 times?
2. Create a query that shows the customer id, customer name, and order ID for all
customers with the word “Country” in their name. How many records are there in your
result set (Hint: for this one, you need to use the wildcard *)?
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?
4. Create a query that shows the name of the sales person who sold the most number of
computer desks. (Hint: for this one, the challenge is to figure out which tables you need
for the query. Make sure that your tables on the query grid are connected.) Submit his
or her First name and Last name below.
5. Create a query that shows the names of the supervisors of the employees with the skill
“10in Table Saw”
6. Create a query that shows all employees who have more than two skills. How many
different employees are there in the result set?
7. Create a query that shows the territory_id and the territory_name of all territories
where 8-Drawer Desks have been ordered. What are the territory names?
8. Create a query that shows the total quantity of Computer Desks that have been ordered
in each sales territory. What is the quantity of Computer Desks that have been ordered
in North West Region?
9. Create a query that shows the total quantity of desks ordered in each sales territory.
How many desks were ordered in the Central sales territory?
10. Create a query that shows the total dollar value of orders for each sales territory from
1/1/2006 to 12/31/2011. What is the total dollar value of orders for the Central sales
territory during this period?

Purchase answer to see full
attachment