We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

To learn LibreOffice Base are there introductions or tutorials?

asked 2016-11-03 01:09:30 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

How is the best way to quickly and comprehensively learn to use LibreOffice Base?

This might seem like an obvious question that needs no answer here. A web search turns up many pages. There are the official help pages. But even they are not complete, nor that useful.

(Please do NOT close this question. I think it would be best to leave questions like this open so it can be extended and answers voted on, to make it an even better resource for students.)

edit retag flag offensive close merge delete

5 Answers

Sort by » oldest newest most voted

answered 2016-11-03 01:10:57 +0200

EasyTrieve gravatar image

updated 2018-11-17 02:44:52 +0200


LO 6.1 help.


  • I think this video tutorial is an excellent and comprehensive way to learn base! For those of us who already know how to use MS Access or the like, it may seem a little slow, but it does a great job of thoroughly covering all of the minor details that are so necessary to know if you really want to use Base.



LibreOffice.org: (a fork of OpenOffice)

Latest Base Handbook: Version 4.0.
Base Handbook 4.0 (database) - 259 pages overall.

LibreOffice Basic Help

The newer documentation is found at the LibreOffice Document Foundation wiki site, and includes:


When starting from OpenOffice.org, the documentation was a bit hard to find. Look here.

Because browsing is a little slow you might want to download pdf manuals, but there's a trick: Select the page you want, then click PDF (but you won't get the manual yet). Then click on Download as PDF in the left pane under Print/export. Once rendering is finished click Download to get the pdf file.


Andrew Pitonyak



1) HyperSQLdb aka HSQLDB (the default "Embedded database" in LibreOffice/OpenOffice). Abbreviated HSQL. (Not to be confused with HeidiSQL).

Note! Even thought it doesn't say it here, the installed version in LO is currently the older HSQL 1.8, not 2.3!

image description

New 2.3 features can only be used if you split your database (i.e. use a connector to V2.3), and not use the "Embedded database".

image description

2) Firebird - The new, upcoming default embedded data base to someday take over ... (more)

edit flag offensive delete link more


LibreOffice Documentation website on Base:


Olivier gravatar imageOlivier ( 2018-11-12 15:07:57 +0200 )edit

@Olivier, thanks. Merged it in.

EasyTrieve gravatar imageEasyTrieve ( 2018-11-17 02:45:33 +0200 )edit

I have watched the first 4 videos in the tutorial series cited at the top of this answer and all I can say is "Fantastic!" My career as a software developer has not led me in the direction of learning to use LibreOffice but I've kept it installed on my Linux boxes since my start with Linux back in 1999... through the StarOffice => OpenOffice => LibreOffice eras... The one thing I've always avoided is LibreOffice Base because I just didn't know what to do with it. I've been a MySQL admin and user since I first discovered it in 2000 but have always worked with it via the CLI (i.e. bash). I finally grew tired of avoiding LibreOffice Base tonight and decided to come here for guidance with it... and in that video series I have found it! Thank you ever so much for ...(more)

MykeC gravatar imageMykeC ( 2019-02-12 08:50:29 +0200 )edit

answered 2018-11-12 14:53:20 +0200

DrewJensen gravatar image

updated 2018-11-12 15:07:59 +0200

For anyone interested in helping to improve Base Documentation for LibreOffice you are cordially invited to get involved with LibreOffice Documentation Team.

Information on getting started with the group (slightly out of date and actively being updated) can be found here: https://wiki.documentfoundation.org/D... (One example of the changes happening, in the past the group used web resources at the ODFAuthors web site, which was hosted by TDF, for collaboration and work flow management - the group is transitioning to use the TDF NextCloud server with LibreOffice Online integration for this and the ODFAuthors site will be retired.)

For English speakers there is a weekly on-line meeting every Wednesday. All that is required to join in one of the meetings is a web browser and a microphone that works. Details are available on the documenation mailing list at The Document Foundation. ( You find information about that ML at https://wiki.documentfoundation.org/D... )

For non English speakers the Native Language groups have their own arrangements.

At present the group is focused on, and actively working on, the update of the Calc Guide to bring it current with the pending LO 6.2 release.However with the looming switch from HSQLdb to Firebird for the embedded database in Base there will be a push to address Base documentation soon.

Looking forward to meeting you there.

edit flag offensive delete link more

answered 2017-05-01 12:07:03 +0200

JohnHa gravatar image

Go to http://www.libreoffice.org/ and click GET HELP and then select DOCUMENTATION. You arrive at the LO Documentation page.

AOO has manuals - see AOO Documentation

If this helps then please tick the answer and/or show you like it with an uptick.

edit flag offensive delete link more


There is no AOO manual for Base

pulkitkrishna@outlook.com gravatar imagepulkitkrishna@outlook.com ( 2020-05-25 08:54:59 +0200 )edit

answered 2020-06-18 18:30:37 +0200

MSPhobe gravatar image

a) Personally, I find the "offical" guides excellent. However, it can be nice to hear something more than one way...

... so...

b) http://sheepdogguides.com/fdb/fdb1main.htm OpenOffice / LibreOffice database guides, tutorials, and "how To's". (Text and graphics only. No videos.)

May be of interest. Yes! That looks like it is "all about OpenOffice Base"... but much of it remains relevant. Some pages have been edited to explain differences, where differences exist. In a few cases, whole new, LibreOffice Base from- birth- pages have been created, for instance...

http://sheepdogguides.com/fdb/LO0FirebirdOn.htm How to allow Firebird as an option as the embedded database in LibreOffice:

... which I commend to you on general grounds... both the tutorial, and the idea of switching to Firebird.

edit flag offensive delete link more

answered 2020-05-25 08:56:48 +0200

pulkitkrishna@outlook.com gravatar image

The LibreOffice Base Guide 6.2 has been released. You can download the pdf here:- https://wiki.documentfoundation.org/i... The LibreOffice 6.4 Guide will be released soon. The Docs team is working on it. You can help by joining the docs team:- https://documentation.libreoffice.org...

edit flag offensive delete link more
Login/Signup to Answer

Question Tools



Asked: 2016-11-03 01:09:30 +0200

Seen: 19,621 times

Last updated: Jun 18 '20