Question
Use Access to Create a Database using the Teton Whitewater Kayak Case study under this link. 1. Create the following tables: Customer Equipment Inventory
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)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started