Create and Edit Database Elements

Database Editor validates the formatting of data when you create and edit records.

To create data:

1. Select a row or cell.
2. From the Editing group of the Home tab, click Insert row, or right-click the row header and then select it from the menu. Database Editor opens a window to enter the desired fields values.
3. Type data in each required field.
4. When you finish typing data in the window, click OK. Database Editor validates the data and inserts the new row into the proper location in the table.

To edit existing data:

1. Select a cell.
2. Type data in the cell.

3. Select a new cell.

   When you edit a cell in the table, the Database Editor checks your entry to ensure that it is valid. If you entered a value or used a format that is not valid for the cell, the program prevents you from editing another cell or moving to another row until you correct your entry.

   To undo your changes, press Ctrl+ Z, or click Undo from the Clipboard group on the Home tab.

   However, sometimes changing the unit of measure on which the edited cell depends would make the edited value acceptable. In this case:

   1. Press Esc to override the error condition.
   2. Change the other cell as needed.
   3. Provided the dependent value is now correct, move to another cell or row.

   Note: You cannot move to another row or copy data to another row until the entire row you are working on is valid.

Tip: Press F1 on any cell in the grid for more information.