In MS Access, which of the following is not a valid field property? MCQ with Answer and Explanation

In MS Access, which of the following is not a valid field property?
A. Sort Order
B. Caption
C. Format
D. Field Size
Answer: Option A
Solution (By JKExamLibrary)
Field properties include Field Size, Format, Caption, Default Value, etc. Sort Order is not a field property; sorting is applied in queries or tables via the Sort row.

This question belongs to: Computer Microsoft Office

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1 Report Error
Which shortcut is used to increase the font size in MS Excel?
A. Ctrl + >
B. Alt + >
C. Ctrl + Shift + > (or Ctrl + ])
D. Ctrl + Shift + .

Correct Answer: Option C


Explanation:
Same as Word, Ctrl+Shift+> or Ctrl+].

This question belongs to: Computer Microsoft Office
Question #2 Report Error
In MS Word, to add a border to a page, go to:
A. Layout -> Borders
B. Home -> Borders
C. Insert -> Borders
D. Design -> Page Borders

Correct Answer: Option D


Explanation:
Page Borders is under Design tab.

This question belongs to: Computer Microsoft Office
Question #3 Report Error
In MS Access, what type of table relationship layout is formed when a single record in Table A matches multiple records in Table B, but a record in Table B matches only one record in Table A?
A. Self-Referential database link
B. Many-to-Many Relationship
C. One-to-Many Relationship
D. One-to-One Relationship

Correct Answer: Option C


Explanation:
A One-to-Many relationship is the most common relationship type in relational databases, where a primary key record in one table links to multiple foreign key records in another table.

This question belongs to: Computer Microsoft Office