Microsoft Office Tutorials and References
In Depth Information
Making and Using a Form
Category ➪ Object Type from the contextual menu.) Now you see the objects
in the database, sorted by object type, such as Tables, Queries, Forms, and
When the form is open, you can switch views by clicking the View button in
the Views group on the Home tab of the Ribbon. The View button changes
depending on which view you’re in. When you’re in Layout view, the default
View button is Form view, and when you’re in Form view, the default is
Layout view. To get into Design view with the View button, click the bottom
part of the button and choose Design View from the drop-down menu.
You can also switch among views by right-clicking the object tab or title of
the form and choosing the view you want from the contextual menu.
The View button provides possible views depending on what type of object
you’re working on. The views available for tables and queries can be
different from those for forms.
Editing data in Form view
After you design and create your form, you can enter, edit, and display
records. To open a form in Form view, double-click its name in the Forms
section of the Navigation Pane. The Contacts form in Form view looks very
much like Figure 1-1, earlier in this chapter, except that now you can edit
and add data.
The form itself doesn’t store data. The data that a form displays comes from
tables in the database (the record source), and any changes you make are
stored in the tables. When you add a record via a form, Access stores the
record in the table(s). If your form displays information from a query, the
changes are stored in the tables that provide the records for the query. If
your form has subforms, as described in Chapter 4 of this minibook, you can
edit records from several tables at the same time.
In general, you use all the same keystrokes that you use when editing
records in Datasheet view, as described in Book II, Chapter 1. You can
press Tab or Enter to move from one field to another. You can also click the
navigation buttons at the bottom of the form to move to different records.
A Search box at the bottom of the form allows you to search for the text in
whatever field your cursor is in.
If you prefer to use the keyboard to move around a form, check out Table 1-2
for a list of keys to use.