Create List of Values ​​Fields in Access  Detailed Guide ▷ 2020

At this time, Microsoft Access is still listed as one of the best programs databases of history. Which, it is a tool that works as a database management system and so, lets sort, search and present information in a professional manner.

Accordingly, it refers to Microsoft software that provides numerous utilities for excellent data management, such as: tables, queries, forms and reports. In this way, it allows using predesigned solutions, update and collect information intuitively and agilely, as well as obtaining the same report in different formats.

In addition to this, Access offers the possibility of make use of a list of values ​​fieldespecially when the user has a limited number of values ​​that do not change constantly (for example, expense categories). But, for this, it will be necessary to execute all the steps to follow to create a lookup list of values ​​field in a table and here, we will teach you how to do it.

What is a Lookup List of Values ​​Field and what is it for in Access?

Basically, a search field consists of a space that has the ability to find matching data within a table in Microsoft Access. As, for example, a field of ld. looking for a full name. So specifically, a lookup list of values ​​field refers to an element that deals with store a single value with the valid values ​​defined in a certain property.

Thus, the search value list fields are used to provide the values ​​of a drop-down list and thereby making it simpler to write data to a field. Also, this utility can help users to optimize the meaning of the data and avoid input errors with respect to information, since it allows you to limit the values ​​that can be entered and / or written.

Learn step by step how to create a List of Search Values ​​Field in Microsoft Access

Although it is true, a search field is defined as that field present in a table whose value is acquired through another table or query. In this sense, to simplify your creation process, it is always recommended to use the Search Wizard, thanks to the fact that it shows the ability to fill in the properties of the appropriate field automatically and additionally creates the relevant table relationships.

Now, with this clarified, we proceed to detail all the steps you have to carry out to create a search value list field through Access, correctly:

  • First of all, in the desktop program of Access, proceed to open the table in Design view, directly from the bottom of the panel.

Learn step by step how to create a List of Search Values ​​Field in Microsoft Access

  • Then, click on the cell in the column that says “Data Type” and that corresponds to the column you want to set as a search field. Furthermore, in Self-numbering, click on the down arrow and there, select the option “Search Assistant”.

Learn step by step how to create a Search Value List Field in Microsoft Access

  • As the Assistant for searches has the power to create three types of lists, you can choose any of the options that best suit your requirements. In this case, you will have to choose select “values”, instead of search and multivalued fields.
  • Then, in the wizard, click on “I’ll write the values ​​you want” and then click on “Next”.
  • Now, on the second page of the wizard, keep a column selected and proceed to enter multiple values (one in each row at the bottom of the header). For thus, click on “Next”.
  • Later, on the third page, select the option “Limit to list” found in “Do you want to limit the entries to the options?”.
  • Done all of the above, click on “Finish”. After this, you have to save the changes made and voila, you will have already set your search value list field to a table of Access.

If you have any questions, leave them in the comments, we will answer you as soon as possible, and it will surely be of great help to more members of the community. Thank you! 😉

You may be interested:

Rate this post

Leave a Comment