22.4k views
5 votes
Which option is most likely used to create many-to-many relationships in Access?

inner join
outer join
junction table
parameterized query

User Dremme
by
6.7k points

2 Answers

4 votes

Answer:

c

Step-by-step explanation:

User Chris Walton
by
6.0k points
3 votes

Answer:

Junction table.

Step-by-step explanation:

Junction table is most likely used to create many-to-many relationships in Access.

A many-to-many relationship comes into existence when one (1) or more items in a table has a relationship with one (1) or more items in another table. An example is the products in a customer order.

Many-to-many relationships provides users with critical and crucial information, they're the most commonly used table relationships in Access.

In order to represent a many-to-many relationship in Access, a third table should be created by the user, this is often referred to as the junction or linking table, which further disintegrate the many-to-many relationship into a two (2) one-to-many relationships.

User Vathymut
by
6.2k points