Microsoft Office Tutorials and References
In Depth Information
Entering the Data in a Form
Creating a form
Fortunately, the Form Wizard makes it very simple to create a form for
entering information in a database table. All you have to do is start the wizard,
choose the table, and make a couple of design decisions. To create a form,
go to the Create tab and click the Form Wizard button. You see the first of
several Form Wizard dialog boxes. Answer these questions and keep clicking
the Next button until the time comes to click Finish:
✦ Tables/Queries: From the drop-down list, choose the name of the
database table you need to enter data in.
✦ Selected Fields: Click the >> button to enter all the field names in the
Select Fields box.
✦ Layout: Select the Columnar option button. The other layouts aren’t
much good for entering data in a table. If you choose Tabular or
Datasheet, you may as well enter data straight into the datasheet rather
than rely on a form.
✦ Title: Name your form after the table you created it for so you can
identify the form easily in the Navigation pane.
To delete a form, right-click its name in the Navigation pane and choose
Delete on the shortcut menu.
Entering the data
To open a form and begin entering data in its database table, display the
form’s name in the Navigation pane and then double-click the form’s name.
You can also right-click the name of the form and choose Open.
To enter data in a form, click the New (Blank) Record button. This button
is located with the Navigation buttons at the bottom of the form window. A
new, empty form appears. Start typing. Press the Tab key, press the Enter
key, or click to move from field to field. You can move backward through the
fields by pressing Shift+Tab. If you enter half a record and want to start over,
press the Esc key to empty the current field. Press Esc again to empty all the
The Navigation buttons at the bottom of the form window tell you how many
records are in the database table and which record you’re looking at. From
left to right, the Navigation buttons take you to the first record, previous
record, next record, and last record.