How to set up a lookup list in access

Setting method: First create a database, click the "Navigation Pane" icon button on the left side of the page; then select the specified data table, click the right mouse button, and select "Design View"; then select the specified field, "Data Type" Select "Lookup Wizard"; finally click "Type the required values ​​yourself", enter the specified type, and save the changes.

The operating environment of this tutorial: Windows 7 system, Microsoft Office Access 2013 version, Dell G3 computer.

Taking access2013 as an example, in the design view of the "Teacher" table, in the data type of the "Professional Title" field, click "Lookup Wizard" to create a lookup field, and you can create a lookup list.

The steps are as follows:

Take access2013 as an example, open access2013.

Create a faculty database.

Click on the upper left side, the blinds switch button.

Right-click on "Faculty" and click "Design View".

Click the "Data Type" drop-down menu of "Faculty Type" and click "Query Wizard".

Select "Type the desired value yourself".

Enter the professional title types such as "teaching assistant" and "professor".

After completion, save the changes.

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

You can see that the lookup list was created successfully.

Recommended tutorial: "sql video tutorial"

The above is the detailed content of How to set up a lookup list in access. For more information, please follow other related articles on the PHP Chinese website!