From the course: Access 2016 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Creating lookup fields

Creating lookup fields

From the course: Access 2016 Essential Training

Start my 1-month free trial

Creating lookup fields

“

- 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 tool that you can use to ensure that the information in your Access database is valid and consistently entered. Now you notice here inside of the LandonHotel-Lookup:Database, I've imported a couple of more tables that will support the hotel's operations. One of them, is the LandonEmployees table. If we double click on it, we can take a look at it. Inside of it, I've got some information about the names of the members of our executive team, as well as their titles. I've got address, the country where they're based, their phone number, email and a long bio right over here. Now the way the hotel has properties in several different countries, so when it comes time to adding a new employee to the database, I want to make sure that they get assigned to an appropriate location. We can do that by creating a Lookup field on the Country…

Contents