Question

what is lookup wizard in ms access? ​

Answer 1

Answer:

The Lookup Wizard establishes a relationship between tables. It creates a foreign key that refers back to the primary key of another.

Explanation:

Hope it helps.

Answer 2

Answer:

The Microsoft Access Lookup Wizard is a very useful feature. It appears as one of the field data types, and is used for fields which have a restricted list of possible values. 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. The lookup wizard may be applied to text and numeric fields, the latter including dates. If applied to a foreign key field, then it may create the appropriate table relationship.