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

Hiding and Unhiding Columns

            In   ase   column field can be hidden to provide security. For example  suppose you are working with a
            student table and you don t want to show the  O  details of students.  iding the column fields of  O  will
            solve this problem.  iding a column temporarily hides the column from the screen.  o hide a column field:

            Step 1:  Open the table by double-clicking the table name from the  able  ane.  he table opens in   able
                     ata  iew  window.

            Step 2:   ight-click the mouse on the column field header to select and hide the column field.  Field selector
                    will select entire column in a  right-click .
                     he background colour of the selected field changes to blue and a menu option list opens with three
                    options   olumn Format     olumn  idth  and   ide  olumn .

























            Step 3:   lick  on  the  option    ide   olumn   to  hide  the  selected  column field.   he  selected  column field
                    disappears from the screen and all fields present after the hidden field are shifted one column to the
                    left side on the screen.
























            Step 4:   o unhide the columns which are hidden in a table  right-click on the field heading of any field. Select
                    the option  Show  olumn  from the menu option list.

            Step 5:  Select the field name to unhide or click on   ll  option to unhide all hidden fields.  he hidden columns
                    fields get displayed again.




                                                                                  Database Management          261
   258   259   260   261   262   263   264   265   266   267   268