Access Exercise

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