Adding Columns to the Table

Select Insert>Column, click on the toolbar, or right-click on the table name and select Insert Column.

Similarly to when you create a new table, the column will have a default name, "NEWCOLUMN". Choose a new name (e.g. "REFNO" or "NAME") and press Enter. Note that column names can contain spaces.

The new name appears in the right-hand pane. Repeat this process for all the columns that you need. Note that Table Designer inserts the new column to the right of the current selection, so if you select a column, it inserts the new column to the right of the selected column; but if you select the table name, it inserts the new column as the first column in the list.

Note:
If you select a column in the left-hand pane, only that column will appear alongside the "Rows of" column in the right-hand pane.
If you select the table name, the right-hand pane shows all columns of that table.

When you’ve inserted the columns, your Table Designer should look something like this:

Important:
If you want to write data back to the database, one of your columns must map to REFNO or NAME. We recommend you use REFNO.