When a relationship is created,what kind of join does Access assign?
A) inner join
B) left outer join
C) right outer join
D) none of the above

Question

Quizplus · Accepted Answer

When a relationship is created, Access assigns an inner join by default. This means that only records with matching values in both tables will be included in the query result. This is usually the most appropriate type of join, as it ensures that the query only returns relevant and accurate data. Left and right outer joins may be necessary in some cases, but should be used sparingly and only when the specific needs of the query require it.

When a Relationship Is Created,what Kind of Join Does Access