


Register the database: Clicking the radio button for registering the database.ĭata from any database file can be registered to LibreOffice. Here is a Web page that compares the two. The drop-down menu associated with this radio button has two choices: HSQLDB Embedded or Firebird Embedded. This Web page focuses on the first choice. The three choices in Step 1 of the Database Wizard:

By default, Base allows you to choose either an HSQL database or a Firebird one to create. The database system cannot be easily accessed by the end-user and requires little or no ongoing maintenance. The wizard is what allows you to create an Embedded database, open an existing one, or connect to one located on a server.Īn embedded database is integrated with an application, such as Base, that requires access to stored data. Many users may have to activate experimental features to enable Firebird Embedded in the Embedded Database drop-down menu in the Database Wizard. However, the replacement process has not yet come to fruition. NOTE: The Document Foundation wants to replace HSQL with Firebird. The Table Wizard is one of the easiest ways for database and LibreOffice Base beginners to create tables. Each row has a different record.Ī record is composed multiple fields, and contains all the data about a particular person, business, or item in a table. Each field contains a piece of data for a record. A field contains a specific piece of data that is part of a record. From tables, reports and forms are generated, and queries are performed.Ī table is organized into fields and records. Data is stored in them, and records are organized in them. Tables are the building blocks for databases. So this page will take you from clicking the new database item in a toolbar or menu through filling out the table wizard.

It also shows how to use the Table Wizard to create the first table in your database. This page demonstrates how to set up an embedded database in LibreOffice’s front-end database editor, Base.
