Manipulating Table Columns and Rows

When you refine a table’s structure by adding fields and changing field properties in Design view, you are affecting the data that is stored in the table. But sometimes you will want to adjust 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 columns 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 in any way affecting the underlying data. You can size both rows and columns, and you can also ...

Get Microsoft® Office System Step by Step -- 2003 Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.