Using a Data Form

To maintain our database we could enter more records by entering more records to the bottom of the List.

Fortunately for us Excel gives us a DATA FORM to use to insert new information, or to delete or edit old information.

Using this form we can also set various criteria for the records to be displayed.

Displaying the Data Form

To display the data form for our database open the DATA menu and select the FORM option.

The following form is displayed:

dform

All of the fields that appear in the database appear on the form.

The VALUE field is a computed field so it does not get a dialog box for you to type in.

The above form shows the first record, as indicated not only by the scroll bar but also by the notation at the top-right-hand corner of the form.

Records can be viewed one at a time by either scrolling through the database using the scroll bar or by clicking the Find Next and Find Prev buttons.

New records can be added easily also.