Question

In Query Design view for the ClientsByState query, add ST as a caption for the State field.

a. Click the State field > (Query Tools) design > (Show/Hide) > Property Sheet > Click Caption text box > Type: ST > ENTER
b. Click the State field > (Query Tools) design > (Show/Hide) > Caption text box > Type: ST > ENTER
c. Click the State field > (Query Tools) > Design > Property Sheet > Caption text box > Type: ST > ENTER
d. Click the State field > Property Sheet > Click Caption text box > Type: ST > ENTER

Answer 1

To add a caption 'ST' for the State field, use the Query Design tools to access the Property Sheet and enter 'ST' into the Caption text box, followed by pressing ENTER.

Step-by-step explanation:

To add a caption ST for the State field in the Query Design view for the ClientsByState query, the correct steps would be: Click on the state field. Navigate to (Query Tools) Design. Go to (Show/Hide) and select the property sheet. In the Property Sheet, click the Caption text box. Type: ST.

Press ENTER. These steps add a custom label to the State field when you run the query, making the field header display 'ST' instead of 'State'. In the Query Design view for the ClientsByState query, the correct steps to add ST as a caption for the State field are as follows: Click the State field Go to (Query Tools) Design. Click on Show/Hide. Select the property sheet. Click on the Caption text box and type: ST. Press ENTER. The correct option is d. Click the State field > Property Sheet > Caption text box > Type: ST > ENTER.