Question

Use AutoFilter to filter the query results first to show only records where the value in the StaffID field is Mo and the value in the IncreaseType field is Merit.

a. On the drop-down list for StaffID, clear all checkmarks, check MO. On the drop-down list for increasetype, clear all checkmarks, check merit.
b. On the drop-down list for StaffID, clear all checkmarks, check MO. On the drop-down list for increasetype, clear all checkmarks, check promotion.
c. On the drop-down list for StaffID, clear all checkmarks, check Amy. On the drop-down list for increasetype, clear all checkmarks, check Merit.
d. On the drop-down list for StaffID, clear all checkmarks, check John. On the drop-down list for increasetype, clear all checkmarks, check Merit.

Answer 1

To filter query results for the StaffID value 'Mo' and IncreaseType 'Merit' using AutoFilter, option A is correct: Clear all selections and then check 'MO' for StaffID and 'Merit' for IncreaseType.

Step-by-step explanation:

To use AutoFilter to filter the query results to show only records where the value in the StaffID field is Mo and the value in the IncreaseType field is Merit, you should choose the following steps:

Therefore, the correct answer to filter the records based on these conditions is option A: On the drop-down list for StaffID, clear all checkmarks, check MO. On the drop-down list for IncreaseType, clear all checkmarks, check Merit.