The Access Query Design Grid Contains the ProductID, ProductName, and Rating

question 33

Multiple Choice

The Access query design grid contains the ProductID, ProductName, and Rating fields. How can you omit the Rating field from the query results but use it to set a criterion for the query?

• A)Delete the Rating field from the query design grid.
• B)Add a second copy of the Rating field to the query design grid.
• C)Clear the checkmark from the Rating field's Show check box.
• D)Change the query to an update query.