Assignment 3: Access Database

1. Create two tables in MS Access related to sales of items to customers. The first table should have customer information like name and address, with Customer ID as the key. The second table should include Customer ID, ITEM Number, Date, Quantity, and Sale Amount. Create between 5 and 10 records for each table.

2. Create a query that joins the two tables (inner join) and includes all the fields from each table. Note that Customer ID only needs inclusion once.

3. Create a simple report from the Query.

4. Create a simple form for data entry into the Sales Table.

Save the database file and upload it to iCollege.