CIS303

Introduction to Databases

Lab Project - Unit E – 16 Project Points

Part I

1. Complete Unit E (pp. Access104-123). This will prepare you for the assignment. You will NOT turn in this part of the assignment. (0 points)

2. Turn to pp. Access 131 in your textbook. Complete Independent Challenge 1 (a. through i.). You do NOT need to print the relationships report. (3 points)

3. Field lengths are not specified, so use these:

Field Name	Length
FirstName	10
LastName	20
Street	30
City	20
State	2
Zip	5
CustNo	3
SchoolNo	2
Description	30
SerialNo	5
SchoolName	20

Be sure you look at all of the tables and set these lengths.

Part II

1. Turn to page Access 134 in your textbook. Complete Independent Challenge 3 and the associated Advanced Challenge Exercise. (13 points)

2. You will create your own data for each of your tables. Each table should have a minimum of 5 records.

When you are finished, zip Music Store-E.mdb and Blood Drive-E.mdb and send them to me. You will also send me either a Word file or an Excel with your database design. Name this file Design.