Working with Tables

Data is stored in tables. As an example, your system address book that you use for your e-mail addresses is a table of the address book database. Each address is a data record, presented as a row in that table. The data records consist of data fields, for example the first and the last name fields and the e-mail field.

Creating a New Table With the Table Wizard

In Collabora Office you can create 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 With 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.

You see the Table Design window.

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 Table View.

You see the View Design window, which is almost the same as the Query Design window.