Access Chapter 4 Critical Thinking

How can the manager add subtotals and totals for the Amount Paid column?

Click the Amount Paid column header to select the field. Then, click the Totals button on the DESIGN tab to display the list of available calculations. Finally, click Sum to calculate the sum of amount paid values.

How can the manager add the date to the form?

Click the Date and Time button on the FORMAT tab, select the appropriate date format, remove the check mark from the Include Time check box, and then click the OK button.

How can the manager place the controls in a stacked control layout?

Display the ARRANGE tab. Select all the controls on the form and then click the Stacked button on the ARRANGE tab to place the controls in a stacked layout.

How can the manager emphasize those records where the current amount due is $0.00?

To emphasize a particular value, use conditional formatting. Click the FORMAT tab and then click the Current Due field on any record. Click the Conditional Formatting button and then create a new rule in the Conditional Formatting Rules Manager dialog box that checks for the value of 0 in the Current Due field. Assign conditional formatting, such as a different color or a different font.