Office 2007 Bible

Adding Records to a Database Table

So far you have only created one table in the MyAccessAutoAuctions database: tblContacts.

Adding records is as simple as selecting the table name in the database container and clicking on its name to bring up the table in Datasheet view. Once opened, you can type in values for each field. Figure 34-21 shows adding records in datasheet mode to the table.

Figure 34-21. Adding records to a table using Datasheet view.

[View full size image]

You can enter information into all fields except the Contact ID field (ContactID). AutoNumber fields automatically provide a number for you.

Although you can add records directly into the table through the Datasheet view, it is not the most efficient way. Adding records using forms is better.

Opening a datasheet

To open a datasheet from the Database window, click Tables in the Navigation Pane. Then, double-click the name of the table you want to open, for example, tblProducts.

An alternative method for opening the datasheet is to right-click on the table name and select Open from the pop-up menu.

Tip

If you are in any of the design windows, click on the Datasheet View command in the ribbon’s View group to view your data in a datasheet.

Moving within a datasheet

You easily move within the Datasheet window using the mouse to indicate where you want to change or add to your data—just click a field and record location. ...