LibreOffice is a powerful office suite – its clean interface and feature-rich tools help you unleash your creativity and enhance your productivity. LibreOffice includes several applications that make it the most powerful Free and Open Source office suite on the market: Writer (word processing), Calc (spreadsheets), Impress (presentations), Draw (vector graphics and flowcharts), Base (databases), and Math (formula editing). More Information
In the video I give an explanation how to looking value in LibreOffice base.
LibreOffice Base is a LibreOffice application component that works to create and manipulate a structured database.
Based on LibreOffice's official website, LibreOffice base can be explained as below.
Base is a full-featured desktop database front end, designed to meet the needs of a broad array of users. Base caters to power users and enterprise requirements, providing native-support drivers for some of the most widely employed multi-user database engines: MySQL/MariaDB, 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 as well.
A report is a Writer text document that can show your data in an organized order and formatting. In LibreOffice Base, you have a choice to create a report either manually using drag-and-drop in the Report Builder window, or semi-automatic by following a series of dialogs in the Report Wizard.
Source
Or you can read Wikipedia for more information.
Intermediate
LibreOffice suite comprises programs for word processing, the creation and editing of spreadsheets, slideshows, diagrams and drawings, working with databases, and composing mathematical formulae. In the video below, I explain how to create a report and how to edit a report, I explain how to search for a empty value using the Function wizard. To more detail please go to video i have attached
in the photo above, I want to find the data "Department" using data "ID", to find it I use Function Wizard "IF".
The photo above is the result after I use the Function Wizard "IF" in search of the data "Department" from the data "ID"
LibreOffice Continue to Grouping data Report on LibreOffice Base
How to connect a table to creating Report on LibreOffice Base
However I have made some Video Tutorials how to use Apache OpenOffice, you can see it below :
