Access Data Manipulation
Finding Sorting Filtering Data
Creating Access Queries
Creating Access Forms
Design Create Report
Create calculated controls - Exercise
Add a calculation to a form
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
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:
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.