English Query
How to add a field to a table
Include existing database
To insert a field in a table
- On the SQL tab, right-click the table to which a field is to be added and click Add Field.
- In the Field Name box, enter the field name.
Note Enter the name of each new field on a separate line.
- Select the Data Type.
- If the field is to have a caption, enter one in the Caption box.
- On the Basic tab, choose or enter the data type options.
Note The available options change with the data type selected.
- On the Advanced tab, choose or enter the options for allowing Null values, denormalization, and aggregation for the selected field.
See Also
Advanced Tab (Table/New Table Dialog Box)