How to Insert Form Data Into a Table in Access 2007

Allowing users to enter data into a table directly can cause serious problems in your database if they enter invalid data. Forms are interfaces you can use in Microsoft Access to allow users to enter data. You can use the Form's Record Source property to define the table you will use to save data. In addition, you can use the Control Source property of the controls to define the field to use when data is entered on the control. Using a Form can also protect the data in a table from being deleted accidentally.

Instructions

1

Start Microsoft Access 2007. Click "Blank Database," and click the "Create" button. Click the "Create" menu and click "Table" to create a new table. Click "Add new Field" and type "City." Press "Tab" and type "State" to add the State column. Press "Tab" again and type "Zip" to add the Zip column.

2

Click the "Create" menu and click "Form Design" to create a new Form. Click "Text Box" in the "Controls" pane and click the "Detail" of the Form. Drag your mouse while holding the mouse button to draw a new text box.

3

Click the text box and press "Ctrl" and then "C" to copy the control. Press "Ctrl" and then "V" twice to create two additional text boxes. Right-click the Form and click "Properties." Select "Form" under "Selection type:" and then click the "Data" tab.

4

Set the Record Source property to "Table2." Set the Data Entry property to "Yes." Click the first text box on the Form and click the "Data" tab in the Property Sheet. Set the Control Source property to "City." Click the second text box on the Form and set Control Source to "State." Set Control Source to "Zip" for the third text box using the same technique.

5

Close the Property Sheet by clicking the "X" located in the upper right corner. Click the "View" icon to start entering data on the Form.

6

Enter a city name such as "Fort Worth" in the first text box and enter the state for your city such as "Texas" in the second text box. Enter the zip code such as "76102" in the third text box and press "Enter." Enter two more rows of data by entering your favorite city, state, and zip code using the same technique.

7

Double-click "Table2" on the left pane of your computer screen to open the table. You should see the three rows of data inserted to your table from the Form.