Question

which command is used to turn on or turn off a filter in ms access

Answer 1

Answer:

Filtering is a useful way to see only the data that you want displayed in Access databases. You can use filters to display specific records in a form, report, query, or datasheet, or to print only certain records from a report, table, or query. By applying a filter, you are able to limit the data in a view without altering the design of the underlying object.

Since the view you get after you apply a filter contains only records with the values that you selected, the rest of the data remains hidden until you clear the filter.

There are several types of filters and some of them are easy to apply and remove. Access contains some common filters that are built into every view. The availability of filter commands depends on the type and values of the field.

For example, to view the records of people whose birthdays fall during a specific month, click the BirthDate column, on the Home tab in the Sort & Filter group, click Date Filters, and then select the required date period.

Filtering on a date field

1. The filters that are available to you depend on the data type in the selected column.

2. All Dates in Period filter ignores the day and year portion of the date values.

In this filtered view, you see only the records in which the month portion of the BirthDate field is set to April.

BirthDate filtered for April

1. The filter icon in the column header and the record navigator bar indicates that the current view is filtered on the BirthDate column.

2. In the datasheet view, when you hover, the mouse, over the column heading, you will see the current filter criterion.

Answer 2

Answer:

If you can’t find specific data in a worksheet, it may be hidden by a filter. For example, if you have a column of dates in your worksheet, that column may have a filter that restricts the values to specific months.

There are several options:

Clear a filter from a specific column

Clear all filters

Remove all filters

Clear a filter from a column

Click the Filter Applied filter icon button next to the column heading, and then click Clear Filter from <"Column Name">.

For example, the figure below depicts an example of clearing the filter from the Country column.

Explanation:

Hope this will help you.

Mark my answer as Brainlest !!!!!!!!!!!