Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.

QUESTION

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.
Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question