Translation

02000000.xhp par_id3150443 help.text
English m5TnG
Decide which columns = data fields you want to include. You can also click the <emph>AutoFormat</emph> button and select a corresponding formatting type. Close the dialog.
163/1710 · 171
Context English Estonian Actions
02000000.xhp
tit
help.text 		Queries Päringud
02000000.xhp
bm_id3150445
help.text 		<bookmark_value>queries;overview (Base)</bookmark_value><bookmark_value>tables in databases; printing queries (Base)</bookmark_value><bookmark_value>printing; queries (Base)</bookmark_value><bookmark_value>queries; printing (Base)</bookmark_value> <bookmark_value>päringud; ülevaade (Base)</bookmark_value><bookmark_value>tabelid andmebaasis; päringute printimine (Base)</bookmark_value><bookmark_value>printimine; päringud (Base)</bookmark_value><bookmark_value>päringud; printimine (Base)</bookmark_value>
02000000.xhp
hd_id3150445
help.text 		<link href="text/sdatabase/02000000.xhp" name="Queries">Queries</link> <link href="text/sdatabase/02000000.xhp" name="Queries">Päringud</link>
02000000.xhp
par_id3150499
help.text 		A "query" is a special view of a table. A query can display chosen records or chosen fields within records; it can also sort those records. A query can apply to one table or to multiple tables, if they are linked by common data fields.
02000000.xhp
par_id3147399
help.text 		Use queries to find records from data tables based on certain criteria. All queries created for a database are listed under the <emph>Queries</emph> entry. Since this entry contains the database queries, it is also called the "query container". Teatud kriteeriumidele vastavate kirjete otsimiseks kasuta päringuid. Kõik andmebaasi jaoks tehtud päringud on kirjas <emph>Päringud</emph> sisestise all. Kuna selles kirjes on kõik andmebaasi päringud, siis nimetatakse seda "päringu konteineriks".
02000000.xhp
hd_id3153750
help.text 		Printing Queries Päringute printimine
02000000.xhp
par_id3149183
help.text 		To print a query or table: Päringu või tabeli printimiseks:
02000000.xhp
par_id3156426
help.text 		Open a text document (or a spreadsheet document if you prefer the specific printing functions of this type of document). Ava tekstidokument (või arvutustabel, kui eelistad seda tüüpi dokumendi printimise eripärasid).
02000000.xhp
par_id3149827
help.text 		Open the database file and click the Table icon if you want to print a table, or click the Query icon if you want to print a query. Ava andmebaasifail ja klõpsa tabeli ikoonil, kui soovid printida tabelit, või päringu ikoonil, kui soovid printida päringut.
02000000.xhp
par_id3149398
help.text 		Drag the name of the table or query into the open text document or spreadsheet. The dialog <link href="text/shared/02/12070000.xhp" name="Insert Database Columns">Insert Database Columns</link> opens. Lohista tabeli või päringu nimi avatud tekstidokumenti või arvutustabelisse. Avaneb dialoog <link href="text/shared/02/12070000.xhp" name="Insert Database Columns">Andmebaasi veergude lisamine</link>
02000000.xhp
par_id3150443
help.text 		Decide which columns = data fields you want to include. You can also click the <emph>AutoFormat</emph> button and select a corresponding formatting type. Close the dialog. Otsusta, milliseid veerge = andeväljasid sa soovid lisada. Sa võid ka klõpsata nupul <emph>Automaatvormisdus</emph> ning valida vastav vormingutüüp. Sulge dialoog.
02000000.xhp
par_id3153561
help.text 		The query or table will be inserted into your document. Päring või tabel lisatakse sinu dokumenti.
02000000.xhp
par_id3150503
help.text 		Print the document by choosing <emph>File - Print</emph>. Prindi dokument valides <emph>Fail - Prindi</emph>.
02000000.xhp
par_id3153146
help.text 		You can also open the data source view (Ctrl+Shift+F4), select the entire database table in the data source view (click on the top left corner of the table), and then drag the selection to a text document or spreadsheet.
02000000.xhp
hd_id3148946
help.text 		<link href="text/shared/main0212.xhp" name="Sorting and Filtering Data">Sorting and Filtering Data</link> <link href="text/shared/main0212.xhp" name="Andmete sortimine ja filtreerimine">Andmete sortimine ja filtreerimine</link>
02000000.xhp
par_id3149655
help.text 		Allows you to sort and filter the data in a query table. Võimaldab päringu tabelis andmeid sortida ja filtreerida.
02000000.xhp
hd_id3153379
help.text 		<link href="text/sdatabase/02010100.xhp" name="Query Design">Query Design</link>
02000000.xhp
par_id3151211
help.text 		With the <emph>Query Design</emph>, you can create and edit a query or view.
02000000.xhp
hd_id3153968
help.text 		<link href="text/sdatabase/02010100.xhp" name="Query Through Several Tables">Query Through Several Tables</link>
02000000.xhp
par_id3151043
help.text 		The query result can contain data from several tables if these are linked to each other by suitable data fields. Päring võib sisaldada andmeid mitmest tabelist, kui nad on omavahel sobivate väljade kaudu seotud.
02000000.xhp
hd_id3159149
help.text 		<link href="text/sdatabase/02010100.xhp" name="Formulating Query Criteria">Formulating Query Criteria</link>
02000000.xhp
par_id3154910
help.text 		You can find out which operators and commands can be used to formulate the filter conditions for a query. Sul on võimalik välja uurida, milliseid käske ja operaatoreid saab päringu filtreerimiskriteerimide formuleerimiseks kasutada.
02000000.xhp
hd_id3156212
help.text 		<link href="text/sdatabase/02010100.xhp" name="Executing Functions">Executing Functions</link>
02000000.xhp
par_id3144762
help.text 		You can perform calculations with the data of a table and store the results as a query result. Sul on võimalik tabelite andmetega teha kalkulatsioone ning säilitada vastus päringu tulemuses.
02000002.xhp
tit
help.text 		Missing Element Puuduv element
02000002.xhp
bm_id3150445
help.text 		<bookmark_value>queries; missing elements (Base)</bookmark_value> <bookmark_value>päringud; puuduvad elemendid (Base)</bookmark_value>

Loading…

User avatar Mihkel

Translation uploaded

LibreOffice Help - master / text/sdatabase — Estonian

Decide which columns = data fields you want to include. You can also click the <emph>AutoFormat</emph> button and select a corresponding formatting type. Close the dialog.
Otsusta, milliseid veerge = andeväljasid sa soovid lisada. Sa võid ka klõpsata nupul <emph>Automaatvormisdus</emph> ning valida vastav vormingutüüp. Sulge dialoog.
a year ago
Browse all component changes

Glossary

English Estonian
formatting LibreOffice UI - master

String information

Context
02000000.xhp
par_id3150443
help.text
Source string description
m5TnG
Source string location
02000000.xhp
String age
a year ago
Source string age
a year ago
Translation file
et/helpcontent2/source/text/sdatabase.po, string 11