Question: 6 . Create a custom form based on the qryBalanceContacts query. Display all fields from the query in the form. Create your own design for

6. Create a custom form based on the qryBalanceContacts query. Display all fields from the query in the form. Create your own design for the form. Add a label to the bottom of the Detai l section that contains your first and last names. Change the label's font so that your name appears in bold, blue font. Change the BalanceDue text box format so that the field value is displayed in bold, red font. Save the form as frmBalanceContacts.
7. Use Figure 6-52 and the following steps to create a custom form named frmCoursesWithRegistrations based on the tbiCourse and tblRegistration tables
a. Place the fields from the tblCourse table shown in Figure 6-52 at the top of the Detail section, and edit the captions in the associated label controls as shown.
b. Selected fields from the tbiRegistration table appear in a subform named frmCoursesWithRegistrationsSubform.
c. The calculated control displays the total number of records that appear in the subform. Set the text Total number of students registered for this course as the value of the calculated control's ControiTip Text property. Set the calculated control's Tab Stop property to No.
d. Apply the Organic theme to the frmCoursesWithRegistrations form only. e. Save and close the form. NOTE: I am struggling with creating a blank and custom form based on the query rather than a table. I only show tables available in the field list in access. Please help.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!