O'Reilly logo

Microsoft Office® Access 2007 Inside Out by John Viescas and Jeff Conrad

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

Taking a Look at Lookup Properties

As you have been working with table design, you’ve probably noticed that there’s a Lookup tab available in the lower part of the Table window in Design view. You might have also noticed that Access 2007 offers you a Lookup Wizard entry in the drop-down list of data types and a Lookup Column option in the Tools group on the Design tab. This feature allows you to predefine how you want the field displayed in a datasheet, form, or report. For example, if you have a DepartmentID field in an Employees table that stores the primary key value of the department for which the employee works, you might want to display the department name rather than the number value when you look at the data. If you’re displaying a Yes/No ...

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