Database help needed - pre-set data to choose from when populating the database.

Hi Guys,

My wife has asked me to help her set up a database of safari lodges throughout Southern Africa. I assumed Excel would be a great solution as the lodges, lodge activities, etc. can be searchable using the Filter function.

What I didn't consider, was how to populate the database. There will be predetermined fields that the user must select from when populating the database. As an example, there are a few game reserves where these lodges are located in. She does not wan the user to add a name that is spelt incorrectly, but rather is selected from a drop down. The same would apply for other fields like prices range, sharing options, no. of rooms, etc.

My question is, does Excel have the capability to set pre-determined information that can be selected when populating the database, and if so, how does one do it?

Many thanks

Excel.png