- 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
Finding Data
-
Click in the field, or column, on which you want to search. For example, to search by last name, click anywhere in the Last Name column.
-
Open the Edit menu and choose Find.
-
The Find and Replace dialog box opens with the Find tab displayed. In the Find What field, type the entry you want to find.
-
Optionally, to search the entire table rather than the field you chose in step 1, click the down arrow next to the Look in field and choose the table name from the list that appears.
-
Click the down arrow next to the Match field and select Whole Field, Any Part of Field, or Start of Field.
-
Click the Find Next button.
-
Access locates and selects the record with the first matching entry. If this is not the record you need, click the Find Next button to find the next match and repeat as needed.
-
Access notifies you when no more matches are found. Click OK.