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
   35   36   37   38   39   40   41   42   43   44   45