How do you create a many-to-many relationship in Access?
What will be an ideal response?
A many-to-many relationship between two tables is created by:
a. Creating a junction table. The junction table will have two foreign keys which are the primary keys to the two original tables.
b. Determining if you wish more fields in the junction table.
c. Forming two one-to-many relationships between the original tables and the junction table.
d. Populating the junction table.
Computer Science & Information Technology
You might also like to view...
The content found on each Ribbon tab is identical in all Microsoft Office applications
Indicate whether the statement is true or false
Computer Science & Information Technology
The ________ is an optional Ribbon tab that contains tools needed to work with ActiveX Controls
Fill in the blank(s) with correct word
Computer Science & Information Technology