Creating Forms  «Prev  Next»

How to create Calculated Controls - Exercise

Add a calculation to an Access Form

Objective: Add a calculated control to the Hours Subform.
You will receive 5 points for this exercise. The exercise is auto-scored, which means all you need to do to receive full credit for the exercise is click the Submit button. In this exercise you will add a calculated control to the Hours Subform.
You will see the result on the Hours Subform and also in the Projects form.
  1. Open the form called Hours Subform. You see this form as part of the Projects form.
  2. Display the form in Design view.
  3. Add a text box to the detail section. Delete the paired label control
  4. Create a label control immediately above the new text box in the Form Header.
  5. Adjust the size and position of the new controls to make them work with the controls already on the form.
  6. Click the new label to display a cursor in the box. Change the text of the label to “Billable.”
  7. Click the new text box to display a cursor in the box. Type the expression to calculate the billable amount:=[Hours worked]*50
  8. Check the results in Form view.
  9. Close and save the form.
  10. Open the Projects form to see the effect of the changes you made on the subform.