Chapter 3, Problem 3.5AYK

Switch the ClientEntry form to Design view, and expand the Form Footer section to about 75" tall. Add a text box to the top right corner of the Footer section, and enter the formula =Count([ClientID]) as its control source. Enter Total Clients as the label name. (Hint: if necessary, change the width of the label so that the full text is visible). Add another text box directly below the one you just added, and enter the formula =SUM([MonthlyFee]) as the control source and Total Fees as its label name. Modify the Total Fees text box to use Currency format, then switch the ClientEntry form to Form view and confirm it matches Figure 3 below. Save the form. In the italic bold section that is the part I am having trouble with. For some reason the property sheet does not have the Currency Format in there at all. So, I am not sure if I did something wrong or what. Can you help. I am provind an image of the project. In the Total Fees text box is where I am stumped.

CLL question Next within the form, create a field set with the ID deliveryInfo. Within this field set, add the following: A legend containing the text Delivery Options. A text area box with the ID addressBox and field name of delAddress containing the placeholder text Enter delivery address. A label containing the text Delivery time (leave blank for earliest delivery) associated with the delBox control. Add an input element with the ID delBox and field name delTime for storing delivery time values. Use a data type of “time” for the control.

Create a Split Form using the Transfer Schools table as the source. Change the height of the AdmittingSchool field to be approximately half the current height. Remove the layout from all the labels and fields. Shrink each field so it is approximately as large as it needs to be. Click record 123455 in the bottom half of the split form. Make sure all fields are still visible in the top half of the form. If not, adjust the controls so all values are visible. Move the CreditsTransferred field so it is to the right of the CreditsEarned field on the same row. Move the RegistrationFee field so it is just below the CreditsEarned field. Move the TuitionDue field so it is just below the CreditsTransferred field. Change the title of the form to Transfer Schools Overview and save the form as Transfer Schools Form. Close the form. Create a Report Kelly is hoping you can create a more print-friendly version of the query you created earlier for her to distribute to the Board of Trustees. You will…