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