Difference between revisions of "Talk:Base"

From Apache OpenOffice Wiki
Jump to: navigation, search
m (internal link fix)
m
 
(4 intermediate revisions by one other user not shown)
Line 1: Line 1:
Proposed change to page [[User:DrewJensen|Drew]] 06:07, 12 September 2007 (CEST)
+
The old page:
 
+
'''OpenOffice.org 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, [[wikipedia:MySQL|MySQL]], and [[wikipedia:PostgreSQL|PostgreSQL]].   
'''OpenOffice.org 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.org. 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.
 
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.org. 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==
+
== Maintaining your data ==
 +
 
 
With Base, you can:
 
With Base, you can:
  
Line 13: Line 13:
 
* Use the Report Wizard to produce impressive reports from your data
 
* Use the Report Wizard to produce impressive reports from your data
 
* Use the Form Wizard to create 'instant' database applications
 
* Use the Form Wizard to create 'instant' database applications
 +
 +
== Using your data  ==
  
 
Using Base, you can not only browse your data, but also:
 
Using Base, you can not only browse your data, but also:
Line 19: Line 21:
 
* View subsets of your data with simple (one-click) or complex (logical query) filters  
 
* 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  
 
* Create powerful queries to show your data in new ways, including summaries and multi-table views  
 +
**[[Built-in functions and Stored Procedures]]
 
* Produce reports  
 
* Produce reports  
 
** The Base module includes the Report Wizard for creating quick tabular reprts
 
** The Base module includes the Report Wizard for creating quick tabular reprts
** With Version 2.3 the [[SUN Report Builder]] is available as an extension for more complex reprting needs
+
** With Version 2.3 the [[SUN_Report_Builder]] is available as an extension for more complex reprting needs
 
* Base allows you to extend it's functionality via built in scripting capabilities
 
* Base allows you to extend it's functionality via built in scripting capabilities
 +
 +
== Technical footnotes ==
  
 
BASE includes a full version of the [http://hsqldb.org/ HSQL] database engine. It can also access [[dBASE]] files natively for simple database work, but it cannot open MS-Access files natively.
 
BASE includes a full version of the [http://hsqldb.org/ HSQL] database engine. It can also access [[dBASE]] files natively for simple database work, but it cannot open MS-Access files natively.
 +
 +
A user maintained FAQ page for questions regarding migrating MS-Access databases to Base is being started at [[MSA-Base Faq]]
  
 
For more advanced requirements, Base supports many popular databases database 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]].
 
For more advanced requirements, Base supports many popular databases database 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===
 
* [http://documentation.openoffice.org/manuals/oooauthors2/0110GS-GettingStartedWithBase.pdf|Getting started with Base] as single PDF file.
 
* [http://documentation.openoffice.org/manuals/OOo2.x/user_guide2_draft.pdf|OOo2 User Guide] as single PDF file.
 
* [http://www.pitonyak.org/database/ Andrew Pitonyak's Base documents]
 
 
===Technical Documentation===
 
* [http://dba.openoffice.org/specifications/index.html Specification Documents]
 
* [[Base New Driver Tutorial]]
 
 
===Wiki Articles===
 
* [[Built-in functions and Stored Procedures|Base Query functions]]
 
* [[MSA-Base Faq|Working with MS Access files]]
 
* [[Standard Distributed Schema]]
 
* [[A club membership database]]
 
* [[Bibliographic Database]]
 
* The embedded data engine HSQLdb
 
** [[HSQLDB:Tips and Tricks]]
 
** [[HSQLDB Localization]]
 
** [[HSQL Text Table Integration]]
 
  
 
== Official sites ==
 
== Official sites ==
Line 53: Line 39:
 
* [http://dba.openoffice.org/ Base project page]
 
* [http://dba.openoffice.org/ Base project page]
 
* [http://www.openoffice.org/product/base.html Base marketing page]
 
* [http://www.openoffice.org/product/base.html Base marketing page]
* [http://qa.openoffice.org/ooQAReloaded/DatabaseTeamsite/ooQA-TeamDatabase.html Base QA]
 
 
<b>the mailto and owner would need to be changed appropriately </b><br>
 
''Ahutor: [mailto:atjensen@openoffice.org?subject:OOoWiki Base page] [[User:DrewJensen|Drew]] 21:01, 11 September 2007 (CEST) '<br>
 
''Please do not change the logical content of this site without
 
acknowledge of the author or the [http://wiki.services.openoffice.org/wiki/Project_Lead OOo QA Project Lead/Co-Leads].''
 
  
 
[[Category:Database]]
 
[[Category:Database]]
[[Category:Base Documentation]]
 
[[Category:Suite component]]
 
[[Category:Quality Assurance]]
 

Latest revision as of 21:21, 28 October 2009

The old page: OpenOffice.org 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.org. 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.

Maintaining your data

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 your data

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 reprts
    • With Version 2.3 the SUN_Report_Builder is available as an extension for more complex reprting needs
  • Base allows you to extend it's functionality via built in scripting capabilities

Technical footnotes

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.

A user maintained FAQ page for questions regarding migrating MS-Access databases to Base is being started at MSA-Base Faq

For more advanced requirements, Base supports many popular databases database 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.

Official sites

Personal tools