|
|
(21 intermediate revisions by 6 users not shown) |
Line 1: |
Line 1: |
− | 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.
| + | #REDIRECT [[Database]] |
− | | + | |
− | == 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 page ==
| + | |
− | | + | |
− | The marketing page: http://www.openoffice.org/product/base.html
| + | |
− | | + | |
− | The project page: http://dba.openoffice.org/product/base.html
| + | |
− | | + | |
− | | + | |
− | [[Category:Database]]
| + | |
− | [[Category:Suite component]]
| + | |