Download Using Databases – OpenOffice.org Base

Databases
12.1.
12.1.1.
12.1.2.
12.2.
12.3.
66
Open the table tbl_albums in data mode:
In the Tables pane, select the table tbl_albums;
Press the Enter key on the keyboard
Perform a right click on the name of the Artist column;
In the right-click menu, select the command Column Width:
12.4.
In the Width field of the Column Width dialogue box, enter 1.2 (3);
12.5.
Click OK;
12.6.
Close the table by clicking the Close button in the title bar of the column
window.
Tip:
OpenOffice.org Base does not provide the possibility to move data table fields. It can be
done directly with the database commands. If a different arrangement of database table
fields is needed, it is possible to create a view for a table or tables. A view does not
change the actual order of table fields.
13. Create a view for the table tbl_artists where the Active field is immediately after the
Artist field (1 point):
13.1.
In the Database pane, select the database object Tables, if necessary;
13.2.
In the Tasks pane, click on the task Create View;
13.3.
In the Add Tables dialogue box, select the table tbl_artists;
13.4.
Click Add;
13.5.
Click Close;
13.6.
In the Field row of the table, set the fields to be displayed in the order
specified in the task:
13.7.
Click the Save button in the toolbar;
13.8.
In the Table name field of the Save As dialogue box, enter the view
name custom_view;
13.9.
Click OK;
13.10.
Click the Close button in the title bar of the window.
14. Create a query called qry_after_81 that will select from the table tbl_albums all
albums released after 1981 (1 point):
14.1.
In the Database pane, select the object type Queries;
14.2.
In the Tasks pane, click on the task Create Query in Design View;
14.3.
In the dialogue box Add Table or Query, select the table tbl_albums;
14.4.
Click Add;
14.5.
Click Close;