Entering Records into a Table


A database must have data! Data are entered in records—through tables or forms. When entering records in a table, you must use Datasheet View.



To enter records in a table:

  1. Open the table in Datasheet View.
  2. Enter a new record by clicking the New Record button.
  3. Type or select the data in the first field of the record. Press the Tab or Enter key to move to the next field.
  4. When you've entered all the data for the new record, click Tab or Enter to start another new record.
  5. Don't forget to save the changes to the table.


If the field has rules to govern the type or format of data, Access will warn you if you enter invalid data.

Not all fields allow you to enter data by typing. Some fields have lists from which you choose values; other fields allow you to insert a picture or other object.

There are many ways to enter a new blank record at the end of the table:

  1. Click the New Record button on the toolbar.
  2. Click the New Record button on the navigation bar.
  3. Select New Record from the Insert menu.
  4. Click the Edit menu, point to Go To, and select New Record.