In MS Access, what does the 'Format' property of a field do? MCQ with Answer and Explanation

Question

Share Report Error

In MS Access, what does the 'Format' property of a field do?

A. Restricts data entry to a pattern

B. Controls how data is displayed, not how it is stored

C. Sets the maximum number of characters

D. Specifies the data type

Answer: Option B

Solution (By JKSSB Mock Tests)

Format property customizes display (e.g., date format).

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

In MS Access, what is the default data type for a new text field (Short Text)?

A. Short Text

B. Currency

C. Number

D. Memo

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
In Access 2013/2016, the default data type for a text field is Short Text (previously Text).

This question belongs to: Computer Microsoft Office

Question #2

In Excel, which function is used to calculate the median of a set of numbers?

A. MODE

B. AVERAGE

C. PERCENTILE

D. MEDIAN

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
MEDIAN returns the middle value.

This question belongs to: Computer Microsoft Office

Question #3

In Excel, the 'Sort & Filter' group is on which tab?

A. View

B. Home

C. Data

D. Formulas

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Data tab has Sort & Filter.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs