OpenOffice is an excellent program for office, available for all operating systems. In this article we deal with OpenOffice Base, a form of OpenOffice for creating relational databases.
We will see how to create a phone book, and will be much easier than you might expect.
Opening OpenOffice Base then you'll see the interactive wizard for creating the database.
Once the wizard we will be asked where to save the database. Save and start to create the first tables.
At this point we select the button “Table” and the respective entry “Create Table in Design View“, with the following screen.
Space “Name field” will be inserted (coincidentally) the name you want to assign to the field, eg “name“, “surname“, “phone number“, and so on. Space “Type field” you will see a drop-down menu from which we can choose different types. For a database as simple as a phone book we will use only types “Text [VARCHAR]” and “Whole [INTEGER]“.
The first field in the table will be called “id“, each character stored in the phonebook will be assigned a unique number, in order to differentiate it from other.
We pay attention to the field “id“. The id is a unique identifier that we (compilers address book) we can not change. Sarà un Automatic incremental assigned directly by the computer. To assign these settings to field modify the parameters shown in the space below. “AutoValue” – “Yes“, and click on gray square the corresponding row (you will see a key) thus assigning a primary key field.
Once all the necessary fields and set the key to the first field “id” we just have to create a “outline view” for the insertion of data. Click on “Form” – “Use Wizard to create forms“.
Since we are interested all selectable fields, we import them in bulk. The wizard guides you through the possible configurations. The only trick I recommend is to point “5“, the voice “Arrangement of the main form” recommend choosing “In column – Fixed text to the left“. At the end of the wizard, this should be the result.
It might be handy to have a single window, as well as to the screen for data entry, also a rapid data visualization included. By clicking on “Show” – “Data Source” we are given this opportunity.
To search for a particular record, simply click on the appropriate button () and type the text to search.
Clearly there are many other ways to keep track of contacts, from the files in CSV format (Comma Separated Value), to the directories integrated into the mail programs (Thunderbird, Outlook, Evolution, etc..), to the directories integrated into the online services (Gmail, Hotmail, Yahoo! mail, etc..). An address book with OpenOffice Base is interesting primarily for the standard language the database (SQL), secondly to educational purposes. And’ much easier to understand in a practical way the operation of a database, rather than learning theory.