What Must You Do Before You Can Create a Crosstab

question 50

Multiple Choice

What must you do before you can create a crosstab query that references more than one table?

• A)Run an append query to combine the records from the various tables.
• B)Run a make table query and use that as the source for the crosstab query.
• C)Make sure the relationships have been properly created in the Relationships window.
• D)Create a select query which includes the fields from the various tables you want included in the crosstab query.

---

Definitions:

Demand Equation

A mathematical representation of the relationship between the quantity of a good demanded and its price.

Supply Equation

A mathematical formula that represents the relationship between the quantity of a good supplied and its price.

Price Ceiling

A maximum price set by the government for particular goods and services that cannot legally be charged above to prevent prices from being too high.

Shortage/Surplus

Market scenarios where the demand for a product surpasses its available supply, leading to a shortage, or where the supply of the product is greater than its demand, resulting in a surplus.