From Apache OpenOffice Wiki
Jump to: navigation, search

Base Icon.png

Base Project

Please view the guidelines
before contributing.

There are documents also in DE - FR - ES -PT

This page is hosted by the OO Database Docu Coordinator, who are members of the OOo Database QA Team. You can find here links to Base documentation ordered by languages and topics. Feel free to add missing documents to this list.

This documentation describes basic functionality about Apache- /Libre- /Star- Office Base which doesn't change.

Resources related to Apache OpenOffice Base:


The following links are in English.



  • Forum
Lots of Base examples and answers to questions in the Base Forum
  • Base
Description of the features of OpenOffice Base (short overview), Documentation resources and official sites
  • User Guides (Getting Started with Base)
Getting Started with Base - PDF
or Getting Started with Base wiki version
Learn how to create a database, queries, forms and reports and connect to and use other data sources within Apache OpenOffice Base.
  • Base Guide
Base Guide Planning
Base Guide Outline Proposal from OOoAuthors
  • Mid Level Base Tutorial
Mid Level Base Tutorial and the subsequent SQL Base Tutorial SQL code
Initial Authors: Mariano Casanova, Andrew 'Drew' Jensen ✞
  • Beginners - Example Database - Base Tutorial
Initial author: Andrew 'Drew' Jensen ✞
This tutorial covers creating a first database using OOo Base. It is intended for those that have not used Base before or those that have never used any database manager.
  • Beginners - Example Database - "MELOMAN" Music Database
Initial author: Vlad Seredkine
Database presentation
“MELOMAN” Open Office Music Database
“MELOMAN Open Office 3.1 Data Base Application. Internal Design Specification”
“Meloman test cases”
  • Base and Macros
Pitonyak's document
Initial author: Andrew Pitonyak
This documentation focuses on operating a database with the help of OpenOffice Macros.
  • Database: "ooBase", aka "Base"- From getting started to more advanced
Tutorials and "How to"s... 45 from one author at
Initial author: TK Boyd
Both specific tasks and fundamental skills are explained.
A section introducing the use of macros added 5/09.
  • Bringing data into OpenOffice 2.0's database
Initial author: Solveig Haugland ✞
Screenshot guided tutorial on how to import data into Base.
  • New Features in 3.1
New Features
Initial author: Reizinger Zoltán
Compiled from mailing list
  • New Features in 3.2
New Features
Initial author: Reizinger Zoltán
Compiled from mailing list
  • New Features in 3.3
New Features
Initial author: Reizinger Zoltán
Compiled from mailing list
  • New Features in 3.4
New Features
Initial author: Reizinger Zoltán
Compiled from mailing list




description followed
  • Sun Report Builder (Reference)
description follow
  • Sun Report Builder Documentation
Basic Features
  • Functions in Reports
Functions and Expressions
description followed
  • Functions in Reports
SUN Report Builder/Functions
description followed


  • Working basis to make the user guide better
description followed
  • Using Macros in Database Files
'Specification to develop this functionality


  • FAQ (Base)
  • Common tasks
Initial author: Andrew 'Drew' Jensen ✞
Many good questions, no answers.


  • HSQLDB Tips and Tricks
description followed


  • Base New Driver Tutorial
Initial author: Robert Vojta
This small How-To contains a simple step-by-step introduction on how to put your driver inside the connectivity module. The second part of this document covers differences between a driver in connectivity module and a driver in an UNO package.
  • Better Database Drivers
Initial author:Eric Bischoff
Some ideas for a better and simpler infrastructure for database drivers
  • Connecting to Microsoft Access
Initial author: Regina Henschel
These article describes how to connect to a Microsoft Access database file, if you use a MS Windows operating system.
  • OpenOffice Base - Database Drivers
  • Connecting with MySQL
  • An overview page
Native PostgreSQL Driver
  • SQL-lite Driver
  • mdb-sdbc-driver-0.1.0
Initial author: Wind Li (yl146652 [at] openoffice [dot] org)
It is a try to connect a Linux system to MS Access. There is no further development.
  • A working page
  • MSA-Base Faq
  • Firebird driver update for
Jaybird Base support
  • Using csv/text files as editable data source.
OOo users forum Tutorial



  • Base Example (Overview)
Initial author: Frank Schönheit
  • Standard Distributed Schema

Concrete Examples

  • A club membership database
Initial author: Andrew 'Drew' Jensen ✞
Description of creating an example database
  • API - Code snippets
Useful code snippets solving frequently asked questions.
  • Base Example
  • Three table example, with supporting essay- Project management
Link to essay, which has link to download a small database
The database illustrates techniques explained in the essay. It is provided as an illustration, not for the data it contains.
  • Base Example


Initial author: Andrew 'Drew' Jensen ✞
Starting Point for all kind of AOo Database Questions


  • Main Point of AOo Database Testing
AOo Database QA Team Site
Initial Author: User:Clu Christoph Lukasiak
  • Main Starter Document for QA Newbies
AOo QA How to Start Document
Initial Author: User:Wg Wolfram Garten
Connecting To A Remote MySQL Database] (event. 1.x)


The following Links are showing French documents. If someone translate them we can show here the corresponding links.


The following Links are showing German documents. If someone translate them we can show here the correponding links.

  • End user documentation


The following Links are showing Portugese documents. If someone translate them we can show here the correponding links.


El siguiente Links esta escrito en español.


AOO Database Development
AOO Database QA
AOO General Database Info

Initial author : Mechtilde Stehmann 24 September 2007
This page is under CC by-sa since 2009-02-02
Please do not change the logical content of this site without acknowledge of the author or the OOo QA Project Lead/Co-Leads. This side is linked by the online help.
Content on this page is licensed under the Creative Common Attribution 3.0 license (CC BY-SA).
Personal tools
In other languages