There’s two ways to create a database in LibreOffice (similar to Open Office, but LibreOffice is updated and worked on more frequently). Create The Database You can create a database using either of the following methods. From the LibreOffice start screen, choose "Base Database". From any application within LibreOffice such as "Calc" or … [Read more...] about How To Create a LibreOffice Database In Windows 10
LibreOffice OpenOffice
Create A Form and SubForm In LibreOffice Base
The following video and article will show you how to create a form and subform in LibreOffice Base (or Open Office base) without needing any code, enjoy. Get the sample database used here. Also get updates when new blog or video tutorials are released. Submitting... … [Read more...] about Create A Form and SubForm In LibreOffice Base
Export Table Data From Libre Office Base
In this tutorial we are going to export the contents of the table below to a text file in csv (comma seperated values) format. LibreOffice Base is the free database application that is packaged with LibreOffice, I use it all the time and in my opinion is the only option for quick and dirty database analysis on the Apple Mac platform (which i use). LibreOffice base is also … [Read more...] about Export Table Data From Libre Office Base
How to Make A Table In OpenOffice or LibreOffice
In this tutorial I will explain how to create a table in LibreOffice base, a free database application that is available on windows mac and linux. This simple table could be used as a generic table for importing data into your database. Further queries in the database could then transfer data from this table to other parts of the database while changing … [Read more...] about How to Make A Table In OpenOffice or LibreOffice
How To Filter Data In LibreOffice Calc Using The Advanced Filter
How to become a data crunching wizard using a combination of the Advanced Filter and Regular Expressions in LibreOffice Calc. I originally wrote this article back in January 2016, but is seems that LibreOffice might have changed it's regular expression engine, because a lot of the stuff that worked back then doesn't seem to work now. Therefore I've completely rewritten this … [Read more...] about How To Filter Data In LibreOffice Calc Using The Advanced Filter