The following article will demonstrate how to build out a useful LibreOffice database without using any programming code. We're going to build a simple application to manage training courses and students for these courses. Get the database, files and sql used in the tutorial video above. Also get updates when new blog or video tutorials are … [Read more...] about Simple LibreOffice Database Without Code
All Articles
Excel VBA MsgBox – Ultimate Tutorial
Msgbox allows you to communicate information to your user or request guidance on the next action that you'd like them to take. MsgBox can take up to 5 arguments, the message being the only one that's mandatory. Bear in mind that the message box is disruptive, meaning it halts processing until the user takes action such as pressing return or clicking … [Read more...] about Excel VBA MsgBox – Ultimate Tutorial
LibreOffice Base Database Text Table Example
In this case study I demonstrate a practical example where Rainfall data is collected an analysed on an Australian Farm. The users system collects 288 data rows per day which totals to 104,916 per year, however he only wants the last row saved (which holds all the data for that day). In this tutorial I show you how to do this using a LibreOffice Split Database that uses the … [Read more...] about LibreOffice Base Database Text Table Example
Understanding The Excel Advanced Filter
Background The Excel Advanced Filter gives you database like functionality and helps you crunch large datasets with ease it can also help you begin to better understand database structure. This article contains several tutorial videos related to the Advanced Filter, enjoy... Unlike the Autofilter which only allows you to filter on one element per column, the … [Read more...] about Understanding The Excel Advanced Filter
How to link images on a LibreOffice Base (Open Office) Form Dynamically
Let’s get images working on a LibreOffice (Open Office) base database form, in this tutorial I show you how to get this done without having to be a coding ninja. The idea for this tutorial came from a project that I'm hacking together, you see I'm aware that the navigation on this site could be better, so I'm creating a LibreOffice database that ties the content on my youtube … [Read more...] about How to link images on a LibreOffice Base (Open Office) Form Dynamically