• The Lookup Wizard establishes a table-to-table link. It generates a foreign key that points to another's primary key.
• Using a lookup field, you can find ('look up') values in one table and utilise them in another. A lookup field can be used to supply values for a dropdown list and make data entry in a field easier. Let's imagine you want a list of the 50 states of the United States so your users can select one from the list rather than typing its name. Set up a lookup field for the state name in Access using the Lookup Wizard.
• In Access, a relationship allows you to merge data from two separate tables. Each connection is made up of fields from two tables that have the same data.
• The type of relationship that Microsoft Access produces is determined by the definition of the linked fields: If only one of the connected fields is a primary key or has a, a one-to-many relationship is formed. If both of the connected fields are primary keys or have unique indexes, a one-to-one connection is formed.

Read More: How You Can Import A Sharepoint List in MS-Access?