Plan-B for OpenOffice.org & LibreOffice, learning office productivity software with videos
Tech Support for OpenOffice.org & LibreOffice

OpenOffice Tutorial: Create a new query using the design view

How-To: OpenOffice Tutorial: Create a new query using the design view
  1. To create a new query using the design view, first click here on the "Queries" icon.
  2. Then on the tasks area, click on the option "Create Query in Design View..."
  3. The Query design view should open.
  4. First, you'll be asked to add a table where the data for your query will be based upon. Just click on the table's name once....
  5. ...and then click on "Add."
  6. Just repeat that process if you want a other tables to be included in the query. Otherwise, once finished click on "Close."
  7. You should see your added table here with its fields.
  8. Now, double-click on the field you want to sort or filter. In this example we are choosing "LastName."
  9. Notice that the selection we just made appeared here.
  10. If there are other fields you want to query just double-click on them until the fields you want appear below.
  11. Next, choose how to sort the records for this field by clicking here on the "sort" row. First we will sort the LastName field.
  12. For this field we want to sort it in ascending order. Just click on this down-arrow and click on the option "ascending."
  13. We shall do the same for the FirstName field as well. Just click on the down-arrow, and then click on the "ascending" option.
  14. Great! Once you're done with setting up your query look for the diskette icon here. This is the save button. Click on it to save this query.
  15. The Save As window should appear.
  16. Now, click on this field and type in the name you want for this query.
  17. Afterwards, just click on "OK."
  18. Great! We have created a query using the design view.

by

Show OpenOffice Tutorial: Create a new query using the design view

Create a new query using the design view

This screencast demonstrates how to create a new query using the You learn:

  • How to open the design view for a new
  • How to add tables as source data for a query.
  • How to select for a query.
  • How to set the sorting order in a field for a query.
  • How to save a query.

Advanced topics

For advanced functionality with similar results see:

OpenOffice.org™ is a registered trademark of Oracle.
LibreOffice™ is a trademark of The Document Foundation.
Windows® is a registered trademark of Microsoft Corporation in the United States and other countries.

Further questions?

*
*
*
*
* required fields