Operation Manual

In our query, the artist is most important. The album title is less important, and the date purchased
is of least importance. Of course, if we were interested in what music we bought on a given day,
the date purchased would be the most important.
Figure 236: Sorting order page
1) Click the first Sort by drop down list.
a) Click CD-Collection.Artist to select it.
b) To list the artists in alphabetical order (a-z), select Ascending on the right.
2) Click the second Sort by drop down list.
• Click CD-Collection.ArtistTitle. and select Ascending.
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 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.
Chapter 8 Getting Started with Base | 247