To Temple College R. Craig Collins > COSC 1301 > Lab 6
R. Craig Collins > BCIS 1301 > Lab 6
R. Craig Collins > 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 the Instructor for the due date

Create and submit an Address Book
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%)

For more details, see the Sample Access lab.
Print the document, and electronically submit the file; see How To: Labs