Access 2010

Working with forms

Video: Working with Forms in Access 2010

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 would like 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 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:

• In the Records group on the Home tab of the Ribbon, click the New command.
  Creating a new record from the Ribbon

• On the Record Navigation bar at the bottom of the window, click the New Record button.
  Creating a new record from the Record Navigation bar

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 look through records one at a time, click the navigation arrows. The right arrow will take you to the next record, and the left arrow will take you to the previous one.
  Navigating through records
• To search for a record, type a word you know is contained in that record in the navigation search box.
  Searching for a record

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 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 record