|
|
(20 intermediate revisions by 6 users not shown) |
Line 1: |
Line 1: |
− | '''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.
| + | #REDIRECT [[Database]] |
− | | + | |
− | New to version 2, '''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 [[HSQL]] 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 in a wide variety of formats using the Report AutoPilot
| + | |
− | * Base allows you to extend it's functionality via built in scripting capabilities
| + | |
− | ** A user lead export utility implemented in the OOBasic for embedded HSQLDB databases
| + | |
− | *** [[Export Manager]] Create / Modify / Execute data export jobs
| + | |
− | *** [[CSV export]] for Tables, Queries and Rowsets
| + | |
− | *** [[XML export]] for Tables, Queries and Rowsets
| + | |
− | | + | |
− | == 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.
| + | |
− | | + | |
− | 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 ==
| + | |
− | | + | |
− | * [http://dba.openoffice.org/ Base project page]
| + | |
− | * [http://www.openoffice.org/product/base.html Base marketing page]
| + | |
− | | + | |
− | [[Category:Database]]
| + | |
− | [[Category:Suite component]]
| + | |