Insert columns into a table (ADP)

1. In the Database window, click Database Diagrams under Objects, click the database diagram you want to open, and then click Design on the Database window toolbar.
2. In your database diagram, select the table that you want to add new columns to.
3. If the table is not already in Column Properties or Custom View, right-click the table and choose Column Properties or Custom View from the shortcut menu.
4. Right-click a row in the table and select Insert Rows from the shortcut menu. A blank column row is inserted above the selected row.
   -or-
   Place the cursor in the first blank cell in the Column Name column.
5. In the Column Name column, type the column name in the cell. The Column Name is a required value.
6. Press the TAB key to go to the Data Type cell. This is a required value.

The default values for your database are added when you create a new column. Define other properties for the column as needed. You can change any of these values and set additional properties at any time according to the rules of your database.

1. In the Database window, click Tables under Objects, click the table you want to open, and then click Design on the Database window toolbar.
2. Right-click a row in the table and select Insert Rows from the shortcut menu. A blank column row is inserted.
   -or-
   Place the cursor in the first blank cell in the Column Name column.
3. In the Column Name column, type the column name in the cell. The Column Name is a required value.
4. Press the TAB key to go to the Data Type cell. This is a required value.

The default values for your database are added when you create a new column. Define other properties for the column as needed. To define any of the fundamental properties, enter the property value on the grid. To define any of the other properties, highlight the grid row describing that database column, then enter the property value in the appropriate control on the tab appearing under the grid.