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...

To select multiple notes to print, hold the ____________________ key while clicking the notes to print, open the Backstage view, click the Print tab, and then click the Print button to print notes.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

The ___________ event occurs when a form is in the process of closing, but before it has closed.

a. FormClosing b. FormClosed c. CloseForm d. Close

Computer Science & Information Technology

All of the following are key components of a web application EXCEPT:

A) database server. B) web server. C) processing-logic server. D) web browser

Computer Science & Information Technology

Which is not a motivation for “functionalizing” a program?

a) The divide-and-conquer approach makes program development more manageable. b) Software reusability—using existing building blocks to create new programs. c) Avoid repeating code. d) Execution performance—functionalized programs run faster.

Computer Science & Information Technology