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.
- Open the form called Hours Subform. You see this form as part of the Projects form.
- Display the form in Design view.
- Add a text box to the detail section. Delete the paired label control
- Create a label control immediately above the new text box in the Form Header.
- Adjust the size and position of the new controls to make them work with the controls already on the form.
- Click the new label to display a cursor in the box. Change the text of the label to Billable.
- Click the new text box to display a cursor in the box. Type the expression to calculate the billable amount:=[Hours worked]*50
- Check the results in Form view.
- Close and save the form.
- Open the Projects form to see the effect of the changes you made on the subform.