Designing a Relational Database Answers

Which join type will only include rows where the joined fields from both tables are equal?

3. In the Show Table dialog box, add .

6. Click to see the results.

5. If there is no relationship between the tables, you can one.

Which records would be returned in a query based on an inner join between a table named Customers and a table named Orders? Check all that apply.orphaned ordersorphaned customerscustomers who placed orderscustomers who did not place ordersorders that are attached to customersorders that are not attached to customers

Which situation would most benefit from an outer join?

1. Click the tab.

What is required for joining two unrelated tables?

Which scenario would most benefit from a self-join query?

What is a subdatasheet?

2. Click the tab, and in the Records group, click .

What is the definition of a query join?

2. Click the tab, and in the Records group, click .

4. In the Insert Subdatasheet dialog box, select the table you want and click .