Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to set up a lookup list in access. The introduction in the article is very detailed and has certain reference value. Interested friends must read it!

Setting method: first create database, click the icon button "Navigation pane" on the left side of the page; then select the specified data table, click the right mouse button, select "Design View"; then select the specified field,"Data Type" and select "Review Wizard"; finally click "Enter the required value by yourself", enter the specified type, and save the modification.

This tutorial will operate on Windows 10, Microsoft Office Access2013, Dell G3 PC.

Take access2013 as an example. Under the design view of the teacher table, in the data type of the title field, click lookup wizard to create a lookup field, and you can create a lookup list.

The procedure is as follows:

Take access2013 as an example, open access2013.

Create a faculty database.

Click on the shutter switch button on the upper left.

Right-click the Staff Table and click Design View.

Click on the "Data Type" drop-down menu for "Staff Type" and click on "Query Wizard."

Select Type the desired value yourself.

Enter title types such as "Assistant,""Professor," etc.

When done, save the changes.

Open "Faculty List" and click "Faculty Type."

As you can see, the lookup list was created successfully.

The above is "how to set up a lookup list in access" all the contents of this article, thank you for reading! Hope to share the content to help everyone, more relevant knowledge, welcome to pay attention to the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.