In MS Access, to specify that a field can only accept values between 1 and 100, set: MCQ with Answer and Explanation

In MS Access, to specify that a field can only accept values between 1 and 100, set:
A. Input Mask
B. Validation Rule = Between 1 And 100
C. Default Value
D. Required = Yes
Answer: Option B
Solution (By JKSSB Mock Tests)
Validation Rule restricts input.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
Which presentation view displays an adjustable multi-level textual list of slide contents for quick editing in MS PowerPoint?
A. Notes Page Layout
B. Outline View
C. Slide Sorter View
D. Reading Layout Mode

Correct Answer: Option B


Explanation:
Outline View isolates the text hierarchy from layout graphics, enabling rapid edits to presentation titles and bullet points.

This question belongs to: Computer Microsoft Office
Question #2
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. Attachment properties
B. Calculated Field choice
C. Lookup Wizard
D. Hyperlink Field Type

Correct Answer: Option C


Explanation:
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.

This question belongs to: Computer Microsoft Office
Question #3
What is the shortcut key to create a new presentation in MS PowerPoint?
A. Ctrl + N
B. Ctrl + M
C. Ctrl + O
D. Ctrl + S

Correct Answer: Option A


Explanation:
Ctrl + N creates a new blank presentation. Ctrl + M inserts a new slide. Ctrl + O opens a presentation. Ctrl + S saves.

This question belongs to: Computer Microsoft Office