GRINKLE "ONLY"

BUMIS 333

Database Homework Handout

Use the Northwinds database to create the following queries in Microsoft Excel.

1. Create a query to import the Last Name, First Name, Title, and Hire Date of all Employees.

2. Create a query to import the Company Name of all Suppliers located in the USA.

3. Create a query to import the Product Name, Supplier Name, and Unit Price of all Seafood Products.

4. Create a query to import the Company Name, Contact Name, and Phone Number for all Customer located in Germany.

5. Create a query to import the Order ID, Customer, Order Date, Products Ordered, Unit Price, and Quantity for all Orders occurring on or before 1/1/1998.