How Do You Specify an Outer Join Between Two Tables

question 56

Multiple Choice

How do you specify an outer join between two tables?

• A) In the Relationships window,click the Modify Join button.
• B) In Query Design View,double-click the join line.
• C) Add the "outer" criterion to the query design grid.
• D) Change the order of the fields in the query design grid.

---

Definitions:

Ledger Accounts

Records within a ledger that summarize all the transactions related to a specific account, providing a complete record of financial transactions over the life of the account.

Net Income

The sum a company earns net of all expenses and taxes, deducted from its overall revenue.

Rent Revenues

Income earned by a company or individual from leasing property or other assets to tenants.

Fees Earned

represents revenue gained from providing services, distinct from goods sold, over a specific period.