Page 43 - Computer - 8
P. 43

To remove sorting from records:

            1.  On the Home tab, click the Remove Sort button in the Sort
                & Filter group.
                 Access removes sorting from all the records and displays
                the datasheet in its original state.


          Searching for Data                                                               1
          Access provides a Search box to quickly search for specific data or records in a table.

          To search for data:
            1.  Click in the Search box at the bottom of the Work area and type the data you want to search for.


                                                                                                     1

                 Access highlights the corresponding characters in the first record that matches your search data.

            2.  Press the Enter key to move to the next matching record.
            3.  Delete the data from the Search box to end the search.


          Exiting Access

          You should exit Access once your work is finished.                               Time Saver
          To exit Access:                                                                   Exit  Access: CTRL + F4.

             •  Click the Close     button in the Title bar.

          DESIGN VIEW IN ACCESS

          The Design view allows you to design the structure of a table in a better and controlled way. It lets you
          add fields to a table, specify the data types, and add descriptions for the fields. You can also set the
          Primary key and various properties for the fields.

          Opening a Table in Design View
          To open a table in the Design view:

            1.  Open the table in the Datasheet view.





                       2


                       1












                                                                                                              41
   38   39   40   41   42   43   44   45   46   47   48