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

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.

Couple using laptop
credit: Creatas Images/Creatas/Getty Images

Step

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

Step

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

Step

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

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

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