1-866-245-5224 sales@keystonelearning.com

Access 2007: Multivalued Fields

Access 2007: Multivalued Fields

Multivalued Fields are brand-new to Access 2007. A Multivalued Field allows you to create a field that holds, literally, multiple values. This is great for creating a field that displays a list.

For instance, if you need to track which projects each employee is working on, you can use a Multivalued Field to list all projects for one employee in ONE FIELD. What’s more, Access 2007 makes adding items from a multivalued list as easy as clicking a few checkboxes.

Creating a Multivalued Field

  1. Open the table you want to add the multivalued field to in Datasheet View
  3. Choose the Lookup Column command in the Fields & Columns group on the Datasheet tab

Figure 9. Lookup Wizard -  Choose Value Source

    3.       Choose “I want the lookup column to look up the values in a table or query.

    4.       Click Next


Figure 10. Lookup Wizard - Choose Table or Query


    5.       Choose the Table or Query that contains the values (list) you are using to populate your multivalued field

    6.       Click Next


Figure 11. Lookup Wizard -  Choose Fields


    7.       Move the fields you want to appear in your multivalued list from the Available Fields column to the Selected Fields column

    8.       Click Next


Figure 12. Lookup Wizard -  Choose Sort Orders


    9.       Choose a Sort order, if desired

    10.   Click Next


Figure 13. Lookup Wizard - Adjust Field Size


    11.   Resize your column(s)

    12.   Click Next


Figure 14. Lookup Wizard - Choose Allow Multiple Values


    13.   Enter a label for your lookup column

    14.   Check “Allow Multiple Values

    15.   Click Finish


When you click Finish, a lookup column is created whose field properties are set based on the choices you made in the Lookup Wizard.

You can view the field properties in the bottom pane of Design view under Field Properties.

To see the properties that apply specifically to the lookup column, click the Lookup tab.