How can you link a table with another so that a field in current table will display values in drop down box from another table while entering data: A. Query Wizard B. Look up Wizard C. Form Wizard D. Report Wizard

The correct answer is: B. Look up Wizard

A lookup wizard is a tool that helps you create a lookup field in a table. A lookup field is a field that displays a list of values from another table. When you enter data into a lookup field, you can select a value from the list.

To create a lookup field, follow these steps:

1. In the table that you want to add the lookup field to, right-click the field where you want to add the lookup field, and then click Lookup Wizard.
2. In the Lookup Wizard – Step 1 of 3 dialog box, select the I want the lookup field to look up values in a table or list option, and then click Next.
3. In the Lookup Wizard – Step 2 of 3 dialog box, select the table that contains the values that you want to display in the lookup field, and then click Next.
4. In the Lookup Wizard – Step 3 of 3 dialog box, select the fields that you want to display in the lookup field, and then click Next.
5. In the Lookup Wizard – Step 4 of 3 dialog box, type a name for the lookup field, and then click Finish.

The lookup field will be added to the table. When you enter data into the lookup field, you can select a value from the list of values that is displayed.

The other options are incorrect because they are not tools that help you create a lookup field in a table.

• A. Query Wizard is a tool that helps you create a query. A query is a way to select data from one or more tables.
• C. Form Wizard is a tool that helps you create a form. A form is a way to enter and view data in a table.
• D. Report Wizard is a tool that helps you create a report. A report is a way to summarize data from one or more tables.