Getting Started with Open Office .org 3 part 30. This Manual Book is for anyone who wants to get up to speed quickly with the latest version . “GETTING STARTED WITH ″ introduces all software programs of the OpenOffice bundle: Writer (word processing), Calc (spreadsheets), Impress (presentations), Draw (vector drawings), Math (equation editor) and Base (database). This book was written by volunteers from the community working through and is distributed under the CreativeCommon Attribution Licence | 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 243 Sorting order page 1 Click the first Sort by dropdown list. Click to select it. If you want the artists to be listed in alphabetical order a-z select Ascending on the right. If you want the artist listed in reverse order z-a select Descending on the right Figure 243 . 2 Click the second Sort by dropdown list. Click . Select Ascending or Descending according to the order you want. 3 Repeat this process for . 4 Click Next. Step 3 Select the search conditions. The search conditions available are listed below. They 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 Chapter 8 Getting Started with Base 291 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. Since we have a simple query the Grouping and Grouping Note 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 .
