SlopesideBikes

SlopesideBikes - BMGT301: INTRODUCTION TO INFORMATION...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
BMGT301: INTRODUCTION TO INFORMATION SYSTEMS DATABASES: IN-CLASS ASSIGNMENT PROBLEM SET: SLOPESIDE BIKES TABLES CUSTOMER: Driver’s License ; LastName; FirstName; Address; City; State; Zip; Telephone; CreditCardNo. BIKE: BikeID ; Description; Cost Per Hour RENTAL: Driver’s License ; Date ; BikeID ; TimeOut; TimeIn; Damage? THINGS TO DO… Check Primary Keys Create Appropriate Relationships Enforce Referential Integrity. Check Data Formats. Check Default Values Add Input Mask as required. I. FORMS: CREATE FORMS TO ADD/UPDATE/DELETE DATA USE THE AUTO-FORMS WIZARD. (NOTE: YOU CAN CREATE FORMS THAT HAS FIELDS FROM MULTIPLE TABLES. DISPLAY THE SUBFORMS AS WELL.) TO MODIFY THE LOOK OF THE FORM: OPEN THE FORM IN DESIGN VIEW. SELECT PROPERTIES AND CHANGE THE PROPERTIES OF THE OBJECT SELECTED. GIVE YOUR FORM A PROFESSIONAL VIEW. SELECT THE LABEL CONTROLS AND ALIGN THE LABELS. II. QUERIES: SIMPLE QUERIES:
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 01/23/2011 for the course BMGT 301 taught by Professor Wang during the Spring '08 term at Maryland.

Page1 / 2

SlopesideBikes - BMGT301: INTRODUCTION TO INFORMATION...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online