Question

Which of the following statements correctly adds a criterion to the "ClientsByState" query in Design view to select only records where the State field value is TX?

A) SELECT * FROM ClientsByState WHERE State = 'TX';

B) FILTER ClientsByState BY State = 'TX';

C) QUERY ClientsByState WHERE State = 'TX';

D) ADD ClientsByState FILTER State = 'TX';

Answer 1

The correct statement to add a criterion to the "ClientsByState" query in Design view to select only records where the State field value is TX is: SELECT * FROM ClientsByState WHERE State = 'TX'.

Step-by-step explanation:

The correct statement to add a criterion to the "ClientsByState" query in Design view to select only records where the State field value is TX is:

A) SELECT * FROM ClientsByState WHERE State = 'TX';

This statement uses the SQL SELECT statement to select all fields (*) from the table ClientsByState, but only where the State field value is 'TX'.