Page 39 - ModularV1.1 _c8_flipbook
P. 39

SEARCHING RECORDS

                 Suppose you have more than one thousand records in your table. If you need a particular
                 record, then it is very difficult to search the record manually. MS Access allows you to search
                 a particular record in a table easily by using the Find command. Follow these steps to search
                 a record in a table:

                 Step 1  Click on the Find command under the Find group of the Home tab. The Find and Replace
                         dialog box appears.







                                                           Searching a record

                 Step 2  Type the value that you want to search in the Find What textbox.
                 Step 3  Click on the Find Next button. The typed value is highlighted in the table if it exists.












                                  Find and Replace dialog box                                       Searched record

                  Tech


                    Funda
                                   You  can  also search  a  value  by  using the  Search  textbox  besides the
                                   Navigation buttons at the bottom on the MS Access window.






                     SORTING RECORDS

                 Sorting is the process of arranging data alphabetically
                 either in ascending or descending order. Perform the
                 following steps to sort the data in a table:
                 Step 1  Select the field according to which you want to
                         sort.

                 Step 2  Click  on  the  down-arrow  next  to  the  field
                         name. A drop-down list appears.
                 Step 3  Select the Sort A to Z or Sort Z to A option
                         to sort data in ascending or descending order.

                         The data gets sorted accordingly.                              Sorting the records


                                                                                  Advanced Features of MS Access   37
   34   35   36   37   38   39   40   41   42   43   44