Note
These conditions apply to numbers, letters (using the
alphabetical order), and dates.
1) Since we are only searching for one thing, we will use the default
setting of
Match all of the following.
2) We are looking for a particular artist, so select
is equal to
.
3) Enter the name of the artist in the
Value
box. Click Next.
Step 4: Select type of query.
We want simple information, so the default setting:
Detailed query
is
what we want. Click Next at the bottom of the window.
Note
Since we have a simple query, the
Grouping
and
Grouping
conditions
are not needed. Those two steps are skipped in our
query.
Step 5: Assign aliases if desired.
We want the default settings. Click Next.
Step 6: Overview.
Name the query (suggestion:
Query_Artists
). To the right of this are
two choices. Select
Display Query
. Click Finish.
Step 7: Modify the query.
We are skipping this step since we have nothing to modify. If you select
the Modify Query choice, the query would open in Design view. To
make modifications, follow the instructions in the next section, “Using
the Design View to create a query”.
Using the Design View to create a query
Creating a query using Design View is not as hard as it may first seem.
It may take multiple steps, but each step is fairly simple.
What fuel economy is our vehicle getting (miles per gallon in the USA)?
This question requires creating two queries, with the first query being
used as part of the second query.
292 Getting Started with OpenOffice.org 3
Comments to this Manuals