From the course: Access Essential Training (Office 365/Microsoft)
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Data lookup fields
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 the default values, this is another tool that you can use to ensure that the information in your access data base is valid and consistently entered. Now go ahead and add in several additional tables to the Landon Hotel database. One of them is LandonEmployees. Let's go ahead and double click on it to open it up. Now if we scroll over here to the right, we'll see that we have a column here for the employee's country. Now Landon Hotel has properties in several different countries so when it comes time to adding new information or new employees to the database, I wanna make sure that they get assigned to the appropriate location. We can convert this column into a lookup field and only allow a specific selection to be made when entering in a new employee to this table. To do that, I'll switch over into Design view. Then I'll find the country column…
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.