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

100

101

Figure 225: Sample record of the Vacation form and subform

Creating queries

Queries are used to get specific information from a database. Query

results are special tables within the database.

To demonstrate the use of queries, we will use two different methods:

• Using our CD-Collection table, we will create a list of albums by a

particular artist. We will do this using the Wizard.

• The information we might want from the Fuel table includes what

our fuel economy is. We will do this using the Design View.

(Queries that require calculations are best created with the

Design view.)

Using the Wizard to create a query

Queries created by the wizard provide a list or lists of information

based upon what one wants to know. It is possible to obtain a single

answer or multiple answers, depending upon the circumstances.

In the main database window (Figure 183), click the Queries icon in

the Databases section, then in the Tasks section, click Use Wizard to

Create Query. The Query Wizard window opens (Figure 226). The

information we want is what albums are by a certain musical group or

individual (the album’s author). We can include when each album was

bought.

Chapter 8 Getting Started with Base 293

Free eBook Edition

1 2 ... 288 289 290 291 292 293 294 295 296 297 298 ... 441 442

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

Comentarios a estos manuales

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

Comentarios a estos manuales

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