Base
From OpenEducationWiki
| Table of contents |
Introduction
Base is the database component of OpenOffice. It enables users to manipulate database data within OpenOffice.org by creating and modifying tables, forms, queries, and reports. It is possible to use an existing 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.
Screenshot
Where to get Support
- FAQ - http://dba.openoffice.org/FAQ/FAQ.html
- Mailing List - http://dba.openoffice.org/servlets/SummarizeList?listName=users (To join OOo mailing lists, users first need to join the project by going to http://www.openoffice.org/servlets/Join - but anyone may view and search the archives.
Links and Resources
Base Tutorials in Flash from Digital Distribution (http://www.digitaldistribution.com/community/gettingtoknowbasepart1/)
This links to 3 small Flash tutorials that cover:
- setting up a simple table,
- creating a form,
- generating a dynamic report.
"Getting Started With Base" PDF from OpenOffice.org (http://documentation.openoffice.org/manuals/oooauthors2/0110GS-GettingStartedWithBase.pdf)
This PDF covers creating a database, showing what is contained in a database and how the different parts are used by OOo. It also covers using the Base component of OOo to register other data sources, eg a database, spreadsheet or text document.
Exploring Open Office as a Unified DBMS Front-End (http://www.naccq.ac.nz/bacit/0303/2005vanaardt_OpenOffice.htm)
The OpenOffice.org suite contains a database front-end component that can be used to access a number of Database Management Systems (DBMS's). This paper explains the use of OpenOffice Base to access various DBMS's and explores its use as a teaching tool.
Student databases and higher order thinking (http://www.tsof.edu.au/research/reports04/wavell.asp)
The use of databases has given students a real insight into the many facets of research. Their ownership of the design of the database played an important part in their desire to discover information. Students showed perseverance in finding information about their topic and also realised the need to be specific about their findings.

