What Is the First Step in Creating a Query with a Self

question 22

Multiple Choice

What is the first step in creating a query with a self join in Query Design View?

• A) Display two field lists for the same table.
• B) Add the Join Type row to the query design grid.
• C) Remove all field lists from the upper pane.
• D) Establish a one-to-many relationship between two tables.

---

Definitions:

Raw Materials Inventory

Raw Materials Inventory is the stock of materials that are on hand and available for use in the production process.

Finished Goods Inventory

Products that have completed the manufacturing process and are ready to be sold to customers.

Weighted Average Cost

A method of calculating the cost of goods sold and ending inventory cost by taking into account the cost of goods purchased at varying prices.

Beginning Inventory

The value of a company's inventory at the start of an accounting period, used in calculating cost of goods sold.