Working with Tables

In Access tables are arguably the most important object. Use tables in Access to store all of your data to run queries and reports.

Adding records and entering data

Entering data into tables in Access is similar to entering data in Excel. To work with records, you'll have to enter data into cells. If you need help entering data into records, you may want to review our Cell Basics lesson from our Excel 2010 tutorial.

To add a new record:

There are three ways to add a new record to a table:

Occasionally when you enter information into a record, a window will pop up to tell you the information you've entered is invalid. This means the field you're working with has a validation rule, which is a rule about the type of data that can appear in that field. Click OK, then follow the instructions in the pop-up window to re-enter your data.

An example of a validation warningAn example of a validation warning

To save a record:

  1. Select the Home tab, and locate the Records group.
  2. Click the Save command.
    Saving a recordSaving a record

Be sure to save any unsaved records before closing a table. Access will not prompt you to save them when you close the table.