Another useful manipulation of the field columns in an Access table that can make data entry easier is freezing a column. For example, if a table has a large number of fields, as you move to the right in the table during data entry, fields in the beginning of the table scroll off the screen. This can be very annoying if you lose your place, because you might not remember which customer you were entering data for.
You can freeze columns so that they remain on the screen even when you scroll to the far right of a table record. Follow these steps:
You can freeze multiple columns if you want, such as the Last Name field and the First Name field. When you want to unfreeze the column or columns in the table, select the Format menu, and then select Unfreeze All Columns .