In MS Access, the “Lookup Wizard” is used to:

2019

In MS Access, the “Lookup Wizard” is used to:

Answer: A. select a value from another tableConceptA lookup field lets a user choose a displayed value while Access stores the bound value defined by the field’s row source. The Lookup Wizard configures…

  1. A.

    select a value from another table

  2. B.

    select values from an Excel sheet

  3. C.

    select from previous values

  4. D.

    None of these

Attempted by 33 students.

Show answer & explanation

Correct answer: A

Concept

A lookup field lets a user choose a displayed value while Access stores the bound value defined by the field’s row source.

The Lookup Wizard configures that row source from another table or query, or from an explicit list entered during setup, and sets the related field properties.

Application

Here the intended source-paper wording is “select a value from another table.” The wizard can read the display values from that table or from a query based on it, so this wording matches its standard table-based use.

Contrast

  • “Select values from an Excel sheet” describes importing or linking external spreadsheet data, not the Lookup Wizard’s table-field setup.

  • “Select from previous values” is not the wizard’s standard description: a value list must be explicitly supplied, while arbitrary earlier entries are not reused automatically.

  • “None of these” does not apply because the table-based action is explicitly supported.

Cross-check

Microsoft’s Lookup Wizard instructions begin with the choice to get values from another table or query and then ask the user to select that source.

Result

Therefore, the Lookup Wizard is used to select a value from another table.

Explore the full course: Uppsc Computer Operator Grade B

Loading lesson…