The correct answer is: C. Write criteria values in same field separated with AND.

To achieve AND effect when you are entering criteria in a query design window, you need to write the criteria values in the same field and separate them with the AND operator. For example, if you want to find all records where the ProductID is 1 and the Quantity is greater than 10, you would enter the following criteria in the ProductID field:

  • ProductID = 1 AND Quantity > 10

You can also use the OR operator to combine multiple criteria. For example, if you want to find all records where the ProductID is 1 or the Quantity is greater than 10, you would enter the following criteria in the ProductID field:

  • ProductID = 1 OR Quantity > 10

The AND operator will return records that meet all of the criteria you specify. The OR operator will return records that meet any of the criteria you specify.

Here is a brief explanation of each option:

  • Option A: Write criteria values vertically one in a row. This will not achieve the AND effect because the criteria values are not in the same field.
  • Option B: Write criteria values horizontally. This will also not achieve the AND effect because the criteria values are not in the same field.
  • Option C: Write criteria values in same field separated with AND. This is the correct answer because it will achieve the AND effect.
  • Option D: Write criteria values in same field separated with &. This will not achieve the AND effect because the & operator is not a valid operator for combining criteria.