1. Create an Access database to keep track of sales from a business. The database should have 3 tables: one for customers, one for products, and one for sales, with the fields shown below (you can use any field names you like): (2 points)
customers
id
first
last
products
id
description
price (make this numeric)
sales
sales id
customer id
product id
2. Put data into the table so that you have at least 2 customers, 2 products, and 3 sales. (2 points)
3. Establish a relationship among the tables (1 point)
4. Create a query that displays all customers, sorted by last name and then sorted by first name. (2 points) Do not display the id. (1 point)
5. Create a query that display the first and last name of all customers who purchased a product costing more than $10 or that was bought by a customer with the first name of Bill. (2 points)
Email the Access database to pegramite115@gmail.com
Revised: July 20, 2009