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:

Public Water

Public water refers to the supply of water provided by government or municipal bodies to communities for drinking, washing, and other domestic purposes.

Land-Use Control

Regulations and policies governing how land can be used or developed, often to manage natural resources or control urban expansion.

Conservation Easements

Legal agreements that permanently limit uses of land in order to protect its conservation values, used by landowners to preserve natural or historic resource values.

Subsidizing Farmers

The practice of providing financial assistance to farmers by the government to encourage agricultural production and ensure food security.