LibreOffice Base (01) Create a Database, Create a Table

LibreOffice Base (01) Create a Database, Create a Table

LibreOffice base is a tool to
create and manage data bases but the first thing i want to point out
is we don’t call this LibreOffice database because it’s not the database by itself the default database for LibreOffice for
LibreOffice Base is HSQLDB but it can also be used as a front end to
read in other databases like mysql or an access database for this tutorial series we’re going to
treat it as if it were an all-in-one database although it’s not meaning we are only going to use the default HSQL-DataBase when we open up LibreOffice Base it brings up a database wizard and asks us what we want to do do we want to create a new database? open an existing database file or
connect to an existing database now if we had a data base out there, we could select that, connect to an
access database or down here we see mysql i don’t have one out there now, but if i did
we could create forms and reports from it what we want to do is create a new database so i’m going to
select that radio button and click on next and i’m also going to mention let’s go
back “Save and proceed” does the same thing is
next. You clicked this brings it to the next sceen now it’s asking us do we want our
database registered it really doesn’t matter right now we
can always register it later I will mention that registering your database just makes your database viewable to the
different the libreoffice modules. It has nothing to do with any online
registry of any kind if you want to know a little more about
how the registry works right now you might want to check out the
LibreOffice Writer mail merge videos i made we will look at how register databases
work later in the series, but that’s way down the road I’m not going to register my database
right now but i will open the database for editing i’m going to click finish and i want to give this a name i’m going to give our database the name
odb01 employees and click save we told it to open database and that
we did so we see it up at the top on our title bar odb01-employees and right now we have been empty database where are at our main screen and we see three
windows one that’s his database, one that says tasks any other says tables under database we have tables selected
if i change this to queries we see our tasks changed and our third window now says queries in the same thing happens for forms and
reports we’re going to start with tables sensor data base won’t lose any good
without any data in it and all the data we’re going to need a
table looking over their tasks this top on
says create a table in design view and the description for that is create
the table by specifying the field names and properties as well as the data types that’s the one we want; so i’m going to
click on it this brings up something that looks like
a spreadsheet with three columns we see field name field type and description to help us visualize what we want to
create i’m going to use the tean contact list
we created in the calc series with a few changes to it here we see we’ve got lastname firstname
gender start date, end date, phone number, and so on when we form editor calc spreadsheet we used different formatting for our text fields for our date fields in for our new numeric fields we’re going to do the same thing here one difference between a new database and the calc employee list is we want each employees to have its own
number just like most companies give employees
numbers to the employees or schools might give a student number to each
student we’re going to do the same thing here and we want LibreOffice based to enter it all in for us in their field name we’re going to call
this employees i_d_ Libreoffice base wants is to enter the scene as a
text field we’re going to change this to integer down in our field properties we have a thing called autovalue We want to turn this to yes so this will auto populate this field
for us giving each employees a different number starting with your own and counting up i’m going to put a description n we’re going to see this is the unique
employee number looking back at are calc sheet we now have lastname and first name this one we can use, a text varchar looking down our field properties it’s asking us if this entry it’s required we want to
say yes we need to have lastname if we’re going
to give them employees-ID the length is one hundred but when we see var char that means variable characters if we don’t use all one hundred
characters it will just cut it off: to what we need
in only use the memory which we need so we prefer varchar because that’s a little more efficient than fixed giving it description now the first name we’re going to make first name required
as well and leave the rest and will put in a description here next one we have is gender instead of variable characters this time we’re going to make this one fixed and we’re going to give it a length of six under our description we’re going to say it must be either
Male or Female next week at the start date and we’re going to make this one a date
field Since the descriptions are not
required i’m going to enter in the rest without any descriptions now we have our entire table entered the only other thing i want to point out
right here is, if I want to add a field i can go up to where it is right-click and insert a row. new field. but once i save this database i can’t do that any new field i want to enter after I save this database will have to
go at the bottom you’ll see later that it really won’t be that a big
deal but just to let you know we can’t change the order before we see at the table let’s save it right now i’m going to give it and name of employees so now we’ve got in empty table inside
of are database to open up this table double click on it and there’s all the fields that we just
entered if i right click on this it brings up a
shortcut menu we can copy this table deleted rename it edit or open when we double click it we opened it now we’re going to take a look at edit edit brings us back into the edit mold. edit mode is where we just
where, where we added all our fields to the table we may want to add or delete a
field this is where we would make that kind of
change now i’m gonna open it and Lets add some data now this first one was said was awful
field so we don’t need to enter that field let’s get our values for calc table we’ve got last name…. Taylor Mark he is a male start date was two thousand five ten-thirty-one to get to the next row i’ll just hit tab so we see that our first employee i_d_ turns to zero if i start to type in the next one not put in his last name now i tried to save this table it gives me an error because our last name in our first name where required fields so i have to give it it least a last name and the first
meeting now i can save the table I’ve typed the rest of the data in from the
spread sheet. so now we’ve got some data in our table in our database so i’m going to save my
table and save my database I’ll put this on the website incase anyone wants the download it from

Danny Hutson

75 thoughts on “LibreOffice Base (01) Create a Database, Create a Table

  1. Heartly salutations to you, good sir!

    Great to see the continuation of the LibreOffice series.


  2. Greetings! Yes, Libre Office Base this time, I’ve had a lot of requests for this topic. As with the other modules – there is a lot to it! This could be a long series…

  3. Good eye to catch that! In the video, you will see that I try to save my table after typing in the last name of the second record, but before I typed in the first name (both required fields). LibreOffice incremented the auto value and tried to save the record (It couldn’t enter it at that time) after I typed in all required fields, I clicked save, it incremented (again) and added the autovalue to the record.

  4. Actually, I don't have a complete plan (yet), so I can't say for sure how long this is going to be or what will be covered, but that's how all my series start. I have some idea's to work with and right now, it seems there may be a lot of videos, but we will have to wait and see…

  5. I've used your Calc and Writer tutorials to learn enough for me to get work. I am looking forward to using this series too. You provide a great service with your tutorials, they are the simplest and best series I've come across – free or paid.

    What hardware-software do you use to produce your videos?

  6. Thank you! That’s a great compliment. I’ve got a basic windows 7 home premium computer and the screen capture software I use is Microsoft Expression Screen Capture (It was free with windows 7, but I did have to download it separately).

  7. Nice tutorial.  Clear and  easy to see and follow .  I look forward to watching more of them.  Thanks for putting in the effort to make these available.  

  8. I really don't have a use for a program like this, but I was just curious about what it did, and you did a great job explaining how to use it and what it is for. This was a great tutorial. 

  9. Hey, I really enjoy your work, you make it look so nice and easy.

    I've come across 1 problem: in my data base i wanted to change the field type which appeared on the field name 'Criteria" from Number to Integer and it said "the column could not be changed, should the column be deleted and the new format appended?" I clicked on Yes and the criteria column dissapeared (the name is the same, but the content is from the next column).

    I cannot add any fields, not even at the end. Is there any way to add the column at the beginning (where it used to be) or, at least, at the end? Hope you can help me! Thank you for all of your tutorials.

  10. Just a note that you probably know but isn't varchar (considering giant databases) less efficient speed wise than a fixed char (assuming that you can determine a decent fixed length) due to random access?
    Probably no noticeable difference for even medium sized databases but it just bugged me a bit to hear you say "efficient" rather than highly convient and with a non-noticeable speed difference (though this is a tutorial on Libre's Base not on how computers work internally so…forgiven of course :))

  11. The primary index lacks the id number 1. Is this a bug of the wizard? I doubt is the default behavior of any SQL.

  12. Very nice video tutorial, very well explained. Just a little advice: make playlist based on every application. Right now I would like to watch just the LibreOffice Base tutorials.

  13. I spent several years using MS Access. Now I'm 74 and want to use Base as much for sentimental reasons as anything. I'm 74 and using LO 4.3 on a win7 box. Two questions: (1) you say Base is only the front end of a db, but I see relationships, queries, wizards, report builders etc. (2) due to prior warnings, I've 'turned off' java. IN YOUR OPINION, should I 'reinstall' java? if so, what ver?
    Gramps… Sharpsburg KY USA

  14. Please tell everyone if you can save with a password with LibreOffice Base and if not how do you secure your data you are inputting.  Puzzling question users may not understand.  Thanks!!!

  15. Thanks very much for making all your tutorial videos. They're excellent! It must have taken many hours planning, preparing, and recording them. The quality of information and manner of presentation are very professional. I have just given a donation via your web site. Thank you very much for your commitment.

  16. Hi I was wondering if you could help me set up my data. I have two instructional works I want to compare. They have written similar steps in the instruction but there are differences. In addition, there are multiple components within each step. I was looking at your multiple tables video but am not sure if I could eventually make the correct relationships. For Table 1: I was thinking of creating 2 rows of Instructional Work #1 and then #2 and then giving each instruction work an ID; in the columns I was going to write out all the steps. But instead of writing the different components of each step as separate columns (like your work phone number, cell, home, etc) I was thinking I should create another table for each instructional step (Table 2). Then in Table 2 I would assign each row the instructional work ID so I could create a relationship between each table.

    My question is: How do I create a unique ID? I don't have 2 variables like your phone number situation that together creates another unique situation that could become a new unique ID. I only have 2 instructional works like 2 employees.


  17. Sorry – one last thing. My purpose is: I basically want to be able to make queries so I can compare the steps of both instructional works at the same time in the same form. Even if the steps of each instruction work exists in separate tables. I was thinking I could display the steps as those tables you showed underneath the form.

    Is this possible?

  18. Even if the steps of each instruction work exists in separate tables.

    I meant to say: Even if the components of each step of both instruction works exist in separate tables. (So Table 1 doesn't get crowded and messy looking like your phone number situation)

  19. Huh, looks like a great video series.

    >Does pretty good for first 5 minutes

    OK sweet, it's in an accent I can easily understand…


    /me watches on with hopeful optimism…

  20. My request you to make a awesome tutorial on Calligra Plan as you did lot of awesome tutorial.. really thankful to you.

  21. I hope you can help me! I just installed Libreoffice and was following this video, after I save the db and it opens, it tells me it needs JRE to run, I have Java installed, but it doesn't recognize it for some reason. Do you know a fix for this? HELP!!!

  22. Hi! Thank you so much for this!! This is super helpful <3 I'm taking a basic Computer Science subject in college, and we're on Database now. Couldn't have survived the semester without your videos! Thank you!
    Maraming salamat! 🙂
    – from the Philippines

  23. Hi, thanks a lot for the tutorial, your the way you explain things is very clear and makes it easy to learn it, just one thing, I can't find "odb00-employee-calc-table.ods" in your site (a few comments before you instructed someone to search for it "under Group 2 video 3"), can you post a url or may be point me in the right direction? Thanks again for all your hard and very effective work

  24. Hi, your video is very good.  I wanted to follow it on my computer, but I'm stuck on the second step.  When I try to create a database, I get the spinning ball — it goes on and on.  What could be the problem?

  25. Hello, I can not edit the field properties of the table after I created the table, and save it. Do you know how I can get access to modify the fields?

  26. Thank You so Much, I've been reading for mouths now about how to use databases and have learned a lot. I'm A hands on, trial and error learner but man you have showed me a lots in a shorter time than reading and everyone still needs to read a lot of the apps. help intros but these tutorials will save you a lot of time,it has me Thanks again

  27. This helps a little, but not very much.
    Can you make a video on how to create a darts tournament with 6 dartlanes and a max of 6 players per lane (3-6 players per lane) depending on how many players want to play.
    The is also a Hobby and Pro option.
    Is this do able?
    Cause this will take me forever :'(
    I tried to create it in Calc, but that was impossible for me for some reason.

  28. I am a mac user and what to create a database with photos for real estate and a comprehensive
    directory all centered around photos. Pls direct me to training material which cover the topics. Thanks

  29. Well, this must be an old video, as you only have "Male" and "Female" , but no "Trans" in the Gender description.

  30. Wow! Such a useful series. It has just passed its fifth birthday but almost everything is still relevant, because of the way LO adds features but does not remove them.

    As a Linux user by choice, but formerly trained on Ms Access I found the rest of LO intuitive but Base obscure in so many places.

    I find it especially useful that you show exactly where to find each control on the page, as that is what I (personally) am having most trouble with.


  31. ohhboy! … what is THE point to WRITE everything by your self again in different section …there is no option to just convert it ? or copy and past ?? … I have made a table of addresses and would like to use it to print labels – NOTHING WORKS IN THIS FREE LIBRE OFFICE … it just approve my old saying FREE THINGS ARE WAY TOO EXPENSIVE …

  32. I notice you retyped the whole calc spreadsheet by hand… and made some errors.

    Isn't there a way to import data from another LibreOffice app into the database?

    That would be slick, esp. for my 400 plus entry database!

    I see The Frugal Guy doesn't answer questions. Anyone else know the answer?



  33. Thank You. These are not just the best LibreOffice Base tutorials, but the best tutorials, period. I have never seen anything complex explained so clearly yet simply. This guy is amazing.

Leave a Reply

Your email address will not be published. Required fields are marked *