Question

Explain the term criteria when building a query.

Answer 1

Answer:

A criteria in query is used to compare to query field values so as to determine whether to include the record that contains each value.

Explanation:

A criteria in query is used to compare to query field values so as to determine whether to include the record that contains each value. Query criteria is used to limit the result from a query retrieving only specific items.

Only when an item matches all the criteria can it be shown as a query results. Query criterias can be simple making use of basic operators and constants while some may be complex, and use functions, special operators,.