How to Create and Delete Records in Microsoft Access

You can create and delete records in Microsoft Access using either Datasheet view or Form view. These instructions work for Access 97.

Difficulty: Moderately Easy

Instructions

Things You'll Need:

• Microsoft Access

Using Datasheet View

1. Open your database file in Microsoft Access.

2. Use the F11 key to open the Database window.

3. Click on the Table tab to open the table window.

4. Select the table you want to use, then click Open.

5. To delete a record, put your cursor in the record you want to delete. Open the Edit menu and select Delete Record. Say yes when asked if you are sure.

6. To create a new record, simply add information in the last record shown and hit the Enter key. A new, blank record appears automatically.

Using Form View

7. Open your database file in Microsoft Access.

8. Use the F11 key to open the Database window.

9. Click on the Forms tab to open the form window.

10. Select the form title you want to use. Click Open.

11. To delete a record, go to the record you want to delete. Open the Edit menu and select Delete Record. Say yes when asked if you are sure.

12. To create a new record, click on the right arrow sign ( > ) at the bottom of the form. A new record will appear. Enter your data as needed.

Tips & Warnings

• The arrow keys at the bottom of Form view work somewhat like a VCR. Click on them to navigate through the records.
• Once deleted, the data is removed permanently.