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:
-
Open the database file where you want to create the new table.
-
In the left pane of the database window, click the \<emph\>Tables\</emph\> icon.
-
Click \<emph\>Use Wizard to Create Table\</emph\>.
Creating a New Table With the Design View
-
Open the database file where you want to create the new table.
-
In the left pane of the database window, click the \<emph\>Tables\</emph\> icon.
-
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.
-
Open the database file where you want to create the new table view.
-
In the left pane of the database window, click the \<emph\>Tables\</emph\> icon.
-
Click \<emph\>Create Table View\</emph\>.
You see the View Design window, which is almost the same as the Query Design window.