Make sure that your cursor is in the field that you want to search on and then click the Find button.The Find and Replace dialog box will appear as shown in Figure 3-07 in your book and you will be able to type in the value that you want to locate.
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.
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 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.
Once the record is selected, press the Delete key on your keyboard to remove the record from the table.
It is important to remember that once you do this, there is no going back.
To open the table, select the table name in the Database Window and then right-click on it to display the shortcut menu.
From the shortcut menu, click on the Open option as shown in Figure 3-03 in your book. In this view, you can add a new record by clicking on the New Record button as shown in Figure 3-04 in your book.
There will be times that you will only want to see the records that match the criteria that you are searching for.