Course Lab

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

Dropbox directions

1. Choose the class for which you want to drop off an assignment.
2. Find the Dropbox tool, click on it.
3. Choose the appropriate Dropbox folder, click on it.
4. Choose [Add a File], then choose [Browse]; you may need to choose (My) Computer first
5. Find the file that you would like to upload and click open, then choose [Upload]
6. Type in a short description or comment about the file, if you like.
7. Select [Add] for any additional files that may be pertinent, and repeat
8. After your files have been selected, click [Submit]. (To upload and submit you will always click at least twice)
9. Some files may take a long time to upload (especially if there are graphics in the file).
Did my file get through?
1. Go to the Dropbox tool
2. Click the number under Submissions
3. All of the assignments that have been submitted will be listed.