How to Use an Access Form to Append Data to a New Table

Microsoft Access allows you to enter data in a variety of ways. One of the most popular ways to append data to a new table is through an Access form. Use forms to allow users to enter each part of a new record, which will then be entered into a table when the user presses a button. This allows users to enter records without viewing or potentially editing any other data in your table. Access forms also appear more organized and are easier to read than a table with numerous records.

Instructions

1

Open an existing Microsoft Access database and click the "Forms" button in the main database window.

2

Click "New." If you already have a form you want to use, skip to Step 7.

3

Choose how you want to create your form. The three most common for appending data to a new table are "Design View," "Form Wizard" and "AutoForm: Columnar." The second two provide a wizard format to create a basic form. Design View allows you to create a form from a blank template.

4

Select the table or query you want to base your form on. To enter data in a new data, either select the table itself or an existing Append query. Follow the wizard prompts to finish the form creation.

In Design View, use the objects in the toolbox and field list to create your form.

5

Press the "View" button and select "Form" view if the form was created in a wizard format, or if all fields are bound to your table. Press the button at the bottom of the form with an arrow and an asterisk to add new records.

6

Bind each object to your table if the form was created in Design View. If you dragged fields from the "Field List" box to your form, the objects are already bound to your table.

Bind objects by right-clicking the object and choosing "Properties." Choose the "Data" tab. Enter the name of the table field in the "Control Source" box. For instance, if the textbox on your form is used to enter a customer's name in the Customer Name field in your table, the control source will be "Customer Name."

7

Create a button to save new records. Click the wizard button on the toolbox to create a button using wizard prompts.

8

Click the button object on the toolbox and draw the button on your form.

9

Choose "Record Operations" and then select "Save Record." Follow the wizard prompts to finish creating the button.