Microsoft Access does not create N:M relationships because ________.
A) Microsoft Access creates databases based on database designs instead of data models.
B) Microsoft Access creates databases based on data models instead of database designs.
C) Microsoft Access cannot implement association relationships.
D) Microsoft Access cannot implement supertype/subtype relationships.
E) Microsoft Access cannot implement recursive relationships.

Question

Quizplus · Accepted Answer

Microsoft Access does create N:M (many-to-many) relationships, but it does so by using a junction table to break down the N:M relationship into two one-to-many (1:N) relationships. The statement in choice A is incorrect because Microsoft Access does indeed create databases that can be based on both database designs and data models, including the implementation of various types of relationships such as association, supertype/subtype, and recursive relationships. The correct answer is chosen because it is the only option that directly addresses a misconception about Microsoft Access's capabilities regarding relationship creation, albeit in a misleading way by suggesting Access does not create N:M relationships due to a preference for database designs over data models, which is not accurate.

Microsoft Access Does Not Create N:M Relationships Because ________