Course Lab

R. Craig Collins > BCIS 1301/COSC 1301/ITSC 1309 > Lab 6

Lab 6 © R. Craig Collins, 2005/6

General Lab Directions
Note: There is not enough time in lecture to cover all the material; read your book BEFORE you begin the lab
Note: Typically labs will require you to invest some time in the lab, outside of class lecture hours

•Check with your Instructor for due dates

Create and submit an Address Book/Gift register
Be sure to include the following:

A table called Address created in Design mode (5%)
First_Name field, set as Key field (5%)
Last_Name (5%)
Address (5%)
City (5%)
State, two character max (5%)
Zip, text field with mask (5%)
Phone Number, text field with mask (5%)
Create an input form called Address w/Wizard (5%)
Add at least 5 record, no duplicate names (5%)

Create second table called gifts (5%)
First_Name field, set as Key field (5%)
include Gift, Adjective, Room, Cost, and Store fields (5%)
Create a input form w/ Wizard called Gifts and add at least one gift per addressee (5%)
Relate your two tables on First Name (5%)
Create Query to merge all records where gift was more than $10 (5%)
Save Query as Nice-Gifts (5%)
Create a report based on the Nice_Gifts query (5%)
Print Out and turn in all sheets, including relationship 1 pg ea (5%).
Appropriately submit Lab 6 (see below... MUST be zipped) (5%)

An easy way to print items that have no print support in Access is to press the [Print Screen ] key on your keyboard, the Edit\Paste the screen shot into a Word Document.

For more details, see the Sample Access lab.

Print the document if requested, and electronically submit the file; see How To: Labs