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.