|
|
NeoBase
From NeoWiki
(Difference between revisions)
| Revision as of 02:02, 22 September 2007 (edit) Lorinda (Talk | contribs) (→User Guides and Documentation - add new link) ← Previous diff |
Revision as of 02:08, 22 September 2007 (edit) (undo) Lorinda (Talk | contribs) (Move Data Types list; separate out HSQLDB and SQL links) Next diff → |
||
| Line 28: | Line 28: | ||
| * [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://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] ( | + | * [http://hsqldb.sourceforge.net/doc/guide/ch09.html#datatypes-section List of Data Types] |
| + | |||
| + | ====HSQLDB and SQL Documentation==== | ||
| + | * [http://hsqldb.org/doc/guide/guide.html HSQLDB User Guide] (HSQLDB 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 | ||
| * [http://www.sqlcourse.com/ Introduction to SQL] | * [http://www.sqlcourse.com/ Introduction to SQL] | ||
| Line 53: | Line 56: | ||
| *[http://en.wikipedia.org/wiki/OpenOffice.org_Base Wikipedia article on Base] | *[http://en.wikipedia.org/wiki/OpenOffice.org_Base Wikipedia article on Base] | ||
| :includes lots of good links to documentation and tutorials | :includes lots of good links to documentation and tutorials | ||
| - | + | ||
| {{botlangbarEN|[[Fr:NeoOffice Base|Français]]}}<!-- [[De:|Deutsch]] [[It:|Italiano]] [[Es:|Español]]}}--> | {{botlangbarEN|[[Fr:NeoOffice Base|Français]]}}<!-- [[De:|Deutsch]] [[It:|Italiano]] [[Es:|Español]]}}--> | ||
| [[Category:NeoOffice]][[Category:Tips and Hints]] | [[Category:NeoOffice]][[Category:Tips and Hints]] | ||
Revision as of 02:08, 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
- Configuring MySQL using JDBC and NeoOffice 2.x
- Configuring MySQL using ODBC
- Configuring postgresql
- Configuring FileMaker Pro
- dbf and MS Access tips
Other Base Tips in the Wiki
- Using a Calc spreadsheet as a data source
- Importing Data from Address Book
- Using the Mail Merge Wizard (in Writer, but using Base datasources)
- To Base and Back Again A new series of Base tutorials in the wiki.
Documentation, Tutorials, etc.
User Guides and Documentation
- OpenOffice User Guide Chap 7
- PDF on Designing Forms, including writing form-related macros. By Roberto Benitez
- PDF Article on Advanced Report Techniques, Including SQL-Based Calculated Fields on Reports. By Solveig Haugland
- Built-in Functions and Stored Procedures that can be used in Queries.
- List of Data Types
HSQLDB and SQL Documentation
- HSQLDB User Guide (HSQLDB is the underlying database engine in Base)
- Good guide on SQL, Suggested by the HSQLDB User Guide
- Introduction to SQL
Books
- Books on database design from OOoForum.org
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
- Visual tutorial for Base from InPics
- Two-part introduction to Base for database beginners: Part 1, Part2
- The simplest way to make databases in OpenOffice.org An 3 page article by Solveig Haugland.
Miscellaneous
- includes lots of good links to documentation and tutorials
This article in other languages: Français
