How do I create a Lookup Field in Access 2007? A Lookup Field will create a drop down arrow in your cell, and allows you to display more details about your field including a code, along with its description. For example, you have a field for Department Codes. However, not everyone knows the definition of those codes. Through the Lookup Wizard you can create a list of Codes for the user to choose, and adjacent to the Codes are their descriptions incase they aren't familiar with the code. So you're still entering in the Code, and think of the description as more of a side note. So the Department Code for Human Resources is HR, and for the lookup it'll be Human Resources.

Purchase the training video and you can see this in action for yourself!