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.
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!