Identify a true statement about working with related data in a subdatasheet in Microsoft Access 2016.
A)When the primary table is opened, the subdatasheet for each record in the primary table is collapsed until it is expanded by clicking the expand button.
B)After a one-to-many relationship between tables with a common field is defined, the Subdatasheet is present only in the secondary table in the relationship.
C)The subdatasheet does not display related records.
D)Records in subdatasheet cannot be deleted.

Question

Identify a true statement about working with related data in a subdatasheet in Microsoft Access 2016. ​
A)When the primary table is opened, the subdatasheet for each record in the primary table is collapsed until it is expanded by clicking the expand button.
B)After a one-to-many relationship between tables with a common field is defined, the Subdatasheet is present only in the secondary table in the relationship.
C)The subdatasheet does not display related records.
D)Records in subdatasheet cannot be deleted.

Quizplus · Accepted Answer

Subdatasheets in Microsoft Access 2016 automatically show related data in a collapsed form for each record in the primary table. Users can expand these to view related records by clicking the expand button. This feature allows for easier navigation and understanding of relationships between tables.

Identify a True Statement About Working with Related Data in a Subdatasheet