Ask Your Question
2

To learn LibreOffice Base are there introductions or tutorials?

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

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

3 Answers

Sort by » oldest newest most voted
7

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

EasyTrieve gravatar image

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

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

image description

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

edit flag offensive delete link more

Comments

LibreOffice Documentation website on Base:

https://documentation.libreoffice.org...

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

@Olivier, thanks. Merged it in.

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

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

DrewJensen gravatar image

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

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
0

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

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
Login/Signup to Answer

Question Tools

3 followers

Stats

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

Seen: 8,223 times

Last updated: Nov 17