Operation Manual

3) Repeat this process for CD-Collection.DatePurchased.
4) Click Next.
Step 3: Select the search conditions
The search conditions allow us to compare the name we entered with the names of the artist in our
database and decide whether to include a particular artist in our query results or not.
• is equal to: the same as
• is not equal to: not the same as
• is smaller than: comes before
• is greater than: comes after
• is equal or less than: the same as or comes before
• is equal or greater than: the same as or comes after
• like: similar to in some way
Note
These conditions apply to numbers, letters (using 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 CD-Collection. Artist in the Fields list and is
equal to as the Condition.
3) Type 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.
Steps 5 and 6 of the wizard are skipped in our query.
Step 7: Assign aliases if desired
The fields, AlbumTitle and DatePurchased, have names made up of two words. Instead, aliases
can be made containing two words each (Album Title and Date Purchased, respectively).
1) Change AlbumTitle to Album Title.
2) Change DatePurchased to Date Purchased.
3) Click Next.
Step 8: Overview
1) Make sure that the query conditions listed in the Overview list are the ones you wanted.
(There are only two that you need to check.)
2) If something is wrong, use the Back button to move to the step that contains the error.
3) Then use the Next button to move to step 8.
4) Name the query (suggestion: Query_Artists).
248 | Getting Started with LibreOffice 5.0