• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 5. Modifying Your Table Design > Taking a Look at Lookup Properties

Taking a Look at Lookup Properties

As you have been working in table design, you’ve probably noticed that there’s a Lookup tab available in the lower part of the Design window. You might have also noticed that Access offers you a Lookup Wizard entry in the drop-down list of data types and a Lookup Field option on the Insert menu.

Microsoft Access for Windows 95 (version 7) introduced this feature to allow 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 field, you might want to provide a drop-down list that shows options for invoiced and not invoiced instead of yes and no or true and false.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint