To create a new table, do one of the following:
Click on Tables and then click the new button: .
Select New and then Table from the File menu.
The "New Table" dialog is displayed. This contains a Table Wizard option and a Blank Table option. The Table Wizard enables you to choose pre-designed fields from a selection of tables that come as part of the Ability system (the system database is called abdata.adb and is the equivalent of a database template). See Creating fields in a database using Table Wizard for more information on using Table Wizard.
Click on the Blank Table button. The "New table" design window is displayed.
The design window is where you create the structure of your table. This is the framework in which you will store your data, so it is worth spending time at this stage planning how you will use the table and deciding what fields you will need (see Planning field details).
Each table will contain one or more fields. For each field you need to assign
a name in Name (see Field names) and a data type in Type (see Field data types), these being compulsory.
In addition, each field can be given
an optional summary description in Description.
After setting these you can format a field to give it a caption (see Captions) and a default value, these being optional. The fields can also be formatted for such properties as width, validation, justification, number type, etc. depending on the data type of the field..
For full details of how to create the fields for a new table, see Creating fields in a database.