Database tutorial explaining how to create tables, forms, queries and reports in the free application LibreOffice Base. Includes information on primary keys, setting up table relationships, working with sub-forms, editing list boxes and combo boxes on forms, and more.
LibreOffice can be downloaded for Windows, macOS and Linux from:
https://www.libreoffice.org/
The Java Runtime Environment (that you may also need to install) can be freely downloaded from:
https://www.java.com
If you enjoy this video, you may find useful my spreadsheet tutorials:
Spreadsheets #1: Introduction:
https://www.youtube.com/watch?v=7Q2C9MB-YH4
Spreadsheets #2: Absolute & Relative Cell Addresses:
https://www.youtube.com/watch?v=Pm_raXxS8u8
Spreadsheets #3: IF Statements:
https://www.youtube.com/watch?v=iFz82q4vHnk
Or my HTML & CSS tutorials:
Introduction to HTML:
https://www.youtube.com/watch?v=WwNuvGLblJU
Introduction to CSS:
https://www.youtube.com/watch?v=giOoA3xTqYs
For additional ExplainingComputers videos and other content, you can become a channel member here:
https://www.youtube.com/channel/UCbiGcwDWZjz05njNPrJU7jA/join
More videos on computing and related topics can be found at http://www.youtube.com/explainingcomputers
You may also like my ExplainingTheFuture channel at: http://www.youtube.com/@explainingthefuture
Chapters:
00:00 Introduction
00:41 Database objects
02:56 LibreOffice Base
04:40 Tables
05:30 Primary keys
10:25 Relationships
16:47 Forms
17:00 Sub-forms
20:31 Queries
25:00 Reports
28:59 Wrap
#Databases #LibreOfficeBase #Tutorial #ExplainingComputers
Excellent video!!!
I need to setup a database of my music collection. Should I keep it flat file or relational? Any ideas links?
Thanks again!!
@Peter-cd3us Says:
9 =
StarFive JH7110
RISC-V
4 x 1.5GHz U74
Imagination BXE-4-32
8=
StarFive JH7100
RISC-V
2 x 1.0GHz U74
H265/H262/JPEG codec subsystem
7=
Rockchip RK3399
ARM
2 x 2.0GHz A72 & 4 x 1.5GHz A53
Mali-T864
6=
Rockchip RK3588
ARM
4 x 2.4GHz A76 & 4 x 1.8GHz A55
Mali-G610 MP4
5=
Intel Celeron N5105
x86
Quad core 2.0GHz base, 2.9GHz burst
Intel UHD Graphics
4=
Intel Celeron J4105
x86
Quad core 1.5GHz base, 2.5GHz burst
Intel UHD Graphics 600
3=
Broadcom BCM2711
ARM
4 x 1.5GHz A72
VideoCore VI
2=
Allwinner D1
RISC=V
1.0GHz T-Head Xuantie C906
G2D
1=
Amlogic S905X3
ARM
4 x 2.0GHz A55
Mali-G31 MP2
@johnnyrosenberg9522 Says:
Nice! I never bothered with Base, maybe I'll give it a try now.
@shannonv_66 Says:
Thank you sir, in all the videos I had watched, only yours that made me understand the libreoffice base. May god bless you.
@robertblodgett3911 Says:
I'm new to databases. This is one of the best database tutorials I've discovered. You have opened the door for me and the new possibilities are overwhelming. Practice, practice. Thank you.
@blackrookgaming Says:
Thank you so much, I did not know that this exists
@jnjtm6113 Says:
All your videos are gold
@staninjapan07 Says:
Beautifully done, as I would expect!
No longer having MS Access, and having my work materials info in a Google Sheets sheet, I guess I have to learn Google API to query my data, but, this being YT, "querying google sheets as a database" also showed this, and I cannot resist an E.C. video, so I had to check this out, too. Reminded me of office jobs I had 25 years ago when Access was what everyone used to get queries/reports done.
Still, as my info is in a Google Sheet, and even though I have Mint 21 so I have Libre Office Base, I want the fastest and easiest way to get my info.
Thanks, you did a sterling job as usual.
@visionconnect190 Says:
You are excellent with your knowledge sharing... Thanks.
@adas19581024 Says:
Excellent, i cannot ask for more 👌
@munkh-yalaltkhadbaatar9748 Says:
Thank you!
@johnmahugu Says:
thank you very much for this. perfect!
@firehandszarb Says:
That is an excellent tutorial.
@TheMaede999 Says:
nice tutorial - thank you! One question: in the Report Wizard you got a lot of layouts to choose from, how did you got them? I only have a few and only one "Layout of headers and footers" option. also I didn't find an option to save a layout I made in the report designer as a layout to choose from for another report. Hope you can help me with that :)
@jeremiahbullfrog9288 Says:
In the Forms section, I was surprised you have to save the record before the subform populates... is there a way to get live subform data as you select the SoC value?
My immediate thought is to attach an event to the list box and write a macro to populate the subform -- is there a simpler method?
@mihailvormittag6211 Says:
👍
@FrauHaferniehl Says:
_Nice Video, Thankyou. Greetings from Germany._
@serdip Says:
Very cool video that shows how to perform the most common operations in creating a database using LibreOffice Base. As a longtime Microsoft Access user, I find that both programs are largely similar and quite capable of delivering sophisticated end user applications. Thanks for providing this concise yet thorough tutorial on creating and using databases with LibreOffice!
@andyvarella6336 Says:
Very informative and well-done tutorial. Thanks Chris.
@pinorinomoru7260 Says:
that's a good introduction. Just wondering is there a way to get filter in the form to jump from a record to another without the necessity of scroll all list?!
@vijayswamy2564 Says:
Thank you for showing us the wonders that we can accomplish using free & powerful software. I am retired and was trying to learn SQL for kicks. I spent half a day to create a table and get some entries in. Libre Base has the best of both worlds. The graphical interface, your great tutorial in simple terms and the mighty software behind helps us to understand the relationship between tables. Kudos for showing us how joining tables can be done in a jiffy. Thank you very much. You have helped me learn.
@BlissWheelerMyProfile Says:
Great Job! That will help jumpstart me. I really appreciate your time and effort..
@roofoofighter Says:
Hi, is it possible to add photos to fields?
@hatemkamal1682 Says:
A question please: You have shown us that we can edit the query using SQL language. But everything I read online says that the language for coding in Libreoffice Base is a sort of Basic language developed specifically for Libreoffice. Would you please clarify this? Also I read that Python can be used in Libreoffice Base. Would you please clarify that too? Can any of these languages be used in other parts of Libreoffice like Calc? Is it that many languages can be used in Libreoffice but each language does a specific thing that other languages cannot do? or how can we understand that?
@hatemkamal1682 Says:
Thank you. Can you please make similar videos for MySQL?
@Kig_Ama Says:
Hi, I have an access db wit the file extension .accdb, I try to open or connect using libreOffice base, but I get the error message _"SQL Status: HY000 The connection could not be created. Maybe the necessary data provider is not installed."_ I am a newbie to libreOffice would like get rid of Microsoft Office. Every help is much appreciated. Ty in advance!
@wengstezze Says:
this is gold!! I needed this for my CS studies and you has saved my ass 🙏🏻
@vipsylar6370 Says:
How do You create a report with the assistent in this way with the full page shown? When I open the assistent to create my reports, always opens the report builder showing the 3 parts way of creating the report (page header, detals and page footer), I meed to learn how to create a report the same way as yours. Why is diferent the way the assistent opens in my pc and in yours? I'm running Windows 10 and Windows 11 and not enable to create a report the same way as You do. Please help.
Sending good vibes from Brazil.
I love your videos.
@hameddesign70 Says:
26:24 where did you find all of those presets ?
@hameddesign70 Says:
this video is GOLD
@stevewaterfield4862 Says:
Thank you
@zalves2000 Says:
Amazing explanation as always, thank you Chris!
@thebeastsclips Says:
😂Nice
@erichepperlewp Says:
12:02 - Somehow the subform is giving me an issue about null and autoincrement doesn't work after making the dropdown writable (not readonly)
@リンゴ酢-b8g Says:
great tutorial. managed to get me back on track to learning db's and sql queries
@feraudyh Says:
Very good overview of Base.
I have already created some text files with fields separated by semi-colons. I wonder if I can use that to populate a database, so as to continue with the more sensible form-based input.
@urielpelaezcdmx Says:
🧑🏻💻💯
@awksedgreep Says:
DBA for 25 years. This reminds me of the old dBase IV days in college. So effective with so little work required to be productive. Fun video.
@k-c Says:
@2:58 Waifu2x Extension 😂
@BilliesCraftRoom Says:
As a visual learner, this was a wonderful video. Making everything and going through step by step. I'm going to need to re-watch it a few times to fully understand, but it's really helpful and well explained. Thanks for sharing this.
@ฉันเรียนไปเรื่อย Says:
Can it import access file into it?
@StephenCofMD Says:
Phenomenal video. I do have a question, where do I find more report layouts? I followed along to create the same database, however, I only have a fraction of what was shown in your video, so my generated report looks terrible. I have tried searching for "report layouts" and "Report templates" with no luck. Perhaps I'm using the wrong verbiage in my searches?
@CCoburn3 Says:
Great video. I have never seen why people use spreadsheets as databases when actual databases are so easy to use and do the job so much better.
@laikesagores3258 Says:
Good Lesson!
@ChatBook_ Says:
You saved my life, thank you!
@deathhog Says:
Oh how i could have used this tutorial about a year ago....
@jeffjordan3806 Says:
Very clearly presented. Thank you.
@carlosssandovallucas9326 Says:
tanks so much i try to have a personal finances in orderi think this will help
@marcel_max Says:
I got a problem with libreoffice, in the setup I selected A4 as main paper size but every time I go to print something, I still need to select A4 again. I also selected A4 in the printer settings in windows but I still can't have libreoffice remember that setting. Where is the problem?
LATEST COMMENTS