From the course: Access: Building a Sales Database
Join today to access over 22,700 courses taught by industry experts or purchase this course individually.
Lookup tables - Microsoft Access Tutorial
From the course: Access: Building a Sales Database
Lookup tables
- [Instructor] Lookup tables are used to supply a drop-list of values acceptable for a given field. For example, in our State field here, I could set up a separate table of the 50 U.S. state, two-character abbreviations, making it a lot easier to choose a state when you're entering someone's address. The way I'm gonna use it here, however, is I'm gonna build a lookup table for the status of a customer. It's going to replace our validation rule. Validation rules are good, but it's not until someone makes a mistake that they find out that there's a fixed list of things they can use. If you set up a lookup table, they know right away because when they see the field pop up on a form or when they hit it in Datasheet view, they see the drop-arrow, and that tells them that there's a list of choices. Let's get rid of the validation rule. I'm just gonna delete it. There we go, I can leave the default value. And then I'm going to go up here to Status and hit the drop-arrow on the Data Type and…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.