Finding Sorting Filtering Data
Finding Data Table
Sorting Access Records
Filter Records to Display Record Subset
Filter Records Complex Criteria
Creating Access Queries
What are Queries
Query Access Database Window
Simple Query Wizard
Query Design View
Creating Query Design View
Save Query Design
Editing Query Design
Adding Criteria to Queries
Values in Criteria Expressions
Multiple Queries in Access
Specifying Sort Order
Creating Calculated Fields
Creating Access Forms
Access Auto Form
Displaying Records Access Form
Form Design View
Access Resize Controls
Access Form controls
Add Access Bound Controls
Toolbox Buttons Add Controls
Format form Controls Design form
Create Calculated Controls
Design Create Report
MS Access Reports
Navigating Report View
Access Mailing Labels
Report Design View
Header Footer Sections
How to 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
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:
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.