In the Data View window, you can search database records for a particular value, and you can add, delete, or change records.
If you have opened a database table in Edit mode, you can edit its data in a number of ways. You can add or delete records, or edit a record's values. You can also search a particular column for occurrences of a specific value.
Changes that you make to individual records in a database table are not written to the database until you commit them. The Commit option updates the database table currently loaded in the Data View window with any changes that you make during an editing session and closes the Data View window. The Restore option undoes any changes you made in the Data View window during an editing session and closes the Data View window.
To help you track your editing during a work session, changed records are marked with an edit icon. You can easily review your changes before committing them to the source database table.