CIS 100 -- Access Assignment 1

Overview

In this lab, you will use MS Access 97 to create a database. This database will be a typical address book that will contain your friends, family, and business contact information. Also included in this database will be gifts that you have given over the years. You must create two tables for this assignment, called People and Gifts. People will have one entry per person with basic information, and Gifts will have an entry for each single gift you have given.

Field Name Field Type

Entry Number Autonumber

First Name Text

Last Name Text

State Text

Zip Text

DOB Date

Field Name Field Type

Entry Number Long Integer

Gift Text

When Given Date

Why Given Text

Cost Currency

The first table and the second table share some information. The key field(s) is responsible for making the link between the two tables. The chosen field(s) must uniquely identify a record in the People. The ``Why Given'' field should only contain bday, xmas, or other. You should build your database so that the user cannot make an error entering the ``Why Given.''

To Do

• Define fields, field lengths, etc. for the People table.
• Create a primary key for the People table.
• Set the field properties so that the State is always capitalized
• Define fields, field lengths, etc. for the Gifts table
• Link the two tables (set referential integrity, one-to-many, and cascading deletes). Referential integrity ensures that entries in the Gifts table must have an entry number corresponding to an entry in the People table. One-to-many allows you to have more than one entry in the second table with the same entry number. Cascading deletes instructs Access to delete all entries in the second table that correspond to an entry that was deleted in the first table. This helps keep the database consistent.
• Put your name and info in the first record of the database
• Add real or fake data to the rest of the database (minimum 10 entries)
• Each person in the database should have at least one gift, and more than 5 people should have two or more gifts. That means you'll have at least 15 entries in the Gifts table.
• You must use addresses that are in at least three different states. Some of your addresses must be in GA (at lest 3) and some in FL (at lest 3); that will make the next assignment easier. The data may be real or fake.
• Some, but not all, of the people must be between 15 and 30 years old (at lest 3).

Turn In

Check with the Instructor as to how this assignment is to be turned in.

Make sure you have a back-up of this assignment as you will need it on the next assignment.

Time

This whole assignment should take you less than an hour to set up the tables. If it is taking you longer than that, find someone to ask for help. Adding the data to the tables is not part of the setting up of the tables.