The translation is temporarily closed for contributions due to maintenance, please come back later.

Translation

02000000.xhp hd_id3153379 help.text
English ci2PA
Context English Chinese (Simplified) Actions
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> <link href="text/sdatabase/02010100.xhp" name="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> <link href="text/sdatabase/02010100.xhp" name="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> <link href="text/sdatabase/02010100.xhp" name="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> <link href="text/sdatabase/02010100.xhp" name="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> <bookmark_value>查询;缺少元素 (Base)</bookmark_value>
02000002.xhp
hd_id3150445
help.text
Missing Element 缺少元素
02000002.xhp
par_id3150247
help.text
If a query in which tables or fields no longer exist is opened, the<emph> Missing Element </emph>dialog appears. This dialog names the missing table or the field which cannot be interpreted and allows you to decide how to continue with the procedure. 如果打开了其中不再存在表或字段的查询,则会出现<emph>缺少元素</emph>对话框。此对话框给出了缺失的表或无法解析的字段的名称,并允许您决定如何继续此过程。
02000002.xhp
hd_id3145072
help.text
How to continue? 如何继续?
02000002.xhp
par_id3149177
help.text
There are three options available for answering this question: 有三个选项可用于回答此问题:
02000002.xhp
hd_id3147576
help.text
Do you really want to open the query in the graphic view? 是否确实要在图形视图中打开查询?
02000002.xhp
par_id3166461
help.text
<ahelp hid=".">Allows you to open the query in the <link href="text/sdatabase/02010100.xhp" name="Design View">Design View</link> in spite of missing elements.</ahelp> This option also allows you to specify if other errors need to be ignored. <ahelp hid=".">允许您在<link href="text/sdatabase/02010100.xhp" name="Design View">设计视图</link>中打开查询,尽管缺少元素。</ahelp>此选项还允许您指定是否需要忽略其他错误。
Component Translation Difference to current string
This translation Propagated Locked Translated LibreOffice Help - master/text/sdatabase
The following strings have different contexts, but the same source.
Empty LibreOffice Help - master/text/shared/guide
Locked Empty LibreOffice Help - master/text/sdatabase

Loading…

User avatar suokunlong

Suggestion accepted

LibreOffice Help - master / text/sdatabaseChinese (Simplified)

a month ago
User avatar hxlpdd

Suggestion added

LibreOffice Help - master / text/sdatabaseChinese (Simplified)

6 months ago
Browse all component changes

Glossary

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

String information

Context
02000000.xhp
hd_id3153379
help.text
Source string description
ci2PA
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 17