Data Manipulation In MS Access

Data Manipulation In MS Access

Hello Martin,
Use these steps. Will help you surely.

• 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: [https://support.microsoft.com/en-us/help/304473/how-to-edit-records-in-related-tables-in-a-microsoft-access-database]

Hope this helps!