OpenOffice.org OpenOffice - 3.2 Guía de inicio rápido descargar pdf (Pagina 295)

100

101

Step 2: Select the sorting order.

Up to four fields can be used to sort the information of our query. A

little simple logic helps at this point. Which field is most important?

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 227: Sorting order page

1) Click the first Sort by dropdown list.

• Click CD-Collection.Artist to select it.

• To list the artists in alphabetical order (a-z), select Ascending

on the right.

2) Click the second Sort by dropdown 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 the

alphabetical order), and dates.

Chapter 8 Getting Started with Base 295

Free eBook Edition

1 2 ... 290 291 292 293 294 295 296 297 298 299 300 ... 441 442

OpenOffice.org OpenOffice - 3.2 Guía de inicio rápido Pagina 295

Comentarios a estos manuales

OpenOffice.org OpenOffice - 3.2 Guía de inicio rápido Pagina 295

Comentarios a estos manuales

Relacionado con productos y manuales para Software De Gráficos OpenOffice.org OpenOffice - 3.2