Creating a Multi-Column Lookup List

Selecting a month from a list of names is convenient for people, but if your computer has to deal with this information in some mathematical way, a list of the numbers associated with each month is easier for it to use.

In this exercise, you will use the Lookup wizard to create a two-column list of months from which the user can choose.

Note

USE the MulticolumnLookup database. This practice file is located in the Documents\Microsoft Press\2007OfficeSBS\AccessKeeping folder.

OPEN the MulticolumnLookup database. Then display the Field Property Test table in Design view.

  1. Add a new field below Month1. Name it Month2, and set the data type to Lookup Wizard.

  2. Click I will type in the values that I want, and then click

Get 2007 Microsoft® Office System Step by Step, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.