Microsoft Office Professional 2010 Step by Step eBook

Manipulating Table Columns and Rows 807

The Unhide Columns dialog box opens.

You can select and clear check boxes to control which fields are visible.

Tip If you want to hide several columns that are not adjacent, you can display the

Unhide Columns dialog box and clear their checkboxes.

9. In the Unhide Columns dialog box, select the FirstName check box, and then
   click Close.
   Access redisplays the FirstName field.


10. If you can see all of the fields in the table, for the purposes of this exercise, adjust
    the size of the program window until some of the fields are no longer visible.


11. Point to the CustomerID field name, hold down the mouse button, and drag through
    the FirstName and LastName field names. With the three columns selected, click the
    More button in the Records group, and then click Freeze Fields.


12. Scroll the page to the right until the Phone field is adjacent to the LastName field.

The first three columns remain in view as you scroll.

13. In the Records group, click More, and then click Unfreeze All Fields to restore the
    fields to their normal condition.
    Tip The commands to hide, unhide, freeze, and unfreeze columns are also available
    from the shortcut menu that appears when you right-click a field name.