Updating multiple tables in a ms access database Free chat cam hr

One of the quickest ways to do this is to use the Find feature that is built into Access.When you are in form view, the Find button will be on the Form toolbar as shown in Figure 3-06 in your book.

updating multiple tables in a ms access database-63

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.

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.

There will be times that you will only want to see the records that match the criteria that you are searching for.

Last modified 13-May-2017 07:11