Access excercise

Access excercise - bike, the date, the time when the bike...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
"Slope Side Bike Rental" Case (part 1) Slope Side Bike Rental is a small bike rental shop located in La Jolla, California. The shop rents bikes on an hourly basis. When customers rent a bike they have to supply their drivers license as a form of identification. The information on the drivers license is entered on to a rental card and consists of license number, first name, last name, street address, city, and zip code, telephone number, and credit card number. In addition, the card contains an area that is used to record rental information consisting of the ID of the rented
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: bike, the date, the time when the bike was checked out, the time when it was returned, and a check box that indicates whether the bike was returned in a damaged condition. Another set of cards is used to record information on the bikes and consists of bike ID, Description, and cost per hour. Slope Side Bikes would like to replace the cards with an Access database that would record all the customer, bike, and rental information and allow the production of reports as well. Task Create a simple 3 table database solution for the above problem....
View Full Document

This document was uploaded on 11/03/2011 for the course BUS 391 at Cal Poly.

Ask a homework question - tutors are online