This chapter illustrates how to create a simple database from scratch.
As an example, let us create a simple book database.
Creating New Database
To create a new database, click the New Database tab on the welcome screen or select File > New... from the main menu:
The form editor is a key tool in database creation. It allows creating new forms and editing already existing ones. To access it, as well as other database editors, use the Design DB menu:
Let us open it and edit the form according to our requirements:
The interface of the form editor is fixed and can be divided into the following parts:
Let us delete unnecessary fields 'Year', 'ISBN', 'Notes' and their labels. To do this:
The form will take the following shape:
We want to add the following fields - 'Acquisition Date', 'Cost' and 'Location' - to memorize where the book is located.
To add a field:
Newly added elements will appear on the form:
Element properties are distributed over 8 tabs. The content of 7 tabs is the same for all elements (color, font, tooltip, scripts and so on). The first tab 'Individual Properties' is unique for every field type and allows setting its specific properties, for example:
You can create labels for fields as well as fields themselves (by selecting the 'Label' element on the palette of elements). But it is easier and faster to make it via the menu of an element:
Therefore, our field will take the following shape:
Close the form editor. You will see that the record in the database has been changed. So, we learned how to edit forms and create simple fields. In a similar manner, you can add images, buttons, flags, relational fields on the form and so on.
Copyright (C) 2001-2010 Binary Brilliant Inc. All Rights Reserved.