Translation

02000000.xhp par_id3153561 help.text
English AAQ4y
Context English Chinese (Simplified) Actions
02000000.xhp
tit
help.text
Queries 查询
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>
02000000.xhp
hd_id3150445
help.text
<link href="text/sdatabase/02000000.xhp" name="Queries">Queries</link> <link href="text/sdatabase/02000000.xhp" name="查询">查询</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". 可以使用查询来根据特定筛选标准从数据库中寻找记录。为一个数据库创建的所有查询都列在「<emph>查询</emph>」条目下。由于此条目中包含数据库查询,它也被叫做「查询容器」。
02000000.xhp
hd_id3153750
help.text
Printing Queries 打印查询
02000000.xhp
par_id3149183
help.text
To print a query or table: 要打印一个查询或一个表:
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). 打开一个文本文档(如果您更喜欢电子表格特有的打印功能,也可以打开一个电子表格文档)。
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. 打开数据库文件。然后如果您想打印表,就点击「表」图标;如果您想打印查询,就点击「查询」图标。
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. 将需要的表或查询的名称拖拽到文本文档或电子表格中。这会打开「<link href="text/shared/02/12070000.xhp" name="插入数据库列">插入数据库列</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. 决定您要插入哪些列(即数据字段)。您也可以点击「<emph>自动格式</emph>」按钮并选择对应的格式类型。关闭对话框。
02000000.xhp
par_id3153561
help.text
The query or table will be inserted into your document. 这样就会把该查询或表插入到您的文档中。
02000000.xhp
par_id3150503
help.text
Print the document by choosing <emph>File - Print</emph>. 选择「<emph>文件 - 打印</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. 您也可以打开「数据源」视图(快捷键 Ctrl+Shift+F4),在数据源视图中选择整个数据库表(点击表的左上角),然后将选中内容拖拽到文本文档或电子表格中。
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="对数据进行排序和筛选">对数据进行排序和筛选</link>
02000000.xhp
par_id3149655
help.text
Allows you to sort and filter the data in a query table. 可以让您对查询表中的数据进行排序和筛选。
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. 您可以使用「<emph>设计查询</emph>」来创建和编辑查询或视图。
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.
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.
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.
02000002.xhp
tit
help.text
Missing Element
02000002.xhp
bm_id3150445
help.text
<bookmark_value>queries; missing elements (Base)</bookmark_value>
02000002.xhp
hd_id3150445
help.text
Missing Element

Loading…

User avatar PlateauWolf

Translation changed

LibreOffice Help - master / text/sdatabaseChinese (Simplified)

11 months ago
User avatar PlateauWolf

Suggestion accepted

LibreOffice Help - master / text/sdatabaseChinese (Simplified)

11 months ago
User avatar mikachu.23333

Suggestion added

LibreOffice Help - master / text/sdatabaseChinese (Simplified)

12 months ago
Browse all component changes

Glossary

English Chinese (Simplified)
No related strings found in the glossary.

String information

Context
02000000.xhp
par_id3153561
help.text
Source string description
AAQ4y
Source string location
02000000.xhp
String age
a year ago
Source string age
a year ago
Translation file
zh-CN/helpcontent2/source/text/sdatabase.po, string 12