Data Manipulation In MS Access

Adding or Editing Data in MS Access Datasheet:

1. Open a table in Datasheet view
2. Click on Home tab
3. Click on New in Records group
4. Click the field you would like to edit
5. Type the correct data or add your new data

Deleting a record in MS Access Datasheet:

1. Go to Home tab
2. Click Delete Record on the Delete list found in Records group

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.

Hello Martin,

• Open MS Access and open the database. 
• Use the F11 key and switch to the database.
• A list of tables appears after you click the 'Table' tab

  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.
   

• Click in the first cell in a empty record and type the data that should fill there.
• Use the tab key or click manually to move from one column to the next.
• After adding the record, a new, blank record will automatically appear below.

• To edit a query based on a table, open that particular query in Datasheet view 
• Type the data you want to update.

• Create a SELECT query to specify the records that need be deleted.
• Go to query design view. Click on the drop-down menu, at the right of the 'Query Type' button & choose 'Delete Query'
• If necessary, modify the query so that the correct fields will be deleted.
• Click the Run (!) button and run the action query
• Close the query, saving if required

Use this URL to learn more: [http://fisher.osu.edu/~muhanna_1/837/MSAccess/tutorials.html]

Hope this helps!