Question

Add a criterion to the YearsAsClient query to select only those records where the value is greater than 6 for the Years field. Then, run the query to display it in Datasheet view.

a. Click criteria cell for Years cell > Type: >6 > RUN!
b. Enter 'Years > 6' in the criteria cell > Click RUN!
c. Select Years > 6 from the dropdown menu > Execute!
d. Set Years field to >6 in criteria > RUN!

Answer 1

To filter the records in a database query for years of client value greater than 6, type ">6" in the criteria cell for the Years field and run the query.

Step-by-step explanation:

The question relates to modifying a query in a database application such as Microsoft Access. To add a criterion to the YearsAsClient query to select records where the Years field is greater than 6, the correct action would be:

• Click the criteria cell for the Years field.
• Type the expression ">6" (without quotes) into the cell.
• Run the query by clicking the RUN button or executing the command.

This process filters the dataset to only include records where the Years field value is greater than six, and when the query is run, it will display the results in Datasheet view.