\<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 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 LibreOffice 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.