Assignment 2
Home Up

ASCII table

Exercise 1

  1. Create a new form, in your Unit 3 database do not attach a table to it.
  2. Change the Caption of the form to display, Payroll?
  3. Turn Record Selectors, Navigation Buttons and Dividing Lines to No
  4. Turn Auto Centre to Yes.
  5. Change the Width to 4 inches.
  6. Change Scroll Bars to none
  7. Save the form with the Name of Lesson2Exercise1.
  8. Create a form as shown, remember to use appropriate names for variables and objects and to include comments.
  9. When the value is entered in for the department code, the data in the bottom section will up-date. You will need to use the Change event of the text box.
  10. The number of hours the employee has worked is multiplied by the rate determined by the Department Code. The various department codes, the department name and the rate of pay is given in the table below:

wpe4.jpg (9121 bytes)

Department Code Department Name Pay Rate
1 Purchasing 6.75
2 Sales 7.85
3 Accounting 10.00
4 Administration 15.45