A lookup wizard in Access is a tool for creating a lookup field. It provides the necessary steps and options for creating fields in tables of a database.
When using a lookup wizard, a person can choose a lookup field type. The field can either be simple or complex. Simple fields are used to store single values while complex fields store multiple values. The wizard provides all the necessary features, including tables, queries and options, such as Datasheet view and Design view, to allow one to create a lookup field effortlessly. A person can also change the width and the sort order of the fields for easy data entry.