Page 12 of 13PREVNEXT

Queries VII: Query multiple sources for data

Test yourself

Complete the following test so you can be sure you understand the material. Your answers are private, and test results are not scored.


In a query, the tables in your record source must be directly related by primary and foreign key fields.

True.

False.

An inner join returns:

Only records from both sides that match.

All records from the left side of the join, and only matching records from the right side.

All records from the right side of the join, and only matching records from the left.

In a right outer join, the table on the right side of the join is called:

The right-outer table.

The base table.

The secondary table.

In a query, the association between fields in two sources is called:

A link.

A one-to-many relationship.

A join.

A right outer join returns:

Only records from both sides that match.

All records from the right side of the join, and only matching records from the left.

All records from the left side of the join, and only matching records from the right side.

Page 12 of 13PREVNEXT