To create a new table it is necessary to select the component “Tables” (or any table) in the navigation window and perform the command Edit+Add, a dialog box “Adding table” will be opened (figure 23-1).
Figure 23-1. Dialog box “Adding table”
The dialog box consists of three panes:
Table name – serves for adding a name of the table being created;
Fields – contains a list of fields. This pane which is empty at first will contain information about fields of the table being created later on, the buttons Up, Down permit the user to change the position of the selected field in the list, and the button Remove – to remove the selected field;
Field – serves for determining a name, type and attributes of the new field or change them for the field selected in the pane Fields.
For example, the sequence of actions necessary to create the table “List of Building Certificates” with the structure presented in table 23-3 should be the following:
Field name | Type | Indexed | Unique | Not empty |
Inventory Number | Integer | True | True | True |
Street | String | True | False | True |
Building Number | Integer | True | False | True |
Number of Storeys | Integer | False | False | True |
Total Inhabitants | Integer | False | False | False |
Area | Real | False | False | False |
Date of Last Repair | Date | True | False | True |
Is Municipal? | Boolean | True | False | True |
Table 23-3. Description of structure of table “List of Building Certificates”
select the component “Tables” in the navigation window and perform the command Edit+Add, a dialog box “Adding table “ will be opened;
enter the name of created table “List of Building Certificates (new)” in the field Table name;
enter the name of the first field “Inventory Number” in the field Name of the pane Field;
select the field type “Integer” in the drop-down list Type;
check the box Unique, boxes Indexed and Not empty will be checked automatically;
push the button Add. A field will be added to the description of table structure;
repeat the previous four items for the remaining fields specifying type and attributes according to table 23-3. As a result, description of table structure will be formed. At figure 23-1 a dialog box “Adding table” with filled in descriptions of all the fields is presented.
push the button OK. A table will be created. The dialog box “Adding table” will be closed and a line with the name of created table “List of Building Certificates” will appear in the list of tables of the navigation window;
The button Cancel in the dialog box “Adding table” serves for canceling table creation.
 |  |
