In Microsoft Access, you can add records to an existing table that already as data and resize the columns that contain the fields and data.

1] How to Freeze columns in Microsoft Access In Microsoft Access, there are two methods to freeze a column or field. Method 1 is to click the header of the column or field you want to freeze.