Lookup Wizard in Microsoft Access 2016

by Ali January 29, 2018 at 10:36 am

In this article, I am going to explain lookup wizard in Microsoft Access 2016. Lookup wizard is the best option to create a drop-down list in Microsoft Access. The Microsoft Access lookup wizard is just like the drop-down list option of Microsoft word 2016. A lookup wizard is like a column that contains the list of options that you have typed and the filler of the form may select only from the list. We can use the lookup wizard for creating a form. By using the lookup wizard option we can save others and our time because while filling the form you/they will just select an option, there is no need for typing. Inserting lookup wizard is easy we can insert it from the design view of the table. Without wasting let’s move through the steps of how to insert a lookup wizard in Microsoft Access 2016.

Watch the video tutorial if you are not interested in reading. Video placed at the end of the article.

How to insert Lookup wizard in Microsoft Access 2016

As I have mentioned in the above paragraph that we can insert the lookup wizard from the Design view of the tables. If we right-click on the tables at the left then you will see the Design view option. If you haven’t created a table yet then create a table and then go to the Design view of that.

Step1. Once you are in the design view of the table then add some fields like Name, F/Name, ID. Add the filed that you want to insert a lookup wizard on.

Step2. When the fields are created then move to the data type section. The data type is at the right hand of the window. Go to the data type of the field that you want to insert the lookup wizard. Select the lookup wizard option from the list. Look at the picture above for more instructions.
Step3. After selecting the lookup wizard option a small window will pop up, you will see two options there, select the second option and continue.

Type the Values (Second option)
Type the Values (Second option)

Step4. Here you have to type the values you want to be listed in the cell/column. You can add as many records as you want. Once you have typed everything up then continue. Look at the following picture for more instructions.

Lookup wizard in Microsoft Access 2016
Type Value

Step5. Everything is set up here but if you want to limit the entries then you must tick the first option in the list. Once you do this, people will not be able to type other values, they must select the values you typed. Once you have done these steps Go to the Datasheet view of the table and check if the lookup wizard is working or not.

Lookup wizard usages in Microsoft Access 2016
Limit to the list

I hope this article will help you in creating lookup wizard in Microsoft Access 2016.

Conclusion (How to insert Lookup wizard in Microsoft Access 2016)

The whole article was about lookup wizard in Microsoft Access 2016. The lookup wizard is like a drop-down list. You can insert the list by using the lookup wizard option. If you have any questions regarding this article share it with us in the comment section. Don’t forget to watch the following video for more information and guide. Make sure to subscribe my YouTube channel.


Add Comment