LibreOffice Base Database Tutorial

Full LibreOffice base database example (same as open office base) to demonstrate how to create a personal training database with very little code.
The code enables you to add photo functionality and auto entry of a value to a field but everything else can be done without code.
Download link for photo code has yet to be added, coming soon...

This tutorial will show you how to create a relational libreoffice database with a one to many form that enables you to add and delete records without the need to use code.
There is a little code discussed at the end of the video, but that is just so you can display photos and avoid having to type the date into the date field of the form (which is nice to have)

I will be adding more notes to this section as and when.

☕
If you found this tutorial helpful consider supporting this channel with a steaming hot cup of coffee...
☕

Video Production
===============

Microphones
-----------

Video Kit
-------------
Lights

Note Taking
-----------

Resources
============

Video Production
===============

#libreoffice​ #openoffice #Databases #LibreOfficeBase

DISCLAIMER: This video and description contain affiliate links, this means if you click on one of the product links, I might receive a small commission.

[BusinessProgrammer]

This video is in response to a comment I received asking whether LibreOffice base could be used to create a database for a personal Training business, I took it as a challenge to see what could be done with only a small amount of code and this is what I created as a proof of concept database, let me know what you think in the comments below.

[joshuayeidel]

This excellent tutorial takes a form-forward approach, which is novel and helpful to a guy whose experience of database is a dozen years of SQL Server.

[Jean-MarcLaurin]

Hello Sean, thanks for the tutorial, very helpfull. I really liked the Before Action Record date thing. Is there a way to add the time as well?

[areskytori]

Quick, complete and clear. This is how any good tutorial should be. Thanks.

[kitwojciechowski]

Thank you for this video! Your instructions are clean, clear, and I love both your voice and your humor. I'm trying to self-learn this from scratch to help me and other owners self-training service dogs for generating training plans and logging them much more easily than what's available right now. You filled in a lot of holes that my unskilled poking had found lol. THanks again

[yashkaranjai]

Thanks for the amazing tutorial Sean. Its not easy finding a decent tutorial on Libre Office.

[patricklimacher]

Thank you Sean for this great Tutorial. I prefer LibreOffice Base over MS Access, mainly because of FOSS and multi platform usage. It reminds me somehow to the old dBase or DataEase days. Your videos help a lot, specially this one with sub-forms. Once you get the idea, you can easily adapt. If I may place a wish for a further video: please use that main/sub-form in your example and create a print button (including code) to have a simple report for each existing customer printed, maybe with a search button for a customer name/number search first. I always have difficulties in getting a report out of a main/sub-form printed. Thanks for your help. Great content. Regards. Patrick

[fretinit]

This video has exactly what I was looking for, and the presentation was very good. Thank you Sean.

[RAMSBR]

What an amazing tutorial. Kudos all around. I learned so much from this 25 min video.

[EppingUplandParishCouncil]

Many thanks for this. Very useful indeed

[learningtho]

Thank you very much for this. I was stuck with something and after watching this video the problem was solved.
Thank you

[ferdinandtjombe]

Thank you very much for sharing your knowledge. It was a joy watching this educational video with clear instructions.

[Kiwi]

Great tnx for the tutorial. I m new to Libre office. Been searching how to calculate 2 Fields in a table, e.g. A1 * A2 = A3 and store the value of A3 in that table. Expanding this, I give a discount A4 (%) and deduct this and stored in a new field A5. tnx anyway.

[davidstepanczuk]

Sean, this is great. Thanks for the video & all the work. One thing seems to be missing: how about the standalone database search app, i.e. how do you use this database & what it looks like?

[jonlbs]

Fantastic video. Thank you !! 👍👍😊😊✨✨

[Mike-nysf]

Hi Sean, thank you for your videos.
I’m just starting out with Base and LibreOffice and looking forward to watching your videos. If I could just make one suggestion it would be to get rid of the echo. It makes listening a little difficult. But maybe that’s just me. Thanks again.

[anthonyv]

Hello

Like your video. It’s great.
I have created a database in LibreOffice Base. I imported data from a Calc spreadsheet. The database looks great. I created a form also.
I cannot enter or remove data from the data base. It seems locked.
In the table, there is no primary key. It seems locked. I cannot add a primary key. Any suggestions on enabling entering and removing data from the data base or adding a primary key.

[robs]

Thank you! It was exactly what I was looking for! Liked!!!!

[Yellow]

Thanks Sean. I've learnt a lot from your video. It really help as a rookie like me. Just wondering if any chance to get the code of this training? Thanks again.

[anndrake]

Totally excellent! I have needed this for weeks. Thanks!