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. ClientEntry X2356Form HeaderClient EntryUnbounvDetailClientiDClientIDFirstNameFirstNameLastNameLastNameDateOf8irth:| DateOfBirthGenderGenderStartDateStartDateForm FooterTotal: Clients:=Count([ClientID]Total: Fees=Sum([MonthlyFee]) Add Existing Property TabSheet Order SelFields

Switch the ClientEntry form to Design view, and expand the Form Footer section to about 75" tall.…

Answered: the formula =Count([ClientID]) as its…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

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.

ClientEntry X
2
3
5
6
Form Header
Client Entry
Unbounv
Detail
ClientiD
ClientID
FirstName
FirstName
LastName
LastName
DateOf8irth:| DateOfBirth
Gender
Gender
StartDate
StartDate
Form Footer
Total: Clients:
=Count([ClientID]
Total: Fees
=Sum([MonthlyFee])

Add Existing Property Tab
Sheet Order Sel
Fields

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions