Use Access to Create a Database using the Teton Whitewater Kayak Case study under this link.

1. Create the following tables:

Customer Equipment \ Inventory Sales person \ Staff Sales \ Rentals

**Fill each table with at least 6 records, using the information provided in the rental cost table. You can makeup the rest of the data (eg Salesperson or individuals renting or purchasing equipment) Have 3 sales, 3 rentals.

2. Create the following queries:

What inventory is currently in stock? Which equipment is rented out and by what customer and who was the sales rep? What were the total number of late rentals for the quarter?

3. Export those 3 queries to 3 reports, exported to a PDF document

4. Submit your final Access file and your 3 PDF files. (4 files should be attached in total)