Page 41 - ModularV1.1 _c8_flipbook
P. 41

Tech


                    Funda
                                   You can also remove the filter by clicking on the Filter icon from the Sort &
                                   Filter group of the Home tab.


                 Using Custom Filter

                 Custom  filter  allows  you  to  filter  data  according  to  particular  criterion.  MS  Access  provides
                 different criteria from which you can choose according to your requirement. Follow these steps

                 to use custom filter:
                 Step 1  Click on the column header on which you
                         want to apply custom filter.

                 Step 2  Click on the down-arrow next to the
                         column name.  A drop-down list appears.

                 Step 3  Hover the mouse  on the  Text Filter
                         option. A list of criteria appears.
                 Step 4  Select the desired criteria. In this case, we               Using custom filter
                         have selected Begins With criteria. The Custom Filter dialog box appears.

                 Step 5  Type the desired value in the textbox. In this case, we have typed M.

                 Step 6  Click on the OK button. The filtered data appears.







                                Custom Filter dialog box                 Filtered data
                     IMPORTING DATA FROM OTHER APPLICATIONS

                 Importing data means to access the data from other applications to MS Access. MS Access allows

                 to import data from different types of files like text file, MS Excel file, HTML file and another
                 database. Perform the following steps to import data from a MS Excel file:
                 Step 1  Open a database in MS Access and click on the Excel command under the Import &
                         Link group of the External Data tab. The Get External Data - Excel Spreadsheet dialog
                         box appears.

                 Step 2  Click on the Browse button. The File Open dialog
                         box appears.

                 Step 3  Select  the  MS  Excel  file  from  which  you  want  to
                         import the data. In this case, we have selected the
                         Student Record file.                                               Importing data



                                                                                  Advanced Features of MS Access   39
   36   37   38   39   40   41   42   43   44   45   46