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:

  1. Open the database file where 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.

Jaunas tabulas izveidošana ar izstrādes skatu

  1. Atveriet datubāzes datni, kurā jūs vēlaties izveidot jaunu tabulu.

  2. In the left pane of the database window, click the Tables icon.

  3. 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.

  1. Atveriet datubāzes datni, kurā jūs vēlaties izveidot jaunu tabulas skatu.

  2. In the left pane of the database window, click the Tables icon.

  3. Click Create Table View.

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

Please support us!