Access
Assignment 2
Due:
1.
Create a folder
on your computer/diskette (if you are in the lab, create this folder in the D:
drive) called ####HW2 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
Finstat.mdb, Finmoney.bmp, and Finlogo.bmp from xxxx\AddCases onto the folder
bearing your student number (i.e., folder ####HW2).
5.
Open the file
Finstat.mdb from your ####HW2 folder and rename all the tables with your name
attached to it (e.g., Anita's Company).
6.
Modify the first
record in the Company table by changing the CompanyName field value to your
name in the format: first name, space, last name. Close the table.
7.
Complete tasks
3-14, and 16-17 of Additional Case 1 on page ADD1-8 of your Access text. Skip printing the results of your query,
forms, and reports. (Note: you can
create the switchboard without using the Switchboard Manager)
8.
Open the Industry
Summary for 2004 report in design view.
Add a label box in the report footer section and enter your name in
it. Format your name with 12-point Arial
bold font. Turn in a printed copy of
this report. (Note: this is the only printout you need to turn in)
9.
Submit a zip
version of your ####HW2 folder electronically via the digital drop box.
If your last name starts with L-Z, then do these:
4.
Copy the files
Pet.mdb, Petlogo.bmp, Petfish.bmp, and Petdog.bmp from xxxx\AddCases onto the
folder bearing your student number (i.e., folder ####HW2).
5.
Open the file
Pet.mdb from your ####HW2 folder and rename all the tables with your name
attached to it (e.g., Anita's Order).
6.
Modify the 5th record
(i.e., CustomerNum is 128) in the Customer table by changing the CustomerName
field value to your name in the format: first name, space, last name. Close the table
7.
Complete tasks
3-11 Case 2 on page ADD9-13 of your Access text. Skip printing the results of your query,
forms, and reports. (Note: you can
create the switchboard without using the Switchboard Manager)
8.
Turn in a printed
copy of page 5 (i.e., CustomerNum is 128) of the Customer Statement report
(Note: this is the only printout you need to turn in)
9.
Submit a zip
version of your ####HW2 folder electronically via the digital drop box.
NOTE:
– It is considered late if I do not receive your work by
– 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).