OpenOffice Tutorial: Create a new query using the design view
- To create a new query using the design view, first click here on the "Queries" icon.
- Then on the tasks area, click on the option "Create Query in Design View..."
- The Query design view should open.
- 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....
- ...and then click on "Add."
- Just repeat that process if you want a other tables to be included in the query. Otherwise, once finished click on "Close."
- You should see your added table here with its fields.
- Now, double-click on the field you want to sort or filter. In this example we are choosing "LastName."
- Notice that the selection we just made appeared here.
- If there are other fields you want to query just double-click on them until the fields you want appear below.
- Next, choose how to sort the records for this field by clicking here on the "sort" row. First we will sort the LastName field.
- For this field we want to sort it in ascending order. Just click on this down-arrow and click on the option "ascending."
- We shall do the same for the FirstName field as well. Just click on the down-arrow, and then click on the "ascending" option.
- 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.
- The Save As window should appear.
- Now, click on this field and type in the name you want for this query.
- Afterwards, just click on "OK."
- Great! We have created a query using the design view.
by Kaj Kandler
Create a new query using the design view
This screencast demonstrates how to create a new query using the design view. You learn:
- How to open the design view for a new query.
- How to add tables as source data for a query.
- How to select fields for a query.
- How to set the sorting order in a field for a query.
- How to save a query.
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.