\<bookmark_value\>databases;creating queries\</bookmark_value\>\<bookmark_value\>filtering;data in databases\</bookmark_value\>\<bookmark_value\>queries;defining\</bookmark_value\>\<bookmark_value\>defining;queries\</bookmark_value\>\<bookmark_value\>wizards;database queries\</bookmark_value\>\<bookmark_value\>Query Wizard\</bookmark_value\>

Working with Queries

If you often want to access only a subset of your data that can be well defined by a filter condition, you can define a query. This is basically a name for the new view at the filtered data. You open the query and see the current data in the table layout that you defined.

Creating a New Query With the Query Wizard

In LibreOffice you can create a new query using the Query Wizard:

1. Open the database file where you want to create the new query.

2. In the left pane of the database window, click the \<emph\>Queries\</emph\> icon.

3. Click \<emph\>Use Wizard to Create Query\</emph\>.

Creating a New Query With the Design View

1. Open the database file where you want to create the new query.

2. In the left pane of the database window, click the \<emph\>Queries\</emph\> icon.

3. Click \<emph\>Create Query in Design View\</emph\>.

You see the Query Design window.