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.
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?
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.
No comments yet. Be the first to start the discussion!