Download BOSS GNU/Linux User Manual

Creating a New Table using the Table Wizard
1. Open the database file where you want to create the new table.
2. In the left pane of the database window, click the “Tables” icon.
3. Click “Use Wizard to Create Table”.
Creating a New Table using the Design View
1. Open the database file where you want to create the new table.
2. In the left pane of the database window, click the “Tables” icon.
3. Click “Create Table in Design View”.
Creating a New Table View
Some database types support table views. A table view is a query that is stored with the database. For most database operations, a view can be used as you would use a table.
1. Open the database file where you want to create the new table view.
2. In the left pane of the database window, click the “Tables” icon.
3. Click “Create View”.
Working with Queries If you often want to access only a subset of your data that can be well defined by a filter condition, you can define a query. This is basically a name for the new view at the filtered data. You open the query and see the current data in the table layout that you defined.
Creating a New Query using the Query Wizard
In OpenOffice.org you can create a new query using the Query Wizard:
1. Open the database file where you want to create the new query.
2. In the left pane of the database window, click the “Queries” icon.
3. Click “Use Wizard to Create Query”.
Creating a New Query using the Design View
1. Open the database file where you want to create the new query.
2. In the left pane of the database window, click the "Queries” icon.
3. Click “Create Query in Design View”.
119