- Opening and Closing a Table in Datasheet View
- Entering Data in a Table
- Displaying Records
- Creating a New Record
- Selecting an Entry
- Selecting Records and Columns
- Freezing and Unfreezing Columns
- Hiding and Unhiding Columns
- Resizing Columns
- Rearranging Columns
- Editing a Record
- Deleting a Record
- Copying an Entry
- Copying an Entire Record
- Sorting Records in Datasheet View
- Finding Data
- Replacing Data
- Formatting the Datasheet
- Changing the Font
- Checking Spelling
- Previewing and Printing a Table
Entering Data in a Table
-
Open the table in which you want to enter data. Notice that the first field is selected.
-
If the selected field is an AutoNumber field (shown here), press Tab to move to the next field. If not, type an entry in the selected field before pressing the Tab key on your keyboard.
-
The insertion point moves to the next field (here, the First Name field). Type an entry (in this case, Andrew) and press the Tab key.
-
The next field is selected. Continue typing entries and pressing the Tab key until you complete all the fields in the row, or record.
-
When you press Tab after completing the last field in the row, Access saves the record and creates a new, blank row, ready for your entries.