Darbs ar tabulām
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.
Jaunas tabulas izveidošana ar tabulas vedni
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 Tables icon.
-
Click Use Wizard to Create Table.
Jaunas tabulas izveidošana ar izstrādes skatu
-
Atveriet datubāzes datni, kurā jūs vēlaties izveidot jaunu tabulu.
-
In the left pane of the database window, click the Tables icon.
-
Click Create Table in Design View.
You see the Table Design window.
Jauna tabulas skata izveidošana
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.
-
Atveriet datubāzes datni, kurā jūs vēlaties izveidot jaunu tabulas skatu.
-
In the left pane of the database window, click the Tables icon.
-
Click Create Table View.
You see the View Design window, which is almost the same as the Query Design window.