Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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.

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.


Also get Documentation/Publications here.

VIDEO TUTORIALS

  • I think this video tutorial is an excellent and comprehensive way to learn base!

    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.


Also UNDERLYING TECHNOLOGY


BASE / MACRO DOCUMENTATION

OpenOffice.org:

When starting from OpenOffice.org, the documentation is 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 Documentation/Publications 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.

LibreOffice.org:

Their main help link takes you to the older and introductory documentation. See the Base Handbook 4.0 (database) - 259 pages overall.

The newer documentation is found at the here.

LibreOffice Document Foundation wiki site, and includes:


INDEPENDENT DOCUMENTATION

Andrew Pitonyak


FORUMS:


IMPORTANT DATABASE DOCUMENTATION

1) HyperSQLdb (the default "Embedded database" in LibreOffice/OpenOffice). Abbreviated HSQL. (Not to be confused with HeidiSQL). Note, the installed version is currently 1.8, not 2.3.

2) MariaDB

3) MySQL - Commercial products are at .com or Community (free) products are at .org


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) Access2Base (optional)

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

OpenOffice.org:

When starting from OpenOffice.org, the documentation is 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.

LibreOffice.org:

Their main help link takes you to the older and introductory documentation. See the Base Handbook 4.0 (database) - 259 pages overall.

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


INDEPENDENT DOCUMENTATION

Andrew Pitonyak


FORUMS:


IMPORTANT DATABASE DOCUMENTATION

1) HyperSQLdb (the default "Embedded database" in LibreOffice/OpenOffice). Abbreviated HSQL. (Not to be confused with HeidiSQL). Note, the installed version is currently 1.8, not 2.3.

2) MariaDB

3) MySQL - Commercial products are at .com or Community (free) products are at .org


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) Access2Base (optional)

- Library: emulate MS Access VBA.

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

OpenOffice.org:

When starting from OpenOffice.org, the documentation is 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.

LibreOffice.org:

Their main help link takes you to the older and introductory documentation. See the Base Handbook 4.0 (database) - 259 pages overall.

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


INDEPENDENT DOCUMENTATION

Andrew Pitonyak


FORUMS:


IMPORTANT DATABASE DOCUMENTATION

1) HyperSQLdb (the default "Embedded database" in LibreOffice/OpenOffice). Abbreviated HSQL. (Not to be confused with HeidiSQL). Note, the installed version is currently 1.8, not 2.3.

2) MariaDB

3) MySQL - Commercial products are at .com or Community (free) products are at .org


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) Access2Base (optional) - Library: emulate MS Access VBA.

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

OpenOffice.org:

When starting from OpenOffice.org, the documentation is 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.

LibreOffice.org:

Their main help link takes you to the older and introductory documentation. See the Base Handbook 4.0 (database) - 259 pages overall.

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


INDEPENDENT DOCUMENTATION

Andrew Pitonyak


FORUMS:


IMPORTANT DATABASE DOCUMENTATION

1) HyperSQLdb (the default "Embedded database" in LibreOffice/OpenOffice). Abbreviated HSQL. (Not to be confused with HeidiSQL). Note, the installed version is currently 1.8, not 2.3.

2) MariaDB

3) MySQL - Commercial products are at .com or Community (free) products are at .org


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) Access2Base (optional) - Library: emulate MS Access VBA.


If my answer helped you, please vote on the left by clicking on the "∧"

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

OpenOffice.org:

When starting from OpenOffice.org, the documentation is 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.

LibreOffice.org:

Their main help link takes you to the older and introductory documentation. See the Base Handbook 4.0 (database) - 259 pages overall.

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


INDEPENDENT DOCUMENTATION

Andrew Pitonyak


FORUMS:


IMPORTANT DATABASE DOCUMENTATION

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

Note! Even thought it doesn't say it here, the installed version in LO is currently the older HSQL 1.8, not 2.3.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".

  • User Guide - 2.3.4 Guide - for version 2.3.4 - 325 pages

image description

2) MariaDB

3) MySQL - Commercial products are at .com or Community (free) products are at .org


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) Access2Base (optional) - Library: emulate MS Access VBA.


If my answer helped you, please vote on the left by clicking on the "∧"

[Updated to include link to reference manual for Firebird DB. - March 3, 2017]

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

OpenOffice.org:

When starting from OpenOffice.org, the documentation is 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.

LibreOffice.org:

Their main help link takes you to the older and introductory documentation. See the Base Handbook 4.0 (database) - 259 pages overall.

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


INDEPENDENT DOCUMENTATION

Andrew Pitonyak


FORUMS:


IMPORTANT DATABASE DOCUMENTATION

1) HyperSQLdbHyperSQLdb 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 in place of HSQLDB.

3) MariaDB

3) - A free binary replacement for MySQL, from the original developer of MySQL.

4) MySQL - Commercial products are at .com or Community (free) products are at .org


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) Access2Base (optional) - Library: emulate MS Access VBA.


If my answer helped you, please vote on the left by clicking on the "∧"

[Updated to include link to reference manual for Firebird DB. - March 3, links to underlying C++ technology, and also Python programming information. - April 30, 2017]

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

OpenOffice.org:

When starting from OpenOffice.org, the documentation is 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.

LibreOffice.org:

Their main help link takes you to the older and introductory documentation. See the Base Handbook 4.0 (database) - 259 pages overall.

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


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 in place of HSQLDB.

3) MariaDB - A free binary replacement for MySQL, from the original developer of MySQL.

4) MySQL - Commercial products are at .com or Community (free) products are at .org


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) Access2Base (optional) - Library: emulate MS Access VBA.


If my answer helped you, please vote on the left by clicking on the "∧"

[Updated to include links to underlying C++ technology, and also Python programming information. - April 30, BASE TUTORIAL - From Newbie to Advocate in a one, two... three! - May 26, 2017]

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

OpenOffice.org:

When starting from OpenOffice.org, the documentation is 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.

LibreOffice.org:

Their main help link takes you to the older and introductory documentation. See the Base Handbook 4.0 (database) - 259 pages overall.

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


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 in place of HSQLDB.

3) MariaDB - A free binary replacement for MySQL, from the original developer of MySQL.

4) MySQL - Commercial products are at .com or Community (free) products are at .org


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) Access2Base (optional) - Library: emulate MS Access VBA.


If my answer helped you, please vote on the left by clicking on the "∧"

[Updated to include links link to BASE TUTORIAL - From Newbie to Advocate in a one, two... three! - May 26, 2017]

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

OpenOffice.org:

When starting from OpenOffice.org, the documentation is 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.

LibreOffice.org:

Their main help link takes you to the older and introductory documentation. See the Base Handbook 4.0 (database) - 259 pages overall.

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


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 in place of HSQLDB.

3) MariaDB - A free binary replacement for MySQL, from the original developer of MySQL.

4) MySQL - Commercial products are at .com or Community (free) products are at .org


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) Access2Base (optional) - Library: emulate MS Access VBA.


If my answer helped you, please vote on the left by clicking on the "∧"

[Updated to include link to BASE TUTORIAL - From Newbie to Advocate in a one, two... three! XRay introspection tool - May 26, 30, 2017]

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

OpenOffice.org:

When starting from OpenOffice.org, the documentation is 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.

LibreOffice.org:

Their main help link takes you to the older and introductory documentation. See the Base Handbook 4.0 (database) - 259 pages overall.

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


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 in place of HSQLDB.

3) MariaDB - A free binary replacement for MySQL, from the original developer of MySQL.

4) MySQL - Commercial products are at .com or Community (free) products are at .org


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.


If my answer helped you, please vote on the left by clicking on the "∧"

[Updated to include link to XRay introspection tool - May 30, 2017]

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

OpenOffice.org:

When starting from OpenOffice.org, the documentation is 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.

LibreOffice.org:

Their main help link takes you to the older and introductory documentation. See the (a fork of OpenOffice)

LibreOffice Basic Help

Base Handbook 4.0 (database) - 259 pages overall.

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


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 in place of HSQLDB.

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

4) MySQL - Commercial products are at .com or Community (free) products are at .org


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.


If my answer helped you, please vote on the left by clicking on the "∧"

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.

LibreOffice.org: (a fork of OpenOffice)

LibreOffice Basic Help

Base Handbook 4.0 (database) - 259 pages overall.

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


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 in place of HSQLDB.

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

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