To learn LibreOffice Base are there introductions or tutorials?

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.)

2 Likes
Macro Help with Base
Open Spreadsheet Mimimised - BASIC
Macro insert data into table control @dialog
Macro to hide textbox in Base form
List field values
I would like to set column widths using a Macro in Calc
Problems with Combo Box in Base
libreoffice base how to filter a table in a form using a combobox ..other
Conditional activation of a form field
Macro - Order Sub routine
Base listbox basics - my first one not working
What am I doing wrong in making a format code HH:MM:SS.000?
base auto populate new record
BaseTools getDataSource (solved)
Is it possible to use the function IIF in LibreOffice Base?
Date parameters problem
Events in Base?
base to base connection
Base Programming?
LibreOffice Basic - Getting all items listed in a ComboBox
Is there a LibreOffice BASIC (or other) REPL interactive shell?
Libreoffice Writer: Macro can't get the value of a table control
Accelerators for option buttons do nothing
Update Text Box from File Selection
Problems with OpenFormAtRecord() extra question
How to write stored procedures in libreoffice base
How to populate text fields from a sql query.
Radio button actuating a text box
I want to create a database for movies i watch
How does one access form controls / developer tools in LibreOffice?
6.1 Base Tutorials
Base forms in basic
Accessing Attributes for Drawing Objects in a Base Form
Calc Basic - Access filtered data from macro code
Libreoffice as appliance service tool
How to execute a python function before XSCRIPTCONTEXT is available?
libre office base general
Get the label of the button that was just pressed to call a macro
Base Handbook example "Media_with_Macros" has Macro errors when executing, please help fix
Does libreoffice base work with mac mohave
Base form data does not load first time
Documentação para Macros Basic - Calc - Referencia
Button to open new form - macro?
LibreOffice Base How can I concatenate fields using macros?
best way set up data analysis
Standalone form with macro
Why am I struggling to learn macros using LibreOffice basic and its API?
Split Database questions
Base: Duplicating a Record in a database
OTF Dialogs (On-the-fly) - altering font, text size etc
Creating a 'Menu' form or Console
Drawpage Property or Method Not Found?
Is there a list of methods for form fields?
How to Auto-Fill Table Using Sub-form links
Cannot get some infomation into table via form
Capabilities of Visual Basic Base (Version: 6.4.3.2)
How to force navigation between controls on a form
Libre Office Database Guide or Manual
Table not updating from form when 'default' values applied
How to automate removing trailing spaces in a Base text field?
export base to calc
BASE: how change label in Label field?
Copy field from a list to other table on base
extract textfield text from dialogue
Editing a SubForm
replacing the refresh button
Access my report from "My Macros" Library
How similar or different are the Base implimentations under LibreOffice vs OpenOffice?
Is LibreOffice for me?

GENERAL

LO 6.1 help.


VIDEO TUTORIALS

  • 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.

UNDERLYING TECHNOLOGY


BASE / MACRO DOCUMENTATION


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:


OpenOffice.org:

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.


INDEPENDENT DOCUMENTATION

Andrew Pitonyak


FORUMS:


IMPORTANT DATABASE DOCUMENTATION

  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”.

  1. Firebird - The new, upcoming default embedded data base to someday take over in place of HSQLDB.

  2. MariaDB - A free binary replacement for MySQL, from the original developer of MySQL. - Commercial products are at .com or Community (free) products are at .org

  3. MySQL


USEFUL EXTENSIONS

1) MRI - UNO Object Inspection Tool (required):

“My Reflection and Introspection” tool is an UNO object browser which allows a UNO object’s properties, methods, interfaces and services to be easily examined.

2) XRay Object Inspection Tool (alternate to MRI above)

3) Access2Base (optional) - Library: emulate MS Access VBA.

LibreOffice Documentation website on Base:

https://documentation.libreoffice.org/en/english-documentation/base/

@ohallot, thanks. Merged it in.

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 pointing me to its existence.

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/Documentation/Development (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/Documentation/Mailing_List )

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.

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.

There is no AOO manual for Base

The LibreOffice Base Guide 6.2 has been released. You can download the pdf here:- https://wiki.documentfoundation.org/images/b/bf/BG62-BaseGuide.pdf The LibreOffice 6.4 Guide will be released soon. The Docs team is working on it. You can help by joining the docs team:- Join the Documentation Team ! | LibreOffice Documentation - Your documentation for LibreOffice

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

… so…

b) Table of Contents - LibreOffice / OpenOffice Database: Base Tutorials - fdb1main 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.