• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL

Chapter 14. Database Techniques > Using a Form for Data Entry

Using a Form for Data Entry

As explained in the previous section, you can manually create new records by adding rows at the bottom of the database. You can also use forms to speed data entry and make the process more like working in a traditional database application.

To use a form for data entry

Click any cell in the database.

Choose Data > Form.

A data entry form appears (Figure 14.3).

Figure 14.3. You can use a data form to create new records, edit the data in existing records, and delete unwanted records.

With the form displayed, you can do any of the following:

  • To flip through the records in their current sort order, click Find Next, Find Prev, or the up- and down arrows at the bottom of the scroll bar. To go directly to a record of interest, drag the scroll box/slider.

  • To create a new record, click the New button or drag the scroll box down to the blank record at the end of the database (labeled “New Record”). Enter the new data by typing and tabbing from field to field. When you're done, press to add the record.

  • To edit a record, display it, make the desired changes, and press .

  • Click Delete to delete the current record.

  • To view only specific records, click Criteria. In the form that appears, enter search criteria (Figure 14.4). Click Find Next and Find Prev to view the matching records. To resume working with the entire database, click Criteria, Clear, and Form.

    Figure 14.4. Enter search criteria in one or more fields. In this example, records in which the Amount field is greater than $100 will be identified as matches.

To dismiss the form and record changes made to the current record (if any), click Close.



Not a subscriber?

Start A Free Trial

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint