to select from previous values
to select values from Excel Sheet
to select value from another table
Not a valid Data Type
Answer is Right!
Answer is Wrong!
The correct answer is: C. to select value from another table.
The Lookup Wizard is a tool in Microsoft Access that allows you to create a lookup field in a table. A lookup field is a field that displays a list of values from another table or from a list of values that you create. When you enter a value in a lookup field, Access automatically fills in the corresponding value from the other table or list.
The Lookup Wizard can be used to create lookup fields in tables that are used in forms and reports. It can also be used to create lookup fields in tables that are used in queries.
To use the Lookup Wizard, follow these steps:
- In the table that you want to create the lookup field in, right-click the field that you want to make a lookup field, and then click Lookup Wizard.
- In the Lookup Wizard dialog box, on the Choose a Source page, select the table or list that contains the values that you want to use in the lookup field.
- If you want to use a list of values that you create, select the Create a new list option, and then type the values in the List Values box.
- On the Choose a Primary Key page, select the primary key field for the table or list that you selected in step 2.
- On the Finish page, click Finish.
Access creates the lookup field and adds it to the table.
The following are the possible options for the question:
- A. to select from previous values: This option is incorrect because the Lookup Wizard does not allow you to select values from previous values.
- B. to select values from Excel Sheet: This option is incorrect because the Lookup Wizard does not allow you to select values from an Excel sheet.
- C. to select value from another table: This option is correct because the Lookup Wizard allows you to select values from another table.
- D. Not a valid Data Type: This option is incorrect because the Lookup Wizard is a valid data type.