If the list values are numbers, then they would not be enclosed in quotes. The column width may also be changed, for example to allow longer entries. Note that the list may easily be edited the different values are separated by semi-colons.

This setting allows the user to enter a value not included in the list, and then specify that it should be added to the list, effectively editing the table design not good practice. If “Limit To List” is set to “Yes”, then “Allow Value List Edits” should be set to “No”. On selecting the “Lookup” tab, the following settings are shown: It is then necessary to set the field size to 9, this being the length of the longest entry (“Associate”). When “Finish” is selected, the user is returned to the table in Design view.

It may be that the “best of both” approach is needed the convenience of selecting from a list of the most likely values combined with the flexibility of entering a value manually if the required value is not in the list (for example Dr.

As such, it is one of Access’s data integrity checks. “Limit To List” would prevent the user from entering a value that is not in the list. The last stage of the wizard includes options to limit the user to selecting from the list and whether multiple values can be selected: In the next stage the list of possible values is entered: It may be entered manually by the user, or drawn from a separate table or query: The first stage in the wizard consultation is to ask what the source of the list is. In choosing this, we are telling Access that the possible values are to be drawn from a list. The data type of Grade is set to “Lookup Wizard”, automatically launching the Microsoft Access Lookup Wizard.

The Employees table is opened in Design view, and the new field inserted: This may be one of the following: Senior, Associate, Junior, Trainee. Suppose we have a table containing data about our employees, and wish to add a field storing their grade. If applied to a foreign key field, then it may create the appropriate table relationship. The lookup wizard may be applied to text and numeric fields, the latter including dates. This may be either if the field is a foreign key (in which case the appropriate value is usually drawn from the list of values in the matching primary key) or some non-key field such as Title of Courtesy, which may be restricted to Mr, Miss, Mrs etc. It appears as one of the field data types, and is used for fields which have a restricted list of possible values. The Microsoft Access Lookup Wizard is a very useful feature.

Query wizard in microsoft access