How To Create A Database Using LibreOffice Base
Vložit
- čas přidán 8. 09. 2024
- Libre office base (similar to Open Office) is a free database for mac OS X, linux and pc.
LibreOffice (Open Office) Base Programming Book (affiliate) amzn.to/35wqtuI
base is the only office SQL relational database available on the mac platform.
How to create a form and SubForm in Open Office or LibreOffice
• How To Create A LibreO...
☕
If you found this tutorial helpful consider supporting this channel with a steaming hot cup of coffee... buymeacoffee.c...
☕
In this tutorial I show how to create a LibreOffice database, this is the same as an open office database, I then proceed to show you how to create your first table and add an autonumber key field to the table and show you an example of adding some data and the id field auto incrementing.
Libreoffice base (very similar to open office base) can be used as is and also to connect to MySQL and other database systems.
It is also the only cross-platform desktop database application.
You can find other tutorials at www.businesspr...
#libreoffice #openoffice
Video Production
===============
Sony Camera: amzn.to/3mqyqfu
Elgato HDMI Stream Capture: amzn.to/2Yfyrum
Microphones
---------------
Screen Casting: amzn.to/3a2TnHN
Microphone and Arm : amzn.to/3iwvL2S
Talking To Camera: amzn.to/3FqXI6b
Video Kit
-------------
Lights
Elgato video Lights: amzn.to/3sSK3xg
Background Light: amzn.to/3uTXyPh
Note Taking
--------------
Rocketbook reusable notebook amzn.to/3sSK3xg
DISCLAIMER: This video and description contain affiliate links, this means if you click on one of the product links, I’ll receive a small commission.
Hi Sean
I use to build custom homes, solar applications, that kind of stuff. After an electrical accident, I turned my view to computers to learn a new job skill.
Coming across and meeting great people like you, who give information, and teach is a real Blessing. I believe it's important to give thanks and show gratitude,
Thanks so much, very appreciated my Friend
Joseph
Thanks Joseph (Sorry for the delay ;-))
Hii sean jonson. Iam a malayaly(in kerala).Ithu valare simple ayittu thankal kanichu thannu.It is very easy.Thank you so much.
Glad I could help
Hello, the gift that keeps on giving. :) A video from 2017 helped me today. Without giving you the whole story, I'd created a database plus tables but every time I actually entered data I kept getting the same error - 'null into a none nullable column. I didn't get it as there was data in the fields. Searched for help - loads on "you must have set the character length wrong...." Anyway, I saw this video and scrubbed all I did and started from scratch. That helped me see that the issue was the 'key' and fact I needed to set it to automatically fill - e.g. changing default from 'no' to 'yes.' I would never have known that was the issue as I was looking at the fields I'd created. Anyway, now I have a database and it is not littered with empty tables. Thanks!
Glad you found it useful:-)
I dont undertand very well english, but understand what you are doing, becouse you are doing a database from zero. Very helpful.
Hi Maxi
Thanks for the feedback, It's good to know where I'm being helpful or where I can improve things.
Kind of fun learning this stuff with Schwarzenegger's voice! :)
This is a good quality educational video.
And it really helped me to understand the way libre office database works.
Soo yeah, keep up the good work!
Glad you liked it!
Hi Sean, very good work, don't know why people give you thumbs down. Clear Concise and to the point. Keep up the good work.
Thanks Niall, sorry for the late reply
That was very easy, Sean and you did the DB that I wanted
Glad I could help
Thank you so much for making this video!
Hi Jonathan
Glad it was helpful!, thanks for letting me know....
You caqn check out my full LibreOffice Base Library here..czcams.com/video/k6XUpvYwuPg/video.html
Some may have annoying music, I've got the message and stopped adding it now.
What about calculating fields, Date1-Date2= Elapsed Days or something like that.
Hi Tyrone, thanks I'll look into that
In Office Access , i have a lot conections with Excel
Does Libre office have that type of connections ?
Thank You
Hello Can we make the phone number as a primary key?
🦍🐗
You could, but it's not a best practice, because database "Science" would say ID fields shouldn't represent actual data for various practical reasons that have "caught out" developers over the years. for example telephone number formats vary in different parts of the world.
If you're database gets complex with lots of joins, joining on a telephone number just looks messy and is likely to cause a performance hit over having integer key fields.
Hi Sean Johnson! I just started using LibreOffice.
I'm working on forms right now, I just want to ask about creating a rectangle but I got a problem adding field above it. I couldn't select the field that I added to move somewhere in the form.
It keeps on selecting the rectangle. Do you have any idea about this?
Can libreoffice databases be connected to python?
I believe it can, have a look at this link pypi.org/project/JayDeBeApi/
Java is generating a problem in Mac OSX Catalina 10.15.5. How can this be solved?
Are you using java.com rather than oracle.com java?
I recommend Oracle.com java, see this video
czcams.com/video/LSjzIwDo0nU/video.html
Hello, Can you show how to create a receipt collection database similar to Neat Receipts? Manage costs and taxes etc>>>?
Great suggestion!, I'll add it to my todo list..., Looks like a serious heavy weight app though as you would probably want ocr and scanning. Probably combine a database with free ocr scanning google free ocr scanning tools
@@BusinessProgrammer THANK YOU !! That would be great!!! Your the best!
When ever I try to build a table I get this error message:64 bit java runtime enviroment JRE required. Where do I find JRE?
I believe it stands for Java Run-Time Environment.
I'm coming from the world of MS/Access, can I convert them to LibreOffice Base?
There is no "Save Access As Base" Solution, especially if you have lots of business logic coded via vba in forms etc. However you could export your tables and queries etc and rebuild them in base.
This may or may not be practical depending on how complex your existing Access database is.
So short answer is No I guess, but if you are really motivated you can "rebuild" a LibreOffice database to give you somewhat similar functionality. Better functionality in some cases and worse in others.
Thanks, I'll copy the tables.