Freeze Columns in Access 2007
Source: Oleksiy Kovyrin
If the user want a column to stay put on the left in their Microsoft Access 2007 table, then they can freeze that column so it will stay in place. They can also freeze adjacent columns at the same time and unfreeze any columns that are frozen. Check out this webcast, to find out how to freeze columns in Access 2007.