• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 5. Working with Tables > Managing Columns in Datasheet View

Managing Columns in Datasheet View

You can quickly add, remove, and rename columns from within Datasheet view. If you remove a column, Access deletes all the data it contains, so delete a column only if you are sure you no longer require its data. If other database objects contain references to a deleted field, such as a query, Microsoft automatically updates those references.

Insert a Column

In Datasheet view, right-click the column selector to the right of where you want to add the new column.

Click Insert Column.

The column is inserted with the name Field1, which you can rename.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint