Working with Forms

In Access forms ensure you're entering the right data in the right location. Use forms in Access to keep your Access database accurate.

Working with forms

Video: Working with Forms in Access 2010

Launch video!Watch the video (4:16).

To work with forms in Access, you'll need to know how to open a form, as well as how to view and edit the information in a form.

To open an existing form:

  1. Open your database, and locate the Navigation pane.
  2. In the Navigation pane, locate the form you want to open. Forms are marked with the icon.
  3. Double-click the name of the form. It will open and appear as a tab in the Document Tabs bar.
    Opening a formOpening a form

Entering and modifying data

Depending on the database you're using, the forms you work with may include special tools and features that let you complete common tasks with one click of a button. You'll see examples of these tools in the interactives on the next page. However, regardless of which type of form you're working with you can follow the same procedures for carrying out certain basic tasks.

To add a new record:

There are two ways to add a new record to a form:

To find an existing record to view or edit:

There are two ways to find and view an existing record using a form, and they both use the navigation bar at the bottom of the screen:

To save the current record:

  1. Select the Home tab, and locate the Records group.
  2. Click the Save command. The current record will be saved.
    Saving a recordSaving a record

To delete the current record:

  1. Select the Home tab, and locate the Records group.
  2. Click the Delete command. The record will be permanently deleted.
    Deleting a recordDeleting a record