DIS 622

Business Data Systems Analysis and Design

Access assignment 2

(Due: April 27, 2005 at 3pm)


1.      Create a folder on your computer/diskette (if you are in the lab, create this in the My Documents folder) called ####case2 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 in the My Documents folder) 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-20672-1

(b)   Click on the link "Data Files (Access 2003 Comprehensive) (1.66MB)under Data Files for Students (Windows)

(c)    When the File Download dialog box opens, save the file 20672-1d.exe onto the folder bearing your full name (i.e., folder xxxx) and click "save"

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

 

 

4.      Copy all the files from xxxx\AddCase1 folder onto the folder bearing your student number (i.e., folder ####case2).

5.      Open the file NestEgg.mdb from your ####case2 folder and rename all the tables with your name attached to it (e.g., Anita’s Member).

6.      Complete tasks 3-16 of Additional Case 1 on page ADD1 of your Access text.  Skip printing the results of your query, form, and report.

7.      Create a zip version of your ###case2 folder and submit your ####case2.zip through blackboard.

 

Note: For task 15, you can treat the switchboard as a form and create it without using the switchboard manager.