In MS Access, what field property constraint must be activated to ensure that users cannot leave a specific field blank when entering a new data record? MCQ with Answer and Explanation

In MS Access, what field property constraint must be activated to ensure that users cannot leave a specific field blank when entering a new data record?
A. Indexed field size
B. Validation Rule
C. Required
D. Input Mask properties
Answer: Option C
Solution (By JKSSB Mock Tests)
Setting the 'Required' field property to 'Yes' enforces a data validation constraint that prevents a record from being saved if that specific field is left blank or null.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
In Access, which of the following is a valid way to create a report?
A. Create > Report Wizard
B. All of the above
C. Create > Report Design
D. Create > Report

Correct Answer: Option B


Explanation:
All methods create reports.

This question belongs to: Computer Microsoft Office
Question #2
In Excel, the formula =INDEX(A1:C3, 2, 3) will return the value from:
A. Second row, third column of the range A1:C3
B. An error
C. Third row, second column
D. Cell B2

Correct Answer: Option A


Explanation:
INDEX(array, row_num, col_num) returns the value at intersection. 2nd row, 3rd column is cell C2.

This question belongs to: Computer Microsoft Office
Question #3
To go to the previous page in a Word document, press:
A. Alt + Page Up
B. Page Up
C. Ctrl + Page Up
D. Ctrl + Up Arrow

Correct Answer: Option C


Explanation:
Ctrl+Page Up moves to the top of the previous page. Page Up scrolls up.

This question belongs to: Computer Microsoft Office