2007 Microsoft® Office System Step by Step

Manipulating Table Columns and Rows

When you refine a table’s structure by adding fields and changing field properties, you affect the data that is stored in the table. But sometimes you will want to reorganize the table itself to get a better view of the data. If you want to look up a phone number, for example, but the names and phone numbers are several columns apart, you will have to scroll the table window to get the information you need. You might want to rearrange or hide a few columns to be able to see the fields you are interested in at the same time.

You can manipulate the columns and rows of an Access table without affecting the underlying data in any way. You can size both rows and columns, and you can also hide, move, and freeze columns. ...