CIS 155 Assignment Number 1

CIS 155 Assignment Number 1

Tutorial 1 - Traditional

Print Your Name ______

1)General instructions

a)Follow the steps of the case as they appear in the textbook. Below is a list of the items you will need to submit and how they are to be labeled.

b)Write your name and the printout number on each printout and submit them in numerical order.

c)When you complete the lab upload both databases into TalonNet for the lab 1 link and submit the printout to your instructor.

2)Complete Case problem 1.

a)Copy the School.accdb from the textbook datafiles(located in Level.1\Case1 folder) and save it into your lab 1 folder.

b)Follow the steps of the case as they appear in the textbook. Below is a list of the items you will need to submit and how they are to be labeled.

i)After creating the Teacher table and adding the records in Figure 1-31 you will print the Teacher table (after step 4) and label it 1.1.1.

ii)After step 6 print the revised Teacher table. Place our name on the printout and label it 1.1.2.

iii)After step 8 print the results of the Start Data query and label it 1.1.3.

iv)After step 9 print a form of the TeacherInfo forms and label it 1.1.4.

v)After step 10 adjust the width of the report columns so that the report fits on one page in Portrait orientation. The column width can be adjusted by placing the cursor between the column headings and then when the cursor changes to a double headed arrow you may move the edge of the column left or right to change the column width. Once the report fits on one page print theTeacherList report and label it 1.1.5.

3)Complete Case problem 3.

a)Copy the RRGroup.accdbfrom the textbook datafiles(located in Level.1\Case3 folder) and save it into your lab 1 folder.

b)Follow the steps of the case as they appear in the textbook. Below is a list of the items you will need to submit and how they are to be labeled.

c)Write your name and the printout number on each printout and submit them in numerical order.

i)After creating the Donor table and adding the records in Figure 1-33 you will print the Donor table (after step 4) and label it 1.3.1.

ii)After step 6, print the revised Donor table. Place our name on the printout and label it 1.3.2.

iii)After step 9, print the results of the DonorPhoneList query sorted by last name in ascending order and label it 1.3.3.

iv)After step10 print the record 8 from the form of the DonorInfo form and label it 1.3.4.

v)After step 11 adjust the width of the report columns so that the report fits on one page in Portrait orientation. The column width can be adjusted by placing the cursor between the column headings and then when the cursor changes to a double headed arrow you may move the edge of the column left or right to change the column width. Once the report fits on one page print the DonorList report and label it 1.3.5.

4)Submit the printouts numbered in sequential order to your instructor. Also, submit the Pinehill and Rossi database by uploading the databases into TalonNet assignment link for lab 1.

CIS155Lab1_Fa07T.doc
Fall 2007