Add a field to a table in Design view

1. Open the table in Design view.
   
   
2. To insert the field within the table, click in the row below where you want to add the field, and then click Insert Rows on the toolbar.

   To add the field to the end of the table, click in the first blank row.

3. Click in the Field Name column and type the name for the field, following Microsoft Access object-naming rules.
   
   
4. In the Data Type column, keep the default (Text); or click in the Data Type column, click the arrow, and select the data type you want.

   For information on selecting an appropriate data type, click .

5. In the Description column, type a description of the information this field will contain. This description is displayed on the status bar when adding data to the field and is included in the Object Definition of the table. The description is optional.
   
   
6. If you want, set field properties for the field in the bottom part of the window.

   How?

Note   If this is a linked table, you can't add a new field in the current database. If the linked table is a Microsoft Access table, you must open its source database to add a field. If the linked table is from another application, you must open the source file with that application to add a field.