Creating Queries in OpenOffice.org Base

Jun 09, 2009, 12:31 (0 Talkback[s])

"Either can be an efficient way of finding the information you want, especially when you're dealing with thousands of records. Of course, in the hands of an expert, queries can be far more precise -- and complicated -- than a filter, but, if you are using OpenOffice.org Base, then the analogy generally holds true, although queries are slightly more complicated than filters to set up. When saved in Base for long term use, a query becomes a view.

"You can create a query in any database set up in Base. In fact, Base offers you three different ways to write a query: in a wizard, which guides you through the process; in Design View, which provides a minimal amount of guidance, and in SQL View, which provides no guidance at all. If you are a database expert, you might prefer Design or SQL View. However, like the Function Wizard in Calc or the introductory wizard in Impress, Base's Query Wizard has the advantage of helping you organize your thoughts while requiring no previous knowledge. For most people or purposes, there is no reason not to use the wizard."

Complete Story

Related Stories:

• OpenOffice.org New User Orientation(Jun 02, 2009)
• OpenOffice.org Base: Editing Information in a Database(Mar 19, 2009)
• OpenOffice.org Base: Creating basic databases and tables(Feb 19, 2009)
• OOo Basic crash course: Creating charts with Base and Calc(Aug 01, 2008)
• Getting Data Into and Out of an OpenOffice.org Base Database(Apr 25, 2008)
• Back Up and Print Your Blog with OpenOffice.org Base(Nov 02, 2007)
• SearchOpenSource: Turning data into information with functions in OpenOffice.org Base(Nov 07, 2006)
• SearchOpenSource: Exporting Data from an OpenOffice.org Base Database(Oct 31, 2006)