Create database with Openoffice Base
If you want to quickly create a database and don't want to use Microsoft Access and want to dig deep into your wallet, you can use OpenOffice Base. Of course, the program is very complex, but this practical tip should at least give you an introduction to database creation.
Create a database with OpenOffice Base
Using the database wizard when you start OpenOffice Base, you can either open an existing database or create a new one. You can also see how this works in the picture gallery.
- Leave the point at "Create new database" and click on "Next >>".
- You can keep the displayed settings and click on "Finish". Now you have to select the location and name of the database.
- Your database is now created. OpenOffice uses a database format that can be easily passed on, but is very space-intensive.
Create a table
Of course, your database makes little sense as long as it doesn't contain any tables. You can create a table from templates, but we prefer to build your own entirely. You can also see this process in the picture gallery.
- In the main window, which should have opened after you created the database, click "Create table in design view".
- In the table you can now define the different fields (columns) of your table. To do this, enter the name in the "Field name" column and select the type in the "Field type" column.
- First, we create an ID, i.e. a unique identification number for each data record that will later be inserted in the table. To do this, we enter "ID" as the name and "INTEGER" as the type. At the bottom of the field settings, we select "Yes" for "Auto value". A small key should now appear next to the "ID" field.
- We can define the remaining fields as desired. For an example, you can take a look at the picture gallery.
- Finally, click "Save" in the "File" menu above and enter a name for the table.
Insert data into the table
Finally, we want to insert data into the table directly via OpenOffice Base.
- In the main view of your database, double-click the name of your table.
- In the table view you can now enter data according to the table principle (see screen shot). Each column is one of the fields you created in the paragraph above.
- When you are finished, you can simply close the window, because the data record is saved automatically.
This practical tip shows you how to clean up the user interface in Microsoft's competitor Access.