Most tables have so much information that it won’t all fit on the same screen. To overcome this problem, you can freeze a column. This allows you to compare the frozen column’s information with other columns that wouldn’t otherwise appear on the screen at the same time.
Click the header for the column you want to unfreeze.
Click the More button on the ribbon.
Select Unfreeze All Fields.
Access unfreezes the column.
Once you unfreeze a column, you'll have to move it back to its original position, if desired. Or, simply choose not to save changes when you close the table—when you reopen it, the columns will be in their previous positions.