Categories
How To Guides

Working with Forms in MS Access

Though you can enter the data directly into the database tables, you may find it very simple to use forms. Forms ensures that you are entering the right data in the right location as well as format. This will let you keep your database accurate as well as consistent.

Working with Forms:

To open an existing form
  • First of all you need to open your database and then locate the Navigation pane.
  • Now in the Navigation pane you need to locate the form you want to open.
  • Now double click the desired form.
  • Now it will open as well as appear as a tab in the Document Tabs bar.
Entering and Modifying Data
  • To add a new record
  • There are two different ways to add a record to a form
  • In the Records group on the Home tab of the Ribbon you need to click the New command.
  • On the Record Navigation bar at the bottom of the window you need to click New Record button.
To Find an Existing Record to View or Edit

There are two different methods to find and view an existing record by using a form and they both use Navigation bar at the bottom of the screen.

  • To look through the records one at a time you need to 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.
  • For searching for a record, you need to type a word you know is contained in that record in the navigation search box.
To Save the Current Record:
  • First of all select the Home tab and then locate the Records group.
  • Now you need to click the Save command and the current record will be saved.
To Delete the Current Record:
  • First of all select the Home tab and then locate the Records group.
  • Now click the Delete command.
  • Now a dialog box will appear and you need to click Yes.
  • The record will be permanently deleted.