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

Question

Share Report Error

In MS Access, the 'Allow Zero Length' property is used for:

A. Date fields to allow null

B. Number fields to allow zero

C. Yes/No fields to allow unchecked

D. Text fields to permit an empty string ('')

Answer: Option D

Solution (By JKSSB Mock Tests)

Allow Zero Length, when set to Yes, allows a text field to contain an empty string distinct from Null.

This question belongs to: Computer Microsoft Office

Request complete Subject PDF

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1

Share Report

In MS Word, which reference tool places short citations at the bottom boundary of the same page where a number indicator reference was added?

A. Caption index

B. Footnote

C. Endnote

D. Bibliography

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Footnotes reside at the bottom base of the active page. Endnotes are compiled at the end of the entire document.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

What is the default file extension of a macro-enabled PowerPoint presentation?

A. .ppsm

B. .pptx

C. .potm

D. .pptm

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
.pptm is macro-enabled presentation. .ppsm macro-enabled show.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In Excel, which function is used to find the position of a substring within a string?

A. Both A and B

B. FIND

C. SEARCH

D. POSITION

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
FIND and SEARCH both return the position of a substring; FIND is case-sensitive, SEARCH is not. Both are valid.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs