• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 3. Working with Tables > Entering, Editing, and Deleting Data

Entering, Editing, and Deleting Data

Once you've created your table you can jump right in and start entering data. You can move between records using the navigation bar; erase, add, or modify values in your records; or get rid of entire records altogether.

To enter data into a table:

1.
Open the tables in your database and click the table in which you want to enter data.

2.
Click the Open toolbar button ( Figure 3.8 ).

Figure 3.8. Clicking the Open toolbar button opens your table in Datasheet view, in which you can enter, edit, and delete table data.


Your table appears in Datasheet view, with the insertion point (represented by a blinking cursor) in the first cell of the first record ( Figure 3.9 ).

Figure 3.9. A datasheet is a lot like a spreadsheet.


3.
To enter data into a field, type it in. To move to the next field, press Tab. When you reach the end of a record, pressing Tab moves you to the first cell in the next record.

Access automatically enters values into an AutoNumber field like the Video Collection ID field in the example. Press Tab to move to the next field.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint