Computer Science 4400 Machine Q 2

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.
 

 

 
Powered by