Thank you for a useful series of tutorials; I have worked through several of them. However, Base (Version: 6.4.7.2) will not open my new database due to absence of Java. The LibreOffice help files describe the problem but there is nothing of any use to help resolve it. Any advice?
Try Downloading java from here: java.com/en/download/manual.jsp You may need to make sure LibreOffice can see it by choosing the version you just downloaded in: Tools - Options - LibreOffice - Advanced - select Java runtime environment
Did you realize that this video series is now 11 ELEVEN years old? It is nearly impossible to find current videos that actually work with current software whenever I look for it. But, in spite of ten years worth of advancements, and I watched LibreOffice go through some great changes, especially with their Writer, YOUR BASE VIDEOS ARE STILL UP TO DATE!!!!!!!! I want to let you know that I love that your videos are short, sweet and to the point. I don't think I have even given MS Access the time of day for over 25-30 years. Yet, yesterday, I was able to pick up Base, and using your videos, completely from scratch, design and build an application I wanted in just a few hours. Your videos are short, sweet and to the point so I was able to go directly to the episode I needed to get every answer I needed when I needed it. I only had to Google one question and the answer was at the top of the first page in the summary. I don't know if I'm praising you, which you deserve for your wonderful video series, or LibreOffice for being so consistent and keeping their Base software so backward compatible. Have a great day and keep up the good work. I appreciate you Shabbat Shalom
If you want to build a Libre Office Base project, this is the spot. There are 94 videos that cover almost every thing you need to know. I taught myself to use Microsoft Access and spent many months developing a project 20 years ago. As I watch these videos they bring back the concepts and provide the steps I need to create a new project in Base an excellent program at a Frugal price. Thank you FRUGAL Computer Guy. Wish I had this info 20 years ago but You Tube didn't exist then (did it).
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.
Okay I am back for the second time. The first time was to watch the necessary ones to accomplish my immediate goal. Ha. Now I am back for the overall training. Thank You! Your material is absolutely superior.
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.
+richardnz100 Hello Richard, Yes they did take a lot of time to plan, prepare, and record. I really appreciate my viewers and try to give them the best tutorials I can. Yes, I received the donation - Thank you. Receiving donations really means a lot to me because it shows me you got enough value out of my videos to make a donation. And I do appreciate the people who click the thumbs up and/or take the time to send a thank you comment too - Thanks for watching!
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. Warmly River~~
It's a fantastic collection of database videos you've made here, I've been following them with great pleasure, they've been very helpful, Thanks for the great work
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.
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.
Thanks for sharing your knowledge with us! LibreOffice at least for my pc is much more easier to use and doesn't consume much space from my HD! I will definitively watch the rest of the playlist!
Wow! Thank you for the great tutorials. Very clear and step by step. In the process of importing my records from Access and making forms and reports into Libre. I've been a Word user since it was on a 360K floppy. It's horrible what Office and Windows have become. When my DB in Libre is set up, I'm done with MSOffice.
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.
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...
This video clearly goes around the most obvious problem with Libre and OpenOffice base. Not being able to search fields on the form is so basic that Base is by no means a serious competitor to Microsoft Access - a developer simply can not make a user friendly GUI.
Thank you so much!! I did not have ms office 365 but in school, we were supposed to do it...I found this as a good alternative but because of the java issue, I could not use it..thanks again!!
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).
FYI, I'm using LibreOffice 6.3.3.2. To get sbase to work, I had to install the following. (I asked for libreoffice-base, but had to add sdbc. I threw in the other database connectors (mysql, hsqldb, and postgresql), and the rest got pulled in as dependencies.) libtommath1:amd64 libfbclient2:amd64 libib-util:amd64 firebird3.0-server-core:amd64 firebird3.0-utils:amd64 libreoffice-base-drivers:amd64 libreoffice-base:amd64 libreoffice-evolution:amd64 libreoffice-java-common:all libreoffice-sdbc-firebird:amd64 libreoffice-dmaths:all libreoffice-templates:all libhsqldb1.8.0-java:all libreoffice-sdbc-mysql:amd64 libreoffice-mysql-connector:amd64 libreoffice-sdbc-hsqldb:amd64 libreoffice-sdbc-postgresql:amd64 (Firebird was pulled in as one of the dependencies.)
Fantastic!! I struggled a lot to make a data base (I'm not a computer guy, at all) untill I found your channel. I love your pedagogy. In the past I tried some books but all of them or taught data base design from a rather teoretical view without specific software connection or explained how to use a software assuming one is already profiency in data base design. With your material I've been introducing me in both subjects simultaneously. I'm currently using LibreOffice 6; any chance you update the material to cover the new LO capabilities. Please. PD: sorry for my english, I'm an spanish speaker so...
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... >employess /me watches on with hopeful optimism...
Ma perchè in Italia non esistono persone come te che fanno Video cosi interessanti??? WHY?? Come posso fare a tradurre i tuoi video??? Grazie di esistere
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?
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 :))
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 TheFrugalComputerGuy.com
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
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...
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)
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. Help! -Kay
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
Hello Mr. Frugal. I need to create a customer searchable database for issues they may face and possible solutions (which will come in the form of recommended books and/or activities). Does that make sense? Would LibreOffice Base be a good place to create that database? I get the sense that it can receive information (currently in Excel) but my main reason in switching to a database would be because the Excel list we have is clunky for our customers. Thank you for your advise.
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?
These videos you have created are incredible. But for me,my eyes just gloss over when trying to learn. Sir can you point me to exactly which program within Libre Office i can use to create a phone number list and then alphabetize the list? Thank you very much.
why don't you use LibreOffice Calc? Set up columns with a name/title in the top row and fill in the information you have. Suggested column name/titles; phone, last name, first name, street, city, zip, birthday, etc You can easily add information any time and sort by any column (last name) to put all in alpha order any time
When I clicked save, and did not have all the required fields filled in, it tried to use the number 1 and could not. It moves on to number 2 - That is what happened to the number 1 in the video. Anytime you try and save a record without all the required fields filled in, you will loose an auto-populate number.
Hello Michael, I want to create a new table with a primary key as a series which is a combination of text + | + Integer (5001) for example. How can I achieve this? Please help me here.
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? Anyone? Bueller?
your video is good but when we enter data type as number or integer then while filling the table details that should not accpet charachters.. its accepting no & char both.. how?? can you reply?
I thought the whole purpose of a database was to relate sets of data (aka 'tables')...i.e. relational. I don't see what the point was in being shown to start a database, make one table, (which I could figure out with no help) & then 'bye'... It seems an intro to database lesson would move on from this point, not begin at this point... So I feel I didn't gain much & still feel left in the dark of the mystery of how to create a true database & ensure it actually 'relates' & will do so without error
Cc, image a second table named "Salaries", that looks like this: EmpNum Salary ------------ ------- 3 $5 4 $7 The "Employees" table doesn't tell you that employee #3 makes $5, but that table "relates" to the "Salary" table via the unique index key "employee-id" (the "Salary" table's unique index key is probably something different, maybe just the record number). Thus you can look up the employee by name using the "Employees" table, find his/her "employee-id", and relate that to the record in the "Salary" table to get his/her salary.
I have no idea if you are still monitoring responses here. I am getting a message straight away that no Java installation could be detected. I don't know what Java is, but there are so many Java products in the App Store I have no idea what I need to install. Please advise! Thank you.
Hi there. Please try using this link: www.java.com/en/download/manual.jsp because that's where I downloaded the Java needed. Download the 64 bit "offline' version and run the database program again. I hope that helps.
Does anyone have experience getting leading 0s to stay on an address database. I have gotten so far using the videos but I am now stuck on entering zips
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
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!!!
Thank you for a useful series of tutorials; I have worked through several of them. However, Base (Version: 6.4.7.2) will not open my new database due to absence of Java. The LibreOffice help files describe the problem but there is nothing of any use to help resolve it. Any advice?
Try Downloading java from here: java.com/en/download/manual.jsp
You may need to make sure LibreOffice can see it by choosing the version you just downloaded in:
Tools - Options - LibreOffice - Advanced - select Java runtime environment
@@MichaelsTechTutorials Thanks alot,I was facing this issue for a while.
Did you realize that this video series is now 11 ELEVEN years old?
It is nearly impossible to find current videos that actually work with current software whenever I look for it. But, in spite of ten years worth of advancements, and I watched LibreOffice go through some great changes, especially with their Writer,
YOUR BASE VIDEOS ARE STILL UP TO DATE!!!!!!!!
I want to let you know that I love that your videos are short, sweet and to the point. I don't think I have even given MS Access the time of day for over 25-30 years. Yet, yesterday, I was able to pick up Base, and using your videos, completely from scratch, design and build an application I wanted in just a few hours.
Your videos are short, sweet and to the point so I was able to go directly to the episode I needed to get every answer I needed when I needed it. I only had to Google one question and the answer was at the top of the first page in the summary.
I don't know if I'm praising you, which you deserve for your wonderful video series, or LibreOffice for being so consistent and keeping their Base software so backward compatible.
Have a great day and keep up the good work.
I appreciate you
Shabbat Shalom
91 vids of 11 min... That's 1001 minutes so I'm looking at 16 hours and 41 minutes...
I want to learn this program in one day! Thank you so much!
Then you're in luck - put on a pot of joe and get crackin. in less than a solar day you'll be an expert.
If you want to build a Libre Office Base project, this is the spot. There are 94 videos that cover almost every thing you need to know. I taught myself to use Microsoft Access and spent many months developing a project 20 years ago. As I watch these videos they bring back the concepts and provide the steps I need to create a new project in Base an excellent program at a Frugal price. Thank you FRUGAL Computer Guy. Wish I had this info 20 years ago but You Tube didn't exist then (did it).
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.
This man is a true legend. Thank you for your hard work!
Okay I am back for the second time. The first time was to watch the necessary ones to accomplish my immediate goal. Ha. Now I am back for the overall training. Thank You! Your material is absolutely superior.
This playlist is so useful to a beginner like myself. Even after 8 years, they do seem to be very accurate.
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.
+richardnz100 Hello Richard, Yes they did take a lot of time to plan, prepare, and record. I really appreciate my viewers and try to give them the best tutorials I can. Yes, I received the donation - Thank you. Receiving donations really means a lot to me because it shows me you got enough value out of my videos to make a donation. And I do appreciate the people who click the thumbs up and/or take the time to send a thank you comment too - Thanks for watching!
This entire playlist is super helpful, and it will probably save me in my IGCSE examinations
thank you so much...even after 10 years this is still important. God bless you
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.
Warmly
River~~
It's a fantastic collection of database videos you've made here, I've been following them with great pleasure, they've been very helpful, Thanks for the great work
Thanks Man I had IT Practicals u saved my life and my marks........i had no idea what to do about this practicals n i saw this video
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.
pretty well, i found best teacher here for start learning about Libre Base. Thankyou so much bro,,
Thank you for explaining that it is only a front-end and that you are using the default!
As an IT student. I'm so glad I found you, where have you been!! I love all of your vids, I think you're underrated.
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.
Thanks.
Thanks for sharing your knowledge with us! LibreOffice at least for my pc is much more easier to use and doesn't consume much space from my HD! I will definitively watch the rest of the playlist!
Hi! Thank you so much for this!! This is super helpful
You are very welcome. Thank you for the kind words in both languages.
Wow! Thank you for the great tutorials. Very clear and step by step. In the process of importing my records from Access and making forms and reports into Libre. I've been a Word user since it was on a 360K floppy. It's horrible what Office and Windows have become. When my DB in Libre is set up, I'm done with MSOffice.
Heartly salutations to you, good sir!
Great to see the continuation of the LibreOffice series.
KUDOS!
Hi Thanks for the straight forward, informative and clear instructions on how to build a data base.
Really helpful my exam is tomorrow thank you
I loved it. You're way better than my professor.
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.
You can find the LibreOffice Playlist at:
th-cam.com/play/PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV.html
Thanks!
Thank you, all videos are of great value and information. Very professionally put together.
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...
A little info on what a LibreOffice Base actually is - would be nice. Anyway, vid is cool
Thanks a lot for these newbie to professional tutorials .
This video clearly goes around the most obvious problem with Libre and OpenOffice base. Not being able to search fields on the form is so basic that Base is by no means a serious competitor to Microsoft Access - a developer simply can not make a user friendly GUI.
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.
Thank you so much!! I did not have ms office 365 but in school, we were supposed to do it...I found this as a good alternative but because of the java issue, I could not use it..thanks again!!
This is an excellent Tutorial Series
Thank you, I'll try it. Again, thank you for your tutorials. I like your voice and delivery.
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).
Good evening! I'm from Mozambique. I would like to thank you for the video, I really liked it.
Long series, huh? Oooo nnice... Can't wait! :)
Haha I'm here 20 hours before my practicals haha
FYI, I'm using LibreOffice 6.3.3.2. To get sbase to work, I had to install the following. (I asked for libreoffice-base, but had to add sdbc. I threw in the other database connectors (mysql, hsqldb, and postgresql), and the rest got pulled in as dependencies.)
libtommath1:amd64
libfbclient2:amd64
libib-util:amd64
firebird3.0-server-core:amd64
firebird3.0-utils:amd64
libreoffice-base-drivers:amd64
libreoffice-base:amd64
libreoffice-evolution:amd64
libreoffice-java-common:all
libreoffice-sdbc-firebird:amd64
libreoffice-dmaths:all
libreoffice-templates:all
libhsqldb1.8.0-java:all
libreoffice-sdbc-mysql:amd64
libreoffice-mysql-connector:amd64
libreoffice-sdbc-hsqldb:amd64
libreoffice-sdbc-postgresql:amd64
(Firebird was pulled in as one of the dependencies.)
Thalavaaa!! Your are great.. life saver thanks.
Fantastic!! I struggled a lot to make a data base (I'm not a computer guy, at all) untill I found your channel.
I love your pedagogy. In the past I tried some books but all of them or taught data base design from a rather teoretical view without specific software connection or explained how to use a software assuming one is already profiency in data base design.
With your material I've been introducing me in both subjects simultaneously.
I'm currently using LibreOffice 6; any chance you update the material to cover the new LO capabilities. Please.
PD: sorry for my english, I'm an spanish speaker so...
You explain so clearly thanks!!!!
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...
>employess
/me watches on with hopeful optimism...
Ma perchè in Italia non esistono persone come te che fanno Video cosi interessanti??? WHY??
Come posso fare a tradurre i tuoi video??? Grazie di esistere
Thank you very much you did a great job explaining this.
Thank you sir Thank you sir
Thank you so much sir
Your tutorials are wonderful.
Could you recreate them for the current version of Libreoffice?
My request you to make a awesome tutorial on Calligra Plan as you did lot of awesome tutorial.. really thankful to you.
Thank you so much , you helped me alot. Pls keep on providing
Thanks a lot... just what i needed for libreOffice Base
This is great Feedback to hear. I'm using these videos for similar reasons. Thanks Frugal!
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?
Thank you very much for this great tutorial!
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 :))
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 TheFrugalComputerGuy.com
6:27 TRIGGERED!!!!
Lol
bwahahha ... the times we live in
very professional and helpful videos! many thanks!
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
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...
App Hindi bolo please samj Nahi ATA hai
This LibreOffice Base looks very much like MS Access, with some interesting improved features.
but can u save the database in documents?
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)
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.
Help!
-Kay
Thank you, helped very much
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
Wow, I recognise that voice... are you from Canada or once lived there?
Hello Mr. Frugal. I need to create a customer searchable database for issues they may face and possible solutions (which will come in the form of recommended books and/or activities). Does that make sense? Would LibreOffice Base be a good place to create that database? I get the sense that it can receive information (currently in Excel) but my main reason in switching to a database would be because the Excel list we have is clunky for our customers. Thank you for your advise.
You're Welcome!
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?
These videos you have created are incredible. But for me,my eyes just gloss over when trying to learn. Sir can you point me to exactly which program within Libre Office i can use to create a phone number list and then alphabetize the list? Thank you very much.
why don't you use LibreOffice Calc? Set up columns with a name/title in the top row and fill in the information you have.
Suggested column name/titles; phone, last name, first name, street, city, zip, birthday, etc You can easily add information any time and sort by any column (last name) to put all in alpha order any time
@@robertr7707 Thank you very much. Thats exactly what i did, Took a while to figure out how but i did it! Thanks again
I love it how you say odb. :D
Please, today, 2020, do you still recommend the use of Base as a SQL database? Is it updated to nowadays standards? Thanks!
The primary index lacks the id number 1. Is this a bug of the wizard? I doubt is the default behavior of any SQL.
When I clicked save, and did not have all the required fields filled in, it tried to use the number 1 and could not. It moves on to number 2 - That is what happened to the number 1 in the video. Anytime you try and save a record without all the required fields filled in, you will loose an auto-populate number.
TheFrugalComputerGuy Thanks! So...basically a bug.
There is a problem with "subscription"...… It clears and don't remains "ON".....
Hello Michael, I want to create a new table with a primary key as a series which is a combination of text + | + Integer (5001) for example. How can I achieve this? Please help me here.
Question I'm making a data base for a Dog grooming business.....Should i make a separate table for the dogs?
I have to monitor payments and debt for 90 users. Which part of LO would serve the purpose?
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?
Anyone?
Bueller?
see that thefrugalcomputerguy.com/grouppg.php?ser=15&grp=2
your video is good but when we enter data type as number or integer then while filling the table details that should not accpet charachters.. its accepting no & char both.. how?? can you reply?
Yes even i have doubt please conferm sir..🙏
Thanks! Very nice and helpfull
Thank you So much
I thought the whole purpose of a database was to relate sets of data (aka 'tables')...i.e. relational. I don't see what the point was in being shown to start a database, make one table, (which I could figure out with no help) & then 'bye'... It seems an intro to database lesson would move on from this point, not begin at this point... So I feel I didn't gain much & still feel left in the dark of the mystery of how to create a true database & ensure it actually 'relates' & will do so without error
Cc, image a second table named "Salaries", that looks like this:
EmpNum Salary
------------ -------
3 $5
4 $7
The "Employees" table doesn't tell you that employee #3 makes $5, but that table "relates" to the "Salary" table via the unique index key "employee-id" (the "Salary" table's unique index key is probably something different, maybe just the record number). Thus you can look up the employee by name using the "Employees" table, find his/her "employee-id", and relate that to the record in the "Salary" table to get his/her salary.
Its really a biggest help
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?
I have no idea if you are still monitoring responses here. I am getting a message straight away that no Java installation could be detected. I don't know what Java is, but there are so many Java products in the App Store I have no idea what I need to install. Please advise! Thank you.
Hi there. Please try using this link: www.java.com/en/download/manual.jsp
because that's where I downloaded the Java needed. Download the 64 bit "offline' version and run the database program again. I hope that helps.
Hey, After opening the save table i am not able to insert the data . The option isn't available.🙄 Help me out.
have you done any video on how to add audio to a slide show presentation .
Does anyone have experience getting leading 0s to stay on an address database. I have gotten so far using the videos but I am now stuck on entering zips
if you set the zip field to text instead of numeric, the 0's will be treated as characters and stay where you want them.
Why does the ID Number go from 0 to 2 ?
It starts from 1 in my pc
Ronny, he answers this in a comment above which starts with "Good eye to catch that!"
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
Can u tell me ,how can I print a database file done using design view in OpenOffice Base?
Thanks I learned a lot !!!
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!!!
Thanks, cool video!
Thank you
Hello sir.I am unable to insert record in table insert record option is Disable..jre also installed then to same problem what to do?
thankyou for good basic tutorial that I needed, but it says I need 64 bit?
What if I have a field, Last Name, and I have duplicate last names. How do I deal with this?
.
how can you export the database file? Like i want to send it to my social media account or send it to a chats.