Libreoffice Access

Posted onby admin

In LibreOffice Base, you can access data that is stored in a wide variety of database file formats. LibreOffice Base natively supports some flat file database formats, such as the dBASE format. You can also use LibreOffice Base to connect to external relational databases, such as databases from MySQL or Oracle.

The following database types are read-only types in LibreOffice Base. From within LibreOffice Base it is not possible to change the database structure or to edit, insert, and delete database records for these database types:

Libre Base Vs Ms Access

Apr 10, 2019 Microsoft Office is a powerful productivity suite - but if cost is a constraint, take a look at LibreOffice or Apache's OpenOffice. This post compares their features. Feb 13, 2018 LibreOffice is a powerful open source cross-platform Office suite that works in many regards just like Microsoft Office. While you can use LibreOffice apps to edit spreadsheets or Word documents, you may use it as well to create, edit and save PDF documents.

  • Spreadsheet files

  • Text files

  • Address book data

Using a Database in LibreOffice

Libreoffice Access Database

  • To create a new database file, choose File - New - Database.


The Database Wizard helps you to create a database file and to register a new database within LibreOffice.


The database file contains queries, reports, and forms for the database as well as a link to the database where the records are stored. Formatting information is also stored in the database file.

  • To open a database file, choose File - Open. In the File type list box, select to view only 'Database documents'. Select a database document and click Open.

Related Topics

Help about the Help


Libreoffice Access Equivalent

The Help references the default settings of the program on a system that is set to defaults. Descriptions of colors, mouse actions, or other configurable items can be different for your program and system.