OpenOffice.org OpenOffice - 3.0 Rychlý návod stáhnout pdf (Strana 289)

100

101

from the Fuel table includes what our fuel economy is. We will do this

using the Design View.

Note

Queries blur the differences between a database and a data

source. A database is only one type of data source. However,

searching for usable information from a data source requires a

query. Since the query (one part of a database) does this, the

data source appears to become one part of that database: its

table or tables. Query results, themselves, are special tables

within the database.

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.

Queries which require calculations are best created with the Design

view.

In the main database window (Figure 176), 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 241). 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.

Figure 241: First page of the Query Wizard

Chapter 8 Getting Started with Base 289

1 2 ... 284 285 286 287 288 289 290 291 292 293 294 ... 432 433

Komentáře k této Příručce

Žádné komentáře

OpenOffice.org OpenOffice - 3.0 Rychlý návod Strana 289

Komentáře k této Příručce

Související produkty a manuály pro Grafický software OpenOffice.org OpenOffice - 3.0