When there are many records, you can use the Find and Replace dialog box and filter for the record.
Filter The filter indicator button shows whether a filter has been applied. The Find and Replace dialog box provides another way to change small amounts of data in less time and with less effort.
You can use the Find feature in the Find and Replace dialog box to locate a matching record.
In turn, each of the controls on the form either reads data from or writes data to an underlying table field.
Datasheets are grids of data that look like Excel worksheets.
You add a record to your database when you have a new item to track, such as a new contact to the Contacts table.
When you add a new record, Access appends the record to the end of the table.
To maintain data integrity, by default, Access does not let you to delete related data.
For more information, see Guide to table relationships.
Top of Page You must first find a record before you can edit or delete it.
In a form or datasheet that contains only a small number of records, you can use the record navigation buttons to navigate through the records until you find the one you want.
You can change data by working directly in Datasheet view.