O'Reilly logo

2007 Microsoft® Office System Step by Step, Second Edition by Joan Lambert, John Pierce, Steve Lambert, M. Dow Lambert III, Curtis D. Frye, Joyce Cox

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required