Microsoft® Office Access™ 2007 Plain & Simple

Manipulating Columns

You can change how data is displayed in your datasheet by changing the order of the table’s columns. You can also add or delete fields by inserting a column (which creates a new field) or deleting a column (which deletes the field it represents). If you want to copy the contents of a column to another table, or even to another Office document, you can do so easily.

Relocate a Column

1. Click the column head of the column you want to move.

2. Drag the column to its new position in the datasheet. A vertical black line appears on the edge ...