Microsoft Office Tutorials and References
In Depth Information
Forms simplify the process of adding new records to a table. Creating forms is easy, and can be applied to
one or more tables.
When you base a form on one table, you simply select the table, click the Create tab, and then select Form
from the Forms group. The form will then contain only the fields from that table. When data is entered into the
form, a complete new record is automatically added to the table. Forms with two tables are discussed next.
Making Forms with Subforms
You also can create a form that contains a subform, which can be useful when the form is based on two or
more tables. Return to the example Employee database to see how forms and subforms would be useful for
viewing all of the hours that each employee worked each week. Suppose you want to show all of the fields
from the Employee table; you also want to show the hours each employee worked by including all fields from
the Hours Worked table as well.
To create the form and subform, first create a simple one-table form on the Employee table. Follow these
1. Click once to select the Employee table. Click the Create tab, then click Form in the Forms
group. After the main form is complete, it should resemble the one in Figure B-77.
The Employee form
2. To add the subform, take the form into Design view. In the Design tab, make sure that the Use
Control Wizards option is selected, scroll to the bottom row of icons in the Controls group, and
click the Subform/Subreport icon, as shown in Figure B-78.