Which of the following statement is correct about the Lookup Field?Group of answer choicesLook up field provides a user with indefinite suggestions to help enter dataLookup Wizard can only be used with a set of predefined lookup tabels provided with MS Access, or downloaded and installed as add-onsNonesense, there is no lookup field in AccessLookup Wizard helps you create the lookup field
Question
Which of the following statement is correct about the Lookup Field?Group of answer choicesLook up field provides a user with indefinite suggestions to help enter dataLookup Wizard can only be used with a set of predefined lookup tabels provided with MS Access, or downloaded and installed as add-onsNonesense, there is no lookup field in AccessLookup Wizard helps you create the lookup field
Solution
The correct statement about the Lookup Field is "Lookup Wizard helps you create the lookup field".
Here's why:
-
"Look up field provides a user with indefinite suggestions to help enter data" - This statement is incorrect. A lookup field does not provide indefinite suggestions. It provides suggestions based on the data source it is linked to.
-
"Lookup Wizard can only be used with a set of predefined lookup tables provided with MS Access, or downloaded and installed as add-ons" - This statement is incorrect. The Lookup Wizard can be used to create a lookup field that pulls data from a table or query in the current database, not just from predefined lookup tables.
-
"Nonsense, there is no lookup field in Access" - This statement is incorrect. There is indeed a lookup field in Access. It's a field that allows users to select a value from another table or from a list of values by using a combo box.
-
"Lookup Wizard helps you create the lookup field" - This statement is correct. The Lookup Wizard is a tool in Access that guides you through the process of creating a lookup field.
Similar Questions
Which of the following is true about Forms in Access?Group of answer choicesIt cannot be used to based on a queryIt cannot be used for inputing and viewing of DataIt can be used to view, add, delete or modify data in tablesIt does not exist in Access
Which of the following is NOT possible with VLOOKUP?*You can lookup values located in a different worksheet.You can lookup values located in a column to the right of the column that contains the lookup value.You can lookup values located in a column to the left of the column that contains the lookup value.You can lookup values such as text, numbers or characters.
The Excel function HLOOKUP looks up a value in the top row of a table and returns a value in the same column from a row you specify. Group of answer choicesTrueFalse
Which of the following is true about queries in Access?Group of answer choicesIt is used to display data as a visual presentation suitable for printingIt is a collection of raw data for storageIt is not an objectIt is a search performed on a set of data
challenges associated with using lookup tables
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.