Test your skills
How to update, add, and delete data on MS Access and use it as a search engine?
Adding or Editing Data in MS Access Datasheet:
Deleting a record in MS Access Datasheet:
The above steps are for MS Access 2007. If you are using MS Access 2003 or earlier versions than that, you may go to http://support.microsoft.com/kb/304473for the step-by-step procedures on how to edit, add, or delete records in the datasheet.
Use these steps. Will help you surely.
Choose the table you want to use, and open it. On the table, a horizontal row represents a single record. A column represents a single field in the record.
Use this URL to learn more: [http://fisher.osu.edu/~muhanna_1/837/MSAccess/tutorials.html]
Hope this helps!