In MS Access, what is the maximum number of fields in a table? MCQ with Answer and Explanation

In MS Access, what is the maximum number of fields in a table?
A. 255
B. 1,000
C. 64
D. 256
Answer: Option A
Solution (By JKSSB Mock Tests)
An Access table can have up to 255 fields.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
In MS Access, which data type stores a calculated value that depends on other fields?
A. Number
B. Memo
C. AutoNumber
D. Calculated

Correct Answer: Option D


Explanation:
Calculated data type creates a field whose value is computed.

This question belongs to: Computer Microsoft Office
Question #2
In Access, what is the purpose of the 'Validation Rule' property?
A. To format the field display
B. To define a relationship
C. To restrict the values that can be entered in a field
D. To set a default value

Correct Answer: Option C


Explanation:
Validation Rule limits the data that can be entered, e.g., >0. Default Value sets initial value, Format controls display, Relationship links tables.

This question belongs to: Computer Microsoft Office
Question #3
In MS Word, which key is used to delete text to the right of the insertion point?
A. End
B. Backspace
C. Insert
D. Delete

Correct Answer: Option D


Explanation:
Delete key removes the character to the right. Backspace deletes to the left.

This question belongs to: Computer Microsoft Office