Form View is where you actually view and modify data. Form View enables you to enter and review the data in a user-friendly format.

You can use the form to add records into the database. Click the New navigation button to start a new record, if needed (see below), and then type or select data in the fields, pressing Tab to move between fields.

To demonstrate the use of the Form View, follow these steps to create a new form based on tblProducts:

1. Select tblProducts in the Navigation Pane.
2. Click the Create tab on the Ribbon.
3. Click on the Form command in the Forms group.
4. Click the Form View button on the Home tab’s Views group to switch from Layout View to Form View.

Figure 35-22 shows the Access window with the newly created form displayed in Form View. This view has many of the same elements as Datasheet View. At the top of the screen, you see the Access title bar, Quick
Access toolbar, and the Ribbon. The form in the center of the screen displays your data, one record at a time.

FIGURE 35-22
A form in Form View.

If the form contains more fields than can fit onscreen at one time, Access 2007 automatically displays a horizontal and/or vertical scroll bar that can be used to see the remainder of the data. You can also see the rest of the data by pressing the PgDn key. If you’re at the bottom of a form, or the entire form fits on the screen, and press PgDn, you’ll move to the next record.

The status bar at the bottom of the window displays the active field’s Field Description that you defined when you created the table (or form). If no Field Description exists for a specific field, Access displays the words Form View. Generally, error messages and warnings appear in dialog boxes in the center of the screen (rather than in the status bar). The navigation buttons, search box, and view shortcuts are found at the bottom of the screen.

These features let you move quickly from record to record, find data quickly, or switch views.

• How to Create Multiple Streams of Income The Easy Way Every single one of us would be thrilled to have more money coming into our homes every month. If you’re...
• HTC HD2 Video Review phone, the HD2. This is the first Windows Mobile phone with a capacitive touch screen, and the glass display measures...
• 100 of the Best Privacy Tools and Online Resources [/caption] The Internet still remains a largely unregulated domain with no enforcement agency with any teeth to protect the privacy...
• GPS Review: Garmin Nuvi 1690 [/caption] The good: The Garmin Nuvi 1690 features free (and ad-supported) access to Garmin's nuLink data service, which provides traffic...
• Pentax unveils 40MP 645D medium format DSLR [/caption] Five years after announcing its development, and following a month-long online campaign trailing the launch, Pentax has finally unveiled...