Basic Select Queries (IN MICROSOFT ACCESS)

Use the attached Access database Download attached Access database for this assignment. Submit the completed Access database. Create and Number each query in Access to match the question number.

1. List all suppliers that are not in the USA.

2. List all products that are out of stock.

3. List all customers in North America.

4. List products that are discontinued. Sort the products alphabetically.

5. List all orders in April of 2018. Sort the orders by the shipped date.

6. List all products with a unit price of $75 or more. Display the most expensive products first.

7. List all terminated employees.

8. List all orders where the shipped date is after the required date.

9. List all active employees with a job title that contains the word "Sales".

10. List all customers in Spain or France with a name that starts with B.

a