To Temple College Class  logo R. Craig Collins > BCIS 1301/COSC 1301/ITSC 1309 > Lab 6

Lab 6 © R. Craig Collins, 2005/9

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-form w/Wizard (5%)
  • Add at least 5 record, no duplicate names (5%)
  • Create second table calledGifts (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-form and add at least one gift per addressee (5%)
  • Relate your two tables on First Name (5%)
  • Create a query based on both tables, one of each field, named join-query
  • Modify join-query to merge all records where gift was more than $10 (5%)
  • Save Query as Nice-Gifts-query (5%)
  • Create a report based on the join-query called join-report (5%).
  • Create a report based on the Nice_Gifts-query called Nice_Gifts-report (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.


Problems? Zip the entire folder and attach to an email:
       •Send the mail to your instructor, cc yourself
       •The subject line should include your name, your class, your section, and what you are submitting
       •Make sure you attach the zipped file

SUBMITTING THE LAB

Log into Desire2Learn, choose this class, choose Dropbox, and select correct Lab.
Browse to yourname-labx.zip and upload it. (Scroll down to see detailed instructions)

      • Using D2L dropbox       • Using D2L Quizzes      • Logon to D2L
To submit by Temple College Desire2Learn:
       •Log into D2L, scroll to the bottom, and choose the correct course
       •When the Course Home Page appears, click on the Dropbox link.
              •You may click on Discussions, Dropbox, or Quizzes below, for more info

       D2L navigation D2L Dropbox notes D2L Quizzes Notes D2L Discussion Notes
Dropbox directions