Create new fields from Access's Datasheet view

If you've ever needed to create a table field on the fly while working in Datasheet view, you probably found switching to Design view and setting up the field a nuisance. There's a much quicker way to create a field from Datasheet view. Simply right-click on the column heading of the column you want immediately to the right of your new field. Then, choose Insert Column from the shortcut menu. Access creates a field with a name resembling "Field1" that you can  then immediately start entering data in. You can also use the shortcut menu to rename or delete the newly created field. You'll most likely want to go to Design view at some point to set the field's properties. However, depending on your reason for creating the field, you may find that creating it in the Datasheet view is more efficient for your immediate needs.

Access Index

Main Index