

Base could function as a front-end to a number of different database systems, including Access databases (JET), ODBC data sources, MySQL and PostgreSQL. OpenOffice Base is not only good as a personal use all-you-need database, in parallel offers the full HSQL relational database engine. This standalone file is then registered in Apache OpenOffice for universal access to the data-source. To provide this function, a Base wizard is used to create a connection file (.odb).

OpenOffice Base tool is great for daily routine tasks such as tracking of personal CD collections and at the same time it works well for producing a corporate monthly departmental sales reports. Base can be used to generate connections to various data-sources, thereby enabling data access/integration across the Apache OpenOffice suite. Base lets you manipulate databases seamlessly, you can create and modify tables, forms, queries and reports. Base is an own OpenOffice suite database application, which is an analog to Microsoft Access.
