Getting to know LibreOffice Tutorial 08: Introduction to LO Base
Continuing our series of posts on Getting to know LibreOffice, today we will carry out this eighth and last of the year, focusing on the application known as "LibreOffice Base". In order to do so, close this first cycle of posts dedicated to knowing in detail, a little more about each component of the LibreOffice Office Suite.
Also, as many already know, LibreOffice Base is the application created to be the Database Manager (Administrator) Of the same. And therefore the ideal for create, design and manage different types of databases, Style MS Office Access. So, next we will see what this version offers in terms of graphical interface and technical characteristics.
And as usual, before we dive into today's topic of "LibreOffice Base", we will leave some links to previous related posts:
LibreOffice Base: Knowing the Database Manager (DB)
What is LibreOffice Base?
For those who know little or nothing about "LibreOffice Base", it is worth briefly pointing out that it is, a office tool that works as a Database Manager inside LibreOffice. Therefore, it allows us to access and also manage different types of data source or database (collection of pieces of information that usually consist of a series of tables that, in turn, form a group of fields that contain the individual data).
Something that stands out Based, es que with her, you can create both non-relational (flat) and relational databases, in other words, in which the database fields are or are not related to each other. And in addition, it provides many new or useful features, such as the ability to analyze and edit relationships from a diagram view; the addition of two relational database engines, HSQLDB and Firebird, and the ability to use PostgreSQL, dBASE, Microsoft Access, MySQL, Oracle, or any ODBC or JDBC compliant database. Finally, Base also provides support for a subset of ANSI-92 SQL.
For this, and more, LO Basis It may be enough for a small or medium database administrator user to obtain the Sufficient tools for daily database work inside an interface simple. Since, with it, you can create and edit forms, reports, queries, tables, views, and relationships, in a very efficient, simple and fast way.
Visual interface and app design
As can be seen in the image immediately above, this is the current visual interface of LibreOffice Math, as soon as it is started.
In it you can see, immediately below the title bar from the window, the bar of Menus, and then the toolbar which come by default. While, below and to the left, is located the Database Section, where the user can choose what to create within the created database, for example, tables, queries, forms and reports.
In addition, occupying almost the entire central and remaining part of the window, the user workspace, divided into a Tasks area located at the top, and a Preview area on the bottom. And to end of window, In lower part, as usual, is the traditional status bar.
As shown below, each one separately:
- Title bar
- Menu bar
- Standard toolbar
- Central zone with the Database Section, the task area and the Preview area
- Status Bar
“Open Document Format database files are stored with the *.odb extension. This file format is actually a container for all the elements of the database, including forms, reports, tables, and the data itself. The same format can also store the configuration of a connection to an external database server instead of local data, for example, to access a MySQL or PostgreSQL database server on your network". Create a database / Getting Started Guide 7.2
Learn more about LibreOffice Base Series 7
If you're still in the LibreOffice version 6, and you want to try the version 7, we invite you to try it by following the next procedure About you GNU / Linux. Or if you just want to get to know her by reading, click here.
Whereas, if you want to explore each of the previous post of that seriesHere are the links to them:
- Getting to Know LibreOffice Tutorial 07: Introduction to LO Math
- Getting to know LibreOffice Tutorial 06: Introduction to LO Draw
- Getting to know LibreOffice Tutorial 05: Introduction to LO Impress
- Getting to know LibreOffice Tutorial 04: Introduction to LibreOffice Calc
- Getting to know LibreOffice – Tutorial 03: Introduction to LibreOffice Writer
- Getting to know LibreOffice – Tutorial 02: Introduction to the LibreOffice apps
- Getting to know LibreOffice: Introduction to the main User Interface
Summary
In short, in this eighth and last installment of the year related to the series of Getting to know LibreOffice, and specifically about "LibreOffice Base", we have been able to continue and close the cycle of checking the most recent features and functions within each of the applications of said office suite. And for this case, it is clear to us that said tool of LibreOfficeCalled Baseit's an excellent and versatile Database manager, which perfectly complements said office suite. Which makes LibreOffice, as a whole, a excellent free and open alternative to MS Office.
If you liked this post, be sure to comment on it and share it with others. And remember, visit our «homepage» to explore more news, as well as join our official channel of Telegram from DesdeLinux, West group for more information on today's topic.