NeoBase

From NeoWiki

(Difference between revisions)
Jump to: navigation, search
Revision as of 18:30, 19 September 2007 (edit)
Lorinda (Talk | contribs)
(User Guides and Documentation - add link; move Solveig's link closer to top)
← Previous diff
Revision as of 02:02, 22 September 2007 (edit) (undo)
Lorinda (Talk | contribs)
(User Guides and Documentation - add new link)
Next diff →
Line 25: Line 25:
===User Guides and Documentation=== ===User Guides and Documentation===
* [http://documentation.openoffice.org/manuals/index.html OpenOffice User Guide Chap 7] * [http://documentation.openoffice.org/manuals/index.html OpenOffice User Guide Chap 7]
-* [http://www.geocities.com/rbenitez22/OOo/FormsAndDialogs.pdf PDFon Designing Forms], including writing form-related macros. By Roberto Benitez +* [http://www.geocities.com/rbenitez22/OOo/FormsAndDialogs.pdf PDF on Designing Forms], including writing form-related macros. By Roberto Benitez
* [http://openoffice.blogs.com/openoffice/2007/08/a-huge-pdf-prin.html PDF Article on Advanced Report Techniques], Including SQL-Based Calculated Fields on Reports. By Solveig Haugland * [http://openoffice.blogs.com/openoffice/2007/08/a-huge-pdf-prin.html PDF Article on Advanced Report Techniques], Including SQL-Based Calculated Fields on Reports. By Solveig Haugland
 +*[http://wiki.services.openoffice.org/wiki/Built-in_functions_and_Stored_Procedures Built-in Functions and Stored Procedures] that can be used in Queries.
* [http://hsqldb.org/doc/guide/guide.html HSQLDB User Guide] (HSQLBD is the underlying database engine in Base) * [http://hsqldb.org/doc/guide/guide.html HSQLDB User Guide] (HSQLBD is the underlying database engine in Base)
* [http://www.postgresql.org/files/documentation/books/aw_pgsql/index.html Good guide on SQL], Suggested by the HSQLDB User Guide * [http://www.postgresql.org/files/documentation/books/aw_pgsql/index.html Good guide on SQL], Suggested by the HSQLDB User Guide

Revision as of 02:02, 22 September 2007

This article is not up to date, or it needs structural or stylistic changes to conform with the rest of this wiki.

NeoOffice Base allows you to either connect to an external database (MySQL, dBase, Calc, etc.) or to create an "embedded database" using the included HSQL database engine. In addition to entering and editing data, you can create Queries, Views, and Forms, as well as access any registered datasource in Writer and Calc documents.

Contents

Tips and Hints in the Wiki

Note that some of the pages are "stubs" consisting mostly of links to discussions on trinity.

Additional tips can be found on the New Articles Needed page, which contains links to stub pages and/or threads in trinity that need to be developed into full blown articles.

Connecting to and Importing from Other Databases

Other Base Tips in the Wiki


Documentation, Tutorials, etc.

User Guides and Documentation

Books

Forums

Probably the best place to ask questions about using Base.

Tutorials

A new series of tutorials being written by one of NeoWiki's editors. Follows the creation of a database for tracking birding trips and sightings.
step-by-step construction of a small relational database for employees, with some advanced concepts like forms toward the end

Miscellaneous

includes lots of good links to documentation and tutorials


This article in other languages: Français
Personal tools