Translation

02000000.xhp par_id3154910 help.text
English JTXBF
Context English Chinese (Simplified) Actions
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
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.
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.
02000002.xhp
par_id3153031
help.text
The query is opened in the Design View (the graphical interface). Missing tables appear blank and invalid fields appear with their (invalid) names in the list of fields. This lets you work with exactly those fields that caused the error.
02000002.xhp
hd_id3149578
help.text
Open the query in the SQL View
02000002.xhp
par_id3159157
help.text
<ahelp hid=".">Allows you to open the query design in the <link href="text/sdatabase/02010100.xhp" name="SQL Mode">SQL Mode</link> and to interpret the query as a <link href="text/shared/02/14030000.xhp" name="Native SQL">Native SQL</link>.</ahelp> You can only quit the native SQL mode when the $[officename] statement is completely interpreted (only possible if the used tables or fields in the query really exist).
02000002.xhp
hd_id3150984
help.text
Do not open the query
02000002.xhp
par_id3156329
help.text
<ahelp hid=".">Allows you to cancel the procedure and specify that the query should not be opened.</ahelp> This option corresponds to the function of the <emph>Cancel</emph> dialog button.
User avatar hxlpdd

Suggestion added

Suggested change:

4 months ago

Loading…

User avatar hxlpdd

Suggestion added

LibreOffice Help - master / text/sdatabaseChinese (Simplified)

4 months ago
Browse all component changes

Things to check

Suggestions

There is 1 suggestion for this string.

View

Glossary

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

String information

Context
02000000.xhp
par_id3154910
help.text
Source string description
JTXBF
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 22