Question

you can specify the filter for a query in the design view in the:- a) Criteria Row
b) Condition Row
c) Criteria Pane
d) Condition Pane​

Answer 1

${\bigstar}$ANSWER${\bigstar}$

• On the Home tab, in the Sort & Filter group, click Advanced and then click Advanced Filter/Sort on the shortcut menu. Add the fields on which you want to filter to the grid. In the Criteria row of each field, specify a criterion.