Microsoft Office Tutorials and References
In Depth Information
| Session 4.1 Quick Check
1. Describe the difference between creating a form using the Form tool and creating a
form using the Form Wizard.
2. What is an AutoFormat, and how do you change one for an existing form?
3. A(n) is an item on a form, report, or other database object that
you can manipulate to modify the object’s appearance.
4. Which table record is displayed in a form when you press the Ctrl+End keys while
you are in navigation mode?
5. Which wildcard character matches any single alphabetic character?
6. To print only the current record displayed in a form, you need to select the
option button in the Print dialog box.
Oren would like you to create a form so that he can view the data for each customer and
the customer’s contracts at the same time. The type of form you need to create will
include a main form and a subform.
Creating a Form with a Main Form and a
To create a form based on two tables, you must first define a relationship between the two
tables. In Tutorial 2, you defined a one-to-many relationship between the Customer (primary)
and Contract (related) tables, so you can now create a form based on both tables.
When you create a form containing data from two tables that have a one-to-many rela-
tionship, you actually create a main form for data from the primary table and a subform for
data from the related table. Access uses the defined relationship between the tables to join
them automatically through the common field that exists in both tables.
Oren and his staff will use the form when contacting customers about their contracts.
The main form will contain the customer ID, company name (if any), first and last names,
phone number, and e-mail address for each customer. The subform will contain the infor-
mation about the contracts for each customer.
You’ll use the Form Wizard to create the form.
To create the form using the Form Wizard:
1. If you took a break after the previous session, make sure that the Belmont data-
base is open and the Navigation Pane is closed.
2. Click the Create tab on the Ribbon.
3. In the Forms group on the Create tab, click the More Forms button, and then click
Form Wizard . The first Form Wizard dialog box opens.
When creating a form based on two tables, you first choose the primary table and
select the fields you want to include in the main form; then you choose the related
table and select fields from it for the subform.