From the course: Access 2019 Essential Training
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Data lookup fields
- [Instructor] A look up field allows you to select a value from a list when populating data with information. Like validation rules and default values this is another tool that you can use to ensure that the information in your access database is valid and consistently entered. I went ahead and added several new tables into our database here to support the hotel. We have several tables about the room assignments for our guests, as well as details about the rooms themselves. We also have a table about Landon employees. I'll go ahead and double click on it to open it up in data sheet view. Now the Landon Hotel has properties in several different countries. So when it comes time to adding a new employee to the database, I wanna make sure that they get assigned to an appropriate country location. We can control this data entry with a look up list. Let's go ahead and switch our table into design view. I'll just right click on the tab name and switch it there. Then we're gonna focus on 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.