From the course: Access Essential Training (Office 365/Microsoft)
Join today to access over 25,600 courses taught by industry experts.
Data lookup fields - Microsoft Access Tutorial
From the course: Access Essential Training (Office 365/Microsoft)
Data lookup fields
- [Instructor] A lookup field allows you to select a value from a list when populating a table with information. Like validation rules and default values, this is another technique that you can use to ensure that the information in your Access database is valid and consistently entered. In the prior video, we added a validation rule to ensure that the only phone number types that get entered will be home, mobile, or work. We can take this concept a step further by providing those options as a value lookup list. In order to create the lookup field, I'll take my customer phone numbers table and I'll switch into design view. Then I'll click on the phone type field. Now, there is a tab in the field properties below for lookup, but it currently only gives us one option that says text box. In order to create the lookup field efficiently, we can actually go through the data type dropdown menu and Access gives us a lookup wizard that'll walk us through all the steps to filling in the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
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.