Difference between revisions of "Documentation/Database"
(→Testing) |
m (→Features) |
||
(26 intermediate revisions by 8 users not shown) | |||
Line 1: | Line 1: | ||
− | + | {{Database/Lang|Documentation/Database}} | |
+ | '''OpenOffice Base''' is the database application of [[OpenOffice.org]], similar to [[MSA-Base_Faq|Microsoft Access]]. Base allows the creation and manipulation of databases and the building of forms and reports to provide easy access to data for end-users. As with Access, Base is able to work as a front-end to a variety of database systems, including Access databases (JET), [[ODBC]] data sources, [[wikipedia:MySQL|MySQL]], and [[wikipedia:PostgreSQL|PostgreSQL]]. | ||
− | + | Base was not available in the 1.x versions of OpenOffice.org, becoming part of the suite starting with version 2.0. Base enables you to manipulate database data seamlessly within OpenOffice. Create and modify tables, forms, queries, and reports, either using your own database or Base’s own built-in [[wikipedia:HSQLDB|HSQLDB]] database engine. Base offers a choice of using Wizards, Design Views, or SQL Views for beginners, intermediate, and advanced users. | |
− | + | ==Features== | |
+ | With Base, you can: | ||
− | + | * Create new tables for your data - and also change them as your needs change | |
− | + | * Maintain indexes on the tables to make data access faster | |
− | + | * View a table in an editing grid and add, change, and delete records | |
− | * | + | * Use the Report Wizard to produce impressive reports from your data |
− | + | * Use the Form Wizard to create 'instant' database applications | |
− | + | ||
− | + | Using Base, you can not only browse your data, but also: | |
− | : | + | |
− | + | ||
− | * | + | * Perform simple (single column) or complex (multi-column) sorts |
− | + | * View subsets of your data with simple (one-click) or complex (logical query) filters | |
− | + | * Create powerful queries to show your data in new ways, including summaries and multi-table views | |
+ | * Produce reports | ||
+ | ** The Base module includes the Report Wizard for creating quick tabular reports | ||
+ | ** With Version 2.3 the [[SUN Report Builder]] is available as an extension for more complex reporting needs | ||
+ | * Base allows you to extend its functionality via built in scripting capabilities | ||
− | + | BASE includes a full version of the [https://hsqldb.org/ HSQL] database engine. It can also access [[dBASE]] files natively for simple database work, but it cannot open MS-Access files natively. | |
− | + | ||
− | + | ||
− | + | For more advanced requirements, Base supports many popular databases natively (Adabas D, ADO, Microsoft Access, MySQL), or any database through industry-standard [[ODBC]] and [[JDBC]] drivers. It also supports any [[LDAP]] compliant address book, as well as common formats such as Microsoft Outlook, Microsoft Windows, and [[Mozilla]]. | |
− | + | ||
− | + | ||
− | + | ||
− | * | + | ==Resources== |
− | : [ | + | ===User Documentation=== |
− | : ' | + | * [[Documentation/OOoAuthors User Manual/Getting Started/Getting Started with Base|Getting Started with Base]] on the wiki. |
+ | :: [https://wiki.openoffice.org/w/images/3/3c/0108GS33-GettingStartedWithBase.pdf Getting started with Base] as single PDF file. | ||
+ | :: [https://wiki.openoffice.org/w/images/5/53/0100GS-GettingStarted.pdf OOo2 User Guide] as single PDF file. | ||
+ | * [https://www.pitonyak.org/database/ Andrew Pitonyak's Base documents] | ||
+ | * [http://sheepdogguides.com/fdb/fdb1main.htm Tutorials on using ooBase] from Sheepdog Guides | ||
+ | * [[/connectivity|Connecting]] with non-embedded databases | ||
+ | * [[/Reports|Working with reports]] | ||
− | * [ | + | ====Wiki Articles and more==== |
+ | * The embedded data engine HSQLdb | ||
+ | ** [[HSQLDB:Tips and Tricks]] | ||
+ | ** [[HSQLDB Localization]] | ||
+ | ** [[HSQL Text Table Integration]] | ||
+ | * [[SUN Report Builder]] | ||
+ | ** DesktopLinux.com article April 2007[[https://www.desktoplinux.com/news/NS5712122864.html Chris Preimesberger]] | ||
+ | * [[Built-in functions and Stored Procedures|Base Query functions]] | ||
+ | * [[MSA-Base Faq|Working with MS Access files]] | ||
+ | * [[Standard Distributed Schema]] | ||
+ | * [[Bibliographic Database]] | ||
+ | * [[A club membership database]] | ||
+ | * DerbyToursDB [[User:HCPotter]] | ||
− | === | + | ===Technical Documentation=== |
− | * Sun Report Builder | + | * [https://www.openoffice.org/dba/specifications/index.html Specification Documents] |
− | + | ** [http://dba.openoffice.org/specifications/ReportDesigner.odt Sun Report Builder (SRB)] | |
− | + | ** [http://dba.openoffice.org/specifications/Conditional%20Formatting.odt Conditional formatting dialog in SRB] | |
+ | * [[Base New Driver Tutorial]] | ||
+ | *[[Logging JDBC Activity|Logging JDBC Activity]] new feature 2.? | ||
− | + | == Official sites == | |
− | + | ||
− | + | ||
− | * | + | * [https://dba.openoffice.org/ Base project page] |
− | + | * [https://www.openoffice.org/product/base.html Base marketing page] | |
− | : | + | * [https://qa.openoffice.org/ooQAReloaded/DatabaseTeamsite/ooQA-TeamDatabase.html Base QA] |
− | + | * '''the mailto and owner would need to be changed appropriately''' | |
− | * | + | : ''Maintainer: [mailto:atjensen@openoffice.org?subject:OOoWiki Base page] [[User:DrewJensen|Drew]] 21:01, 11 September 2007 (CEST) '' |
− | + | : This page is under [http://creativecommons.org/licenses/by-sa/3.0/legalcode CC by-sa] since 2009-02-02 | |
− | + | : ''Please do not change the logical content of this site without acknowledge of the author or the [https://wiki.openoffice.org/wiki/Project_Lead OOo QA Project Lead/Co-Leads].'' | |
− | + | <div id="Template_CC-BY-SA"> | |
− | + | {|align="left" width="100%" border="0" cellspacing="4" cellpadding="0" style="border-top: 1px solid #666; font-size: xx-small; margin-top: 20px; text-align: right;" | |
− | + | | Content on this page is licensed under the [http://creativecommons.org/licenses/by-sa/3.0/legalcode Creative Common Attribution 3.0 license (CC BY-SA)]. | |
− | + | |} | |
− | + | </div> | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | : '' | + | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | [ | + | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | [ | + | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | [http:// | + | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | == | + | |
− | == | + | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
+ | [[Category:Database]] | ||
+ | [[Category:Base Documentation]] | ||
[[Category:Quality Assurance]] | [[Category:Quality Assurance]] | ||
− | [[Category: | + | [[Category:Files]] |
+ | [[Category:PDF]] |
Latest revision as of 14:18, 13 April 2022
OpenOffice Base is the database application of OpenOffice.org, similar to Microsoft Access. Base allows the creation and manipulation of databases and the building of forms and reports to provide easy access to data for end-users. As with Access, Base is able to work as a front-end to a variety of database systems, including Access databases (JET), ODBC data sources, MySQL, and PostgreSQL.
Base was not available in the 1.x versions of OpenOffice.org, becoming part of the suite starting with version 2.0. Base enables you to manipulate database data seamlessly within OpenOffice. Create and modify tables, forms, queries, and reports, either using your own database or Base’s own built-in HSQLDB database engine. Base offers a choice of using Wizards, Design Views, or SQL Views for beginners, intermediate, and advanced users.
Contents
Features
With Base, you can:
- Create new tables for your data - and also change them as your needs change
- Maintain indexes on the tables to make data access faster
- View a table in an editing grid and add, change, and delete records
- Use the Report Wizard to produce impressive reports from your data
- Use the Form Wizard to create 'instant' database applications
Using Base, you can not only browse your data, but also:
- Perform simple (single column) or complex (multi-column) sorts
- View subsets of your data with simple (one-click) or complex (logical query) filters
- Create powerful queries to show your data in new ways, including summaries and multi-table views
- Produce reports
- The Base module includes the Report Wizard for creating quick tabular reports
- With Version 2.3 the SUN Report Builder is available as an extension for more complex reporting needs
- Base allows you to extend its functionality via built in scripting capabilities
BASE includes a full version of the HSQL database engine. It can also access dBASE files natively for simple database work, but it cannot open MS-Access files natively.
For more advanced requirements, Base supports many popular databases natively (Adabas D, ADO, Microsoft Access, MySQL), or any database through industry-standard ODBC and JDBC drivers. It also supports any LDAP compliant address book, as well as common formats such as Microsoft Outlook, Microsoft Windows, and Mozilla.
Resources
User Documentation
- Getting Started with Base on the wiki.
- Getting started with Base as single PDF file.
- OOo2 User Guide as single PDF file.
- Andrew Pitonyak's Base documents
- Tutorials on using ooBase from Sheepdog Guides
- Connecting with non-embedded databases
- Working with reports
Wiki Articles and more
- The embedded data engine HSQLdb
- SUN Report Builder
- DesktopLinux.com article April 2007[Chris Preimesberger]
- Base Query functions
- Working with MS Access files
- Standard Distributed Schema
- Bibliographic Database
- A club membership database
- DerbyToursDB User:HCPotter
Technical Documentation
- Specification Documents
- Base New Driver Tutorial
- Logging JDBC Activity new feature 2.?
Official sites
- the mailto and owner would need to be changed appropriately
- Maintainer: Base page Drew 21:01, 11 September 2007 (CEST)
- 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.
Content on this page is licensed under the Creative Common Attribution 3.0 license (CC BY-SA). |