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.

Repeat a Column in a Query Highlight a table in the table list, click "Create" and double-click "Query Design." Select a table for your query, choose "Add" and click "Close" when done.