Updating access database datagridview
You can use the Find feature in the Find and Replace dialog box to locate a matching record.When you find a matching record, that record becomes the current record, and you can then edit or delete it.The deletion process is fairly simple, except when the record is related to other data and resides on the "one" side of a one-to-many relationship.To maintain data integrity, by default, Access does not let you to delete related data.
You add a record to your database when you have a new item to track, such as a new contact to the Contacts table.
The record number is counted sequentially, from the beginning of the form or datasheet — it does not correspond to any field value. The first matching value is highlighted in real time as you enter each character.
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.
For more information about input masks, see Control data entry formats with input masks.
Lists help maintain data integrity and are easy to use.