In MS Access, the 'Allow Zero Length' property is relevant for: MCQ with Answer and Explanation

In MS Access, the 'Allow Zero Length' property is relevant for:
A. All fields
B. Text and Memo (Long Text) fields
C. Date fields
D. Number fields
Answer: Option B
Solution (By JKSSB Mock Tests)
Only text-based fields.

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 used to create a relationship between tables?
A. Database Tools > Relationships
B. Create > Relationships
C. Home > Relationships
D. External Data > Relationships

Correct Answer: Option A


Explanation:
Relationships are managed from the Database Tools tab.

This question belongs to: Computer Microsoft Office
Question #2
In Excel, which function is used to calculate the payment for a loan based on constant payments and interest rate, but for a given number of periods?
A. NPER
B. PMT
C. RATE
D. PV

Correct Answer: Option B


Explanation:
PMT calculates the periodic payment. NPER calculates number of periods, PV present value, RATE interest rate.

This question belongs to: Computer Microsoft Office
Question #3
Which field property in an MS Access table designer window enforces a specific data entry pattern that users must follow, such as standard phone number formats?
A. Format constraint
B. Input Mask
C. Validation Rule
D. Required field size

Correct Answer: Option B


Explanation:
An Input Mask defines a strict formatting pattern constraint (such as placeholders for phone numbers or postal codes) that guides users during manual data entry.

This question belongs to: Computer Microsoft Office