Using the data form

Once you’ve established your basic database or table, you can use the data form to delete or edit data in any field of any record. You also can use it to input entirely new records.

You have to add a button for the data form to the Quick Access toolbar in order to use the form. You add the button by customizing the Quick Access toolbar. To do so, right-click the toolbar and then click Customize Quick Access toolbar. Select Commands Not in the Ribbon from the Choose Commands from drop-down list, scroll down, click Form, click Add, and then click OK.

To use the data form, follow these steps:

  1. Select any cell within the list or table. (The list need not be defined as a table. It need only have a header row to identify the name of each field.) This cell can be within a record or within the field labels on the top row, just as long as it’s not outside the list or table.
  2. Click the Form button on the Quick Access toolbar. Figure 19-6 shows this button, and the resulting form that appears.
  3. Click the down and/or up arrows on the scroll bar to display the desired record, then edit text box (field) entries as desired.
  4. To add a new record, click the New button and then type the new field entries.
  5. To permanently remove the displayed record, click the Delete button and then click OK in the confirmation message box (Figure 19-7).

Pressing the Esc key when no changes have been made will close the form.

FIGURE 19-6
You can use this form to add information to a list or table.

FIGURE 19-7
Confirm that you want to delete the record, when prompted.

When you delete a record from the database with the form’s Delete button, the warning message isn’t kidding about its being permanently gone. You can’t even use Undo to reverse the action the way you can with other actions.

Add to Technorati Favorites


// Related Posted - GOOGLE!

Loading



Related Websites
No comments yet.

Leave a comment

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>