Page 40 - ModularV1.1 _c8_flipbook
P. 40
Tech
Funda
You can also sort data by using the Ascending and Descending
commands from the Sort & Filter group of the Home tab.
APPLYING FILTERS IN A TABLE
Filtering means to select specific data from the given set of data. MS Access also allows you to
filter unwanted data from a set of data. Perform the following steps to apply filter on a table:
Step 1 Click on the column header on which you
want to apply filters.
Step 2 Click on the down-arrow next to the column
header. A drop-down list appears. By default,
MS Access displays all the records of the
selected column with selected checkboxes
in front of them.
Step 3 Deselect the checkboxes of the records
that you want to hide from the result and
click on the OK button. Only the selected Applying filter
records will appear.
Result after filtering
Tech
Funda
You can also apply filter by using the Filter command from the Sort &
Filter group of the Home tab.
Removing Filter
To remove the applied filter, follow these steps:
Step 1 Click on the down-arrow next to the column header on
which you have applied filter. A drop-down list appears.
Step 2 Select the Clear filter from ITEM_ID option. Where,
ITEM_ID is the column name that might be changed
according to your column name. The filter gets removed
from the table and all the records will appear.
Removing filter
38 Modular (Ver. 1.1)-VIII

