You also have the option of replacing everything at once by clicking on the Replace All button.Top of the Page When you locate records using the Find button, all of the records in your table will still be displayed.
To perform this, click on the Replace Tab in the dialog box and put the Find and Replace values in the appropriate boxes.
Now you can use the Find Next button to move to the next record that contains that value and if you want, you can click on the Replace button to replace the value with the new one.
To process the request, click on the Find Next button.
If the value exists in the table, Access will move to that record.
If you click the Yes button, you won't be able to get these records back unless you have made a backup of your database.
Access allows you to delete multiple records at one time.
This is done by selecting multiple records and then pressing the Delete key on your keyboard.
There may be cases when Access does not allow you to delete records and this usually happens when referential integrity is involved. Top of the Page Access allows you to change the structure of a table after it has been created.
To open the table, select the table name in the Database Window and then right-click on it to display the shortcut menu.