Download Using Databases – OpenOffice.org Base

Transcript
Databases
42
1.2. Perform the file browser menu command Go−>5_databases;
1.3. Perform the file browser menu command Go−>5.6_query_design;
1.4. Select the file albums.odb;
1.5. Press Enter on the keyboard.
2. Create a query in design view:
2.1. In the Database pane, select the database object type Queries;
2.2. In the Tasks pane, click on Create Query in design view;
2.3. In the dialogue box Add Table or Query, add tables:
2.3.1.Select the table tbl_albums;
2.3.2.Click the Add button;
2.3.3.Repeat the actions for the table tbl_artists;
2.3.4.Click the Close button to close the dialogue box.
2.4. In the Field menu, select the table fields to be included in the query:
2.4.1.From the table tbl_albums – the fields Album, Format, Year;
2.4.2.From the table tbl_artists – the fields Artist, Country;
2.5. In the Country column, remove the tick from the Visible checkbox;
Useful tip:
The selected table can be changed in the menu of the Table field.
2.6. Create the data selection criteria. In the Criterion field, enter:
2.6.1.In the Year column, enter >=1979 – albums released in or after 1979;
2.6.2.In the Artists column, enter UK (uppercase) – bands from the United
Kingdom.