en uk

Adding a field Microsoft Access 2007

    Before you can add a field to a form, you must make sure that the field already exists in your database table. For example, if you want to add a field on a form that displays phone numbers, you must first create that field in your database table and then stuff it with actual data.

    To add a new field to a database table, follow these steps:

    1. Click the Office Button and then choose Open.

    The Open dialog box appears.

    2. Click the Access database file you want to add or edit data. Then click Open.

    Access displays your chosen database.

    3. In the All Tables pane on the left of the screen, double-click the name of the database table that displays data through a form.

    Access displays the Datasheet view, showing rows and columns.

    4. Click the Add New Field column that appears to the right of your data­base table.

    Access highlights the entire column.

    5. Click the Datasheet tab.

    6. Click the Rename icon in the Fields and Columns group.

    The cursor appears in the column heading you chose in Step 4.

    7. Type a descriptive field name, such as E-Mail or Birthday, and then press Enter.

    8. Click in the column of the field you just created and named and then type new data.

    After you either create a new field or verify that a field already exists in a database table, you're ready to add that field to a form.

    To add a field to a form, follow these steps:

    1. Click the Office Button and then choose Open.

    The Open dialog box appears.

    2. Click the Access database file you want to add or edit data. Then click Open.

    Access displays your chosen database.

    3. In the All Tables pane on the left of the screen, double-click the name of the form you want to use.

    Access displays the Form view of your database.

    4. Click the Home tab.

    5. Click the downward-pointing arrow underneath the View icon in the Views group.

    A pull-down menu appears.

    6. Choose Design View.

    Access displays your form in Design view.

    7. Click the Design tab.

    8. Click the Add Existing Fields icon in the Tools group.

    The Field List window appears, as shown in Figure 16-11.

    9. Double-click a field.

    Access displays the field label and a field on your form.

    10. (Optional) Move the mouse pointer over the upper-right corner of the field label and drag the mouse (hold down the left mouse button and move the mouse) to move the field label on your form.

    11. (Optional) Repeat Step 10, except move the field instead of the field

    Label.

    12. Click the downward-pointing arrow underneath the View icon in the Views group.

    Access displays the Form view. Notice that the form displays both your newly added field and any data stored in that field.

    13. Click the Office Button and choose Save to save the changes to your form.

    Adding a field Microsoft Access 2007

    Figure 16-11:

    The Field List window shows you all the fields stored in your data­base table that you can place on the form.




BACK NEXT TOP

Site is a private collection of materials and is an amateur informational and educational resource. All information is obtained from public sources. The administration does not apply for authorship of the materials used. All rights belong to their owners.