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.