LibreOffice Base (04) Create a Table Using a Calc File

[@pauleast8558]

What a pleasure, to watch a properly planned and scripted tutorial delivered clearly and at a good pace. After the rubbish you so often get on KZbin, it's a breath of fresh air.

[@freedom.Humanity.Palestine]

thank you very much , its still be a geath help for people like me after these all years !

[@juancarlosrojas5641]

Excellent tutorial. I have been searching for so long, and finally ! Thanks

[@MichaelsTechTutorials]

You're welcome guys, Thanks for the comments!

[@_Peterhof_]

Thank you (!) from Saint-Petersburg, Russia

[@RamDwivedi-u5w]

Nice very useful 👍

[@dsulvadarius]

Who else thinks this is awesome?

[@anurasenarathna1703]

Wow. Very useful.

[@robitops1547]

Well done, Very handy & easy

[@joelgarciadacosta6215]

Excelent! Congratulations!!

[@bigf000t5]

Thanks a lot, now I can learn english and Libreoffice too ;) ... I hope :)).

[@donaldm1156]

In Calc Is it possible to import and save data from database on a spreadsheet, I want to have on the same sheet two accounts: checking account and savings account from Base table???

[@bittertruth27]

Plz help me to know what is difference between data management in libre office calc and office base.... We can create table in calc too...

[@davidh.4944]

A database is not simply a table. It's a collection of individual, but related, data points that can be flexibly searched, sorted, grouped, and manipulated in various ways for analysis and viewing. With a properly populated database, you could, for example, easily generate a list of all employees who are under 35, work in factory #2, and have a perfect safety record, and sort the output by sex and length of employment. Notice also that tables are often used to populate databases, and databases are often used to generate tables. They are complementary systems.

thank you. is it possible insert a new field or change order of fields in a table after saving?

[@MichaelsTechTutorials]

You can change the order before the table is saved, once it is saved, new fields will be added at the end of the table. Right click and select edit to add or delete fields or change the field properties.

[@snowinthepark1620]

In LibreOffice Calc, when I put the cursor in a cell, I can read all the text inside the cell. Is it possible to read all the text inside a LibreOffice Base cell without expanding the cell size ?

[@loloo2010]

good job!!!

[@SOBIESKI_freedom]

Good one! :)

[@uiopuiop3472]

thanks

[@mx22a]

Thanks a lot!

[@robt2151]

A very helpful series of videos; it is good that they remain available despite being several years old. However, an observation from LibreOffice Base version 6.2.7.1 - After 4 days of trying I have finally managed to get the process at 4:44 to work, almost. It turns out that the transfer process does not recognise columns in a user-defined format and will drop the data in those columns - eg dates shown in DD/MMM/YYYY format in Calc must be reformatted before the transfer will succeed.

[@vishalpratapsingh]

Thanks!

[@choctawcountywic8362]

i am having a problem. when i create table the first way, how do i get the data to show in the cells without clicking each cell to see what is in each one? Also when i drag the tab to create a table, the headings are just showing column1,2,etc and i still have to click each cell to see what data is in each and it doesn't recognize the key already made from the first table of this lesson! HELP!

[@MichaelsTechTutorials]

Choctaw County Wic Program I'm sorry, I'm having trouble understanding your question. Can you give me a specific time in the video that is not working for you? Or not working as I show in the video?

[@choctawcountywic8362]

TheFrugalComputerGuy the cells of the table are blank of the data until i click on each cell. it will show the data in each cell with the data highlighted. Up to Base Video (10), may i get you to provide me the base file completed from the video? I lost the files up to that point. Another ?, will encrypting your home folder on linux really keep people from stealing info from your libreoffice base files? Thanks for all your work and your prompt responses! May God bless you!

[@MichaelsTechTutorials]

Choctaw County Wic Program All the databases created in the video can be found here: thefrugalcomputerguy.com/libreoffice-base/index.php - encrypting the home folder will work or you can use a MySQL or MariaDB database that supports passwords, this is explained after video 80.

[@itube0033]

First of all, let me say, many many thanks for these series of tutorials. I have a question, though, that is nagging my for the last three days, I tried to find an answer over the internet without success. My question is: How can be the ID established that instead of starting with 0 and continuing, can be set as a mixture of letters and numbers: say student001, student002... I tried to do it in a table and I made a real mess. I hope you have the answer to that and I thank you in advance.

[@MichaelsTechTutorials]

You can make the Primary ID a text string, the only drawback is you need to type it in each time (you can't auto-increment a text string). the other option is to store is as a number on the database, and when you print it on a form or report, concatenate the text-string and the numeric ID (student||ID).

[@itube0033]

TheFrugalComputerGuy Thank you for your reply. Is there a way that the numeric ID can start with a number different than 0?

[@petergriffiths]

Thank You

[@MarcMasonMusic]

Thank you for the great tutorials! I have a question The template.. templates.libreoffice.org/template-center/family-address-book-with-birthday-reminders ..has a "table view" called "Address Label Formats", I cannot figure out what they did to do that. Do one of your tutorials explain this process? Thank you so much for your work.!

[@MichaelsTechTutorials]

That table is a View - which is a query that acts like a table. To create the "Address Label Formats" view, go in into tables, create view, and then in design mode type in: SELECT "FirstName" || ' ' || "LastName" ||' ' || "Address" AS "John Doe - Address" , "FirstName" , "LastName" , "Address" FROM "InformationTable" The actual data is on the InformationTable. Because of programmer arguments of the actual usefulness of a "View" and whether they should ever be used or not, I choose not to include them in this tutorial series.