DIS 390

Database Management

---

Access assignment 1

(Due: April 7, 2004)

1. Create a folder on your computer/diskette (if you are in the lab, create this folder in the D: drive) called ####CASE1 where #### is the last four digits of your student number.

2. Create another folder on your computer/diskette (if you are in the lab, create this folder in the D: drive) called xxxx where xxxx is your full name.

3. Download data files from the Web:

(a) Start your browser and enter the URL http://www.course.com/catalog/downloads.cfm?isbn=0-619-02089-X

(b) Click on the link "2089-Xd.exe"

(c) When the Save As dialog box opens, save the file 2089-Xd.exe onto the folder bearing your full name (i.e., folder xxxx) and click "save"

(d) Double click the file 2089-Xd.exe and unzip the files onto the folder xxxx.

If your last name starts with A-K, then do these:

4. Copy the files Clients.mdb and TVandVCR.gif from xxxx\Tutorial.05\Cases onto the folder bearing your student number (i.e., folder ####CASE1).

5. Open the file Clients.mdb from your ####CASE1 folder and rename all the tables with your name attached to it (e.g., Anita's Shoot).

6. Complete tasks 2-10 of Case 1 on page AC5.61 of your Access text.  Skip printing the results of your query.

7. Turn in a printed copy of task 9i (Note: this is the only printout you need to turn in).

8. Submit a zip version of your ####CASE1 folder electronically via the digital drop box.

If your last name starts with L-Z, then do these:

4. Copy the files Delivery.mdb and PlaceSet.gif from xxxx\Tutorial.05\Cases onto the folder bearing your student number (i.e., folder ####CASE1).

5. Open the file Delivery.mdb from your ####CASE1 folder and rename all the tables with your name attached to it (e.g., Anita's Order).

6. Complete tasks 2-8, 12 and 14 of Case 2 on page AC5.63 of your Access text.  Skip printing the results of your query.

7. Turn in a printed copy of task 12g (Note: this is the only printout you need to turn in).

8. Submit a zip version of your ####CASE1 folder electronically via the digital drop box.

NOTE:

– It is considered late if I do not receive your work by 4:30pm on the day it is due,

– Late penalty is 10% per day,

– It is each student’s responsibility to ensure a functional and clearly labeled copy has been submitted before the beginning of class on the due day,

– It is an individual work (i.e., no copying from others or group work).