Computer Science 4400 Machine Q 2
Download the Access database named northwind in the course content. You will have to unzip after the file after saving it in a location that you can remember on your computer. Note that this database is in Access 2007 format. Insert your name as the last customer in the customers table. Then create the following queries in this database. You must use the names given for the queries. Place the database file that includes your queries in the Digital Drop Box on the date specified in the course calendar. This assignment does not require the use of SQL.
Query Name
|
Instructions
|
Query1
|
The employee number and first and last names for all employees from Seattle.
|
Query2
|
The product name, supplier name, and units in stock for all products with a list price of at least $25.00.
|
Query3
|
The names of all customers who ordered a product in the Canned Meat or Soups categories.
|
Query4
|
The name, unit price, and quantity ordered for all products purchased by a customer whose ID is entered from the keyboard.
|
Query5
|
The customer name, order number, and order date for all orders that were shipped to Salt Lake City or Portland.
|
Query6
|
The customer number, order number, and order date for all orders shipped on a date that is entered from the keyboard.
|
