North America LibreOffice Community DVD


Base module icon

 A Powerful Manager for All Databases


Base is a full-featured desktop database front end, designed to meet the needs of a broad array of users, for all kinds of uses, such as:

  • keeping track of collections of objects;
  • maintaining customer information databases;
  • maintaining student grade and curriculum databases;
  • storing survey information and experimentation data;
  • storing population and census data;
  • producing monthly financial reports in companies and organizations
  • managing audit, quality assurance and production data.


Base provides wizards to help users who are new to database design (or just new to Base) to create tables, queries, forms and reports, and it comes supplied with a set of predefined table definitions for tracking assets, customers, sales orders, invoices and many other commonly-useful items.

If you're looking for a database for single-user situations, Base comes configured with the full HSQL relational database engine. It's an ideal solution for uncomplicated needs, and for people requiring an easy-to-understand, simple-to-use system: the data is stored right inside the Base file, and you also get native support for dBase flat files.

Base also caters to power users and the enterprise requirements, providing native-support drivers for some of the most-widely employed multi-user database engines: MySQL, Adabas D, MS Access and PostgreSQL. In addition, the built-in support for JDBC- and ODBC-standard drivers allows you to connect to virtually any other existing database engine.

Base is much more than a tool that can be used for stand-alone purposes. It is also perfectly integrated with the LibreOffice suite's other applications.

For example:

  • Base can supply address book data for mail merges in Writer, using the industry-standard LDAP protocol, or using commonly-seen address book formats such as Microsoft Outlook, Microsoft Windows and Mozilla;
  • Base can be used for creating linked data ranges in Calc files, for data pilot analysis or as the basis for charts.

Therefore, although the Base database front end is a powerful asset in itself, it also adds major functionality, and potential, to the other LibreOffice applications. If used in conjunction with the macro programming capability, that is also incorporated in each LibreOffice component, you have usage possibilities that are almost only bounded by your imagination.