How to Add a New Record in Forms in Microsoft Office Access 2007

By Foye Robinson

Microsoft Access 2007 helps you manage data more efficiently. You can add, edit and delete records in an Access table, query or form. Each row in an Access table or query makes up a record, and each record is made up of individual fields pertaining to that record. You can pull fields from one or more tables/queries to create your form and select the exact fields you need. Forms make it easier to enter data into a database without editing its design or going through the Access table.

Step 1

Open Access 2007 and click on “More…” to open your database. Double-click on the database name to open it.

Step 2

Navigate to the “Forms” category by clicking on “All Tables” in the left pane and choosing “Object Type.”

Step 3

Go to the “Forms” section in the task pane and select the form you’re updating. Double-click on the form name to open it. The form will be placed onto your screen.

Step 4

Add a new record to the form by placing your cursor in the textbox by the field name. Then type in the applicable information for that field and press the “Tab” key to move to the next textbox.

Step 5

Enter your data into the textbox, tabbing after each entry. Once you’re finished adding the data for your record, press the “Enter” key.

Tips & Warnings

  • Since each Access form is created differently, the way you enter new records into a form may differ from form to form. Your form may allow you to “Enter” through each field name or even use an “Add Record” button (if it was added into the design).

References & Resources