Microsoft Office Tutorials and References
In Depth Information
The new form displays all the records and fields from the tblContract table in
Datasheet view and in the same format as a table or query recordset displayed in
Datasheet view. “Datasheet View” appears on the status bar, as do two view icons,
one for Datasheet view and the other for Design view. The form name, tblContract,
is the same name as the table used as the basis for the form, but you should
change the name when you save the form.
When working with forms, you view and update data in Form view, you view and
make simple design changes in Layout view, and you make simple and complex
design changes in Design view. For the form created with the Datasheet tool, you’ll
check the available view options.
4. Click the Home tab on the Ribbon.
5. In the Views group, click the arrow on the View button. See Figure 6-8.
Each table and query in a
database must have a
unique name. Although
you could name a form or
report the same as a table
or query, it would cause
using object name prefixes
prevents this confusing
View options for a form created by the Datasheet tool
o p tion is not
availab l e view
Form view is dimmed, which means that it’s unavailable for this form type, and Lay-
out view is not an option in the list. Datasheet view allows you to view and update
data, and Design view is the only other view option for this form.
Sarah and her staff don’t have a need for a form with a datasheet format, so you
won’t save it.
6. Click the arrow on the View button to close the menu, and then close the form
without saving it.
Next, you’ll show Sarah a form created using the Multiple Items tool.
Creating a Form Using the Mulitple Items Tool
The Multiple Items tool creates a customizable form that displays multiple records from a
source table or query in a datasheet format. You’ll use the Multiple Items tool to create a
form based on the tblContract table.
To create the form using the Multiple Items tool:
1. Make sure that the tblContract table is selected in the Navigation Pane, and then
click the Create tab on the Ribbon.
2. In the Forms group, click the Multiple Items button. The Multiple Items tool cre-
ates a form showing every field in the tblContract table and opens the form in
Layout view. See Figure 6-9.