Sunday, July 2, 2017

Microsoft Access : How to add, rename and delete a field in Datasheet view



How to add a field in Datasheet view :
  1. On the Table Tools Fields tool tab, in the Add & Delete group, click the data type for the field you want to insert. Click More Fields to display an extended list of data types.
  2. In the column heading row, enter a name for the field.
How to  rename a field in Datasheet  view :
  1. Right-click the column heading for the field, and then click Rename Field.
  2. In the highlighted area, enter the new name for the field .
How to delete a field in Datasheet view :
  1. Right-click the column heading for the field, and then click Delete Field.
  2. Click Yes in the prompt that Access displays to confirm that you want to delete the field.

No comments:

Post a Comment