LibreOffice Help - master/text/sdatabase — Chinese (Simplified) @ TDF Weblate - LibreOffice: <link href="text/sdatabase/02010100.xhp" name="Query Design">Query Design</link>

Translation

Context 02000000.xhp hd_id3153379 help.text

English ci2PA

Chinese (Simplified)

Needs editing

Skip

Context	English	Chinese (Simplified)
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
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.

	Component	Translation	Difference to current string
	This translation Propagated Empty LibreOffice Help - master/text/sdatabase
The following strings have different contexts, but the same source.
	Empty LibreOffice Help - master/text/sdatabase
	Empty LibreOffice Help - master/text/shared/guide

Loading…

hxlpdd

Suggestion added

LibreOffice Help - master / text/sdatabase — Chinese (Simplified)

English

Chinese (Simplified)

2 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
hd_id3153379
help.text

Source string description

ci2PA

Source string location

02000000.xhp

String age

11 months ago

Source string age

11 months ago

Translation file

zh-CN/helpcontent2/source/text/sdatabase.po, string 17