\<bookmark_value\>database tables;creating\</bookmark_value\>\<bookmark_value\>databases;creating tables\</bookmark_value\>\<bookmark_value\>table views of databases\</bookmark_value\>

Working with Tables

Data is stored in tables. As an example, your system address book that you use for your email 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 email 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 \<emph\>Tables\</emph\> icon.

3. Click \<emph\>Use Wizard to Create Table\</emph\>.

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 \<emph\>Tables\</emph\> icon.

3. Click \<emph\>Create Table in Design View\</emph\>.

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 \<emph\>Tables\</emph\> icon.

3. Click \<emph\>Create Table View\</emph\>.

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