Page 264 - IT 402 v2.0 class 10
P. 264

N ot e s

                                                                  table
                                                                                     ase
                                           width
                  One can ad ust the column width and row height of a table in OpenO ce  ase to make the data that is
                                                                a
                                                                                        to
                          ad ust
                                   column
                                                                         OpenO ce
                                the
                      can
                                                                       in
                  One
                                                                                                    data
                                                    row
                                                              of
                                                        height
                                                                                                        that
                                                and
                                                                                                            is
                                                                                           make
                  One  can  ad ust  the  column  width  and  row  height  of  a  table  in  OpenO ce   ase  to  make  the  data  that  is
                                                                                                the
                                                        default
                                                                        row
                                                                        row
                                                                     of
                                                               height
                                                                     of
                                                               height
                                                                                                 width
                                                                                                 width
                                                                                         column
                                                                                         column
                                                                                                          row
                                                                                                          row
                                                                                                      and
                                                                                                      and
                                                                               . 5
                                                                               . 5
                                                                            is
                                                                            is
                                                                                       he
                                                                                       he
                                                                                  cm.
                                                                                  cm.
                           the
                           the
                              field
                                   more
                              field
                  stored
                  stored
                  stored in the field more clearly visible.  he default height of row is  . 5 cm.  he column width and row
                        in
                        in
                                              visible.
                                              visible.
                                                      he
                                                        default
                                                      he
                                        clear
                                   more
                                        clear
                                            ly
                                            ly
                  height can be changed by dragging the mouse pointer over the column/row.
                  height can be changed by dragging the mouse pointer over the column/row.
                  height can be changed by dragging the mouse pointer over the column/row.
        Sorting Data
        Sorting means to arrange the data of a table in a particular order like in ascending or descending order.  here
        are two options for sorting records of a table   Sort  scending  and  Sort  escending .
        Step 1:  Open the table by double-clicking the table name from the Table Pane of database window.
        Step 2:   he table is opened in   ata  iew  window..
        To Sort Records in Ascending Order:
        Step 1:  Select the field and record  column and row  on which sorting is to be applied.
                For example  to sort the records in    SS.
        Step 2:   lick on the field     SS .  ll records with field     SS  gets highlighted.
        Step 3:   lick  on   Sort   scending   button  from  the  Standard   oolbar  to  sort  the  records  of  the  table  in
                ascending order of     SS .
         262       Touchpad Information Technology-X
   259   260   261   262   263   264   265   266   267   268   269