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 forename and surname 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 in which 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 in which 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 will 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 in which 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 will see the View Design window, which is almost the same as the Query Design window.

Please support us!