Page 320 - TP_IT_V1.0_C10_flipbpookl
P. 320

The Confirmation dialog box opens.
              Step 4:  Click on the Yes button in the Confirmation dialog box to proceed with deleting the record.
                        You may select multiple records by using the Shift key (for records that are arranged adjacent to each other
                      to form a consecutive list) or Ctrl key (for records scattered at different places in a table) and then select the
                      Edit → Delete Record option from the Menu bar to delete multiple records at a time.

              Sorting the Data in the Table

              Sorting means rearrangement of the data either in the ascending order (smaller value to bigger value) or in the
              descending order (bigger value to smaller value). The records will be rearranged with respect to the sorted field.
              The steps to sort the table are as follows:
              Step 1:  Select the STUDENT table.
                      The STUDENT table opens in the Table Data View window.

              Step 2:   Click on the column header based on which you want sort the data. Let us sort the data based on the Name
                      column. So, click on the column header of the Name column, you will see the whole column is selected by
                      shading it with blue.
























              Step 3:   Click on the Sort Ascending button (  ) to sort data in ascending order. All the records will be rearranged in
                      the ascending order of the Name.
























                      OR
                        Click on the Sort Descending button (  ) to sort data in descending order. All the records will be rearranged
                      in the descending order of the Name.


                318   Trackpad Information Technology (Ver. 1.0)-X
   315   316   317   318   319   320   321   322   323   324   325