Review 2

Microsoft Excel and Microsoft Acess

1.      Do practice 5 of Microsoft Excel Chapter 2 on page 81. Enter your last name for the first employee. Make up numbers for hourly wage, regular hours, and overtime hours. Use the percentages of withholding tax and FICA (social security tax) as given in the file. Net pay should be your gross pay minus taxes.

2.      Do practice 2 of Microsoft Excel Chapter 3 on page 129.  Change the discount threshold from $6,000 to $5,000. Then proceed with the rest of the data manipulations. Add your name and computer number to the header the printouts.

3.      Do practice 7 of Microsoft Excel Chapter 4 on page 129. Make the letter addressed to you and change the address accordingly.

4.      Do practice 2 of Microsoft Excel Chapter 6 on page 285 in Volume 2. Follow the procedures instructed in the practice.

5.      Do practice 4 of Microsoft Access Chapter 2 on page 95. Replace “Andrea Camon” with your name in the form.

6.      Do practice 3 of Microsoft Access Chapter 3 on page 153. Make sure you are using the same database that you used in the above practice. Replace “Greg Kuehnel” with your name. You need to enter calculated fields for population density as well as the population density for the average of region. Manipulate labels and controls such that they appear similar to the example given in the book on page 154.

Exam 2 on Wed. Nov 15, 2000

Bring both volumes of the textbook