Microsoft Office Tutorials and References
In Depth Information
a. Add the title in the Form Header section.
b. Make sure the form’s Record Source property is set to tblGuest and then add a
combo box in the Form Header section to find GuestID field values.
c. Add a subform based on the tblReservation table, name the subform
frmGuestAndReservationSubform , delete the subform label, and resize the col-
umns in the subform to their best fit and resize and position the subform.
d. Add a calculated control that displays the total of the People field displayed in the
subform. Set the calculated control’s Tab Stop property to No, and set the label’s
and calculated control’s Border Style property to Transparent.
e. Add a line in the Form Header section, and add a rectangle around the calculated
control and its label, setting the line thickness of both controls to the line style
with the ScreenTip 3 pt.
f. Use the Background fill color (row 1, column 5 in the Access Theme Colors
palette) for the sections and the calculated control.
g. Use the Raised special effect for the labels in the Detail section and the Form
h. Make sure the tab order is top-to-bottom and left-to-right for the main form text
8. Close the Vacation database without exiting Access, make a backup copy of the
database, open the Vacation database, compact and repair the database, close the
database, and then exit Access.