Which data type field property option in MS Access lets you create a drop-down choice list that pulls options either from an existing table source or a hardcoded value set? MCQ with Answer and Explanation

Which data type field property option in MS Access lets you create a drop-down choice list that pulls options either from an existing table source or a hardcoded value set?
A. Calculated Field choice
B. Lookup Wizard
C. Attachment properties
D. Hyperlink Field Type
Answer: Option B
Solution (By JKSSB Mock Tests)
The Lookup Wizard establishes a lookup field that displays a clean dropdown list of choices derived dynamically from another database table reference or static list parameter.

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1
Which shortcut key inserts a page break in MS Word?
A. Ctrl + Shift + Enter
B. Ctrl + Enter
C. Alt + Enter
D. Shift + Enter

Correct Answer: Option B


Explanation:
Ctrl + Enter inserts a manual page break. Shift + Enter is a line break, Alt + Enter in Excel starts a new line in a cell.

This question belongs to: Computer Microsoft Office
Question #2
In MS Access, which object is used to create a formatted printout of data?
A. Report
B. Table
C. Form
D. Query

Correct Answer: Option A


Explanation:
Reports are designed for printing data in a formatted layout. Forms are for data entry, queries for retrieval, tables for storage.

This question belongs to: Computer Microsoft Office
Question #3
What is the result of the Excel formula =LEN("MS Excel 2026")?
A. 12
B. 11
C. 13
D. 10

Correct Answer: Option C


Explanation:
The LEN function counts all characters within a text string, including alphanumeric digits, spaces, and special symbols. "MS Excel 2026" contains exactly 13 characters.

This question belongs to: Computer Microsoft Office