Microsoft Office Tutorials and References
In Depth Information
cal c ulated
a. Selected fields
from the tblMember
in a subform named
b. The calculated control displays the total number of records that appear in the
subform. Set the calculated control’s ControlTip Text property to Total number of
members in this program . Set the calculated control’s Tab Stop property to No.
c. Apply an appropriate AutoFormat to the form.
d. View the completed form.
6. Close the Training database without exiting Access, make a backup copy of the data-
base, open the Training database, compact and repair the database, close the data-
base, and then exit Access.
| Case Problem 3
Use the skills you
learned in the tutorial
to work with a data-
base that contains
data about an agency
that recycles house-
hold goods and to
create a custom form.
Data File needed for this Case Problem: Agency.accdb ( cont. from Tutorial 5 )
Rossi Recycling Group Mary Rossi asks you to create several forms, including a cus-
tom form for the Agency database so that she can better track donations for the agency.
You’ll do so by completing the following:
1. Open the Agency database located in the Level.02\Case3 folder provided with your
2. Use the Documenter to document the tblDonor table. Select all table options; use
the Names, Data Types, and Sizes option for fields; and use the Names and Fields
option for indexes. Print the report produced by the Documenter.
3. Use the Multiple Items tool to create a form based on the qryDonorPhoneList query,
change the title to Donor Phone List , and then save the form as