DB help content clean-up

Change-Id: Id5a3f2bd17d4e6a159fe6322eb9cec8012cc9d51
Reviewed-on: https://gerrit.libreoffice.org/60487
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>

11 files changed, 160 insertions, 160 deletions

diff --git a/source/text/shared/explorer/database/02000000.xhp b/source/text/shared/explorer/database/02000000.xhp
index 2817517785..d73d23d62c 100644
--- a/source/text/shared/explorer/database/02000000.xhp
+++ b/source/text/shared/explorer/database/02000000.xhp
@@ -35,7 +35,7 @@
 <bookmark_value>printing; queries (Base)</bookmark_value>
 <bookmark_value>queries; printing (Base)</bookmark_value>
 </bookmark><comment>mw added "(Base)" to all entries </comment><paragraph role="heading" id="hd_id3150445" xml-lang="en-US" level="1"><link href="text/shared/explorer/database/02000000.xhp" name="Queries">Queries</link></paragraph>
-<paragraph role="paragraph" id="par_id3150499" xml-lang="en-US">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 to multiple tables, if they are linked by common data fields.<comment>i73680</comment></paragraph>
+<paragraph role="paragraph" id="par_id3150499" xml-lang="en-US">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.<comment>i73680</comment></paragraph>
 </section>
 <section id="howtoget">
   <embed href="text/shared/00/00000450.xhp#Abfragen"/>
diff --git a/source/text/shared/explorer/database/02010100.xhp b/source/text/shared/explorer/database/02010100.xhp
index d388ddc8a9..6825e44edc 100644
--- a/source/text/shared/explorer/database/02010100.xhp
+++ b/source/text/shared/explorer/database/02010100.xhp
@@ -61,7 +61,7 @@
 
 <paragraph id="hd_id3149233" role="heading" level="2" xml-lang="en-US">The Design View</paragraph>
 <paragraph id="par_id3145673" role="paragraph" xml-lang="en-US">To create a query, click the <emph>Queries</emph> icon in a database document, then click <emph>Create Query in Design View</emph>.</paragraph>
-<paragraph id="par_id3150255" role="paragraph" xml-lang="en-US">The lower pane of the Design View is where you <link href="text/shared/explorer/database/02010100.xhp" name="define">define</link> the query. To define a query, specify the database <link href="text/shared/explorer/database/02010100.xhp" name="field names">field names</link> to include and the <link href="text/shared/explorer/database/02010100.xhp" name="criteria">criteria</link> for displaying the fields. To rearrange the columns in the lower pane of the Design View, drag a column header to a new location, or select the column and press <switchinline select="sys"><caseinline select="MAC">Command 
+<paragraph id="par_id3150255" role="paragraph" xml-lang="en-US">The lower pane of the Design View is where you <link href="text/shared/explorer/database/02010100.xhp" name="define">define</link> the query. To define a query, specify the database <link href="text/shared/explorer/database/02010100.xhp" name="field names">field names</link> to include and the <link href="text/shared/explorer/database/02010100.xhp" name="criteria">criteria</link> for displaying the fields. To rearrange the columns in the lower pane of the Design View, drag a column header to a new location, or select the column and press <switchinline select="sys"><caseinline select="MAC">Command
 </caseinline><defaultinline>Ctrl</defaultinline></switchinline>+arrow key.</paragraph>
 <paragraph id="par_id3152474" role="paragraph" xml-lang="en-US">In the top of the query Design View window, the <link href="text/shared/main0214.xhp" name="icons">icons</link> of the <emph>Query Design</emph> Bar and the <emph>Design</emph> bar are displayed.</paragraph>
 <paragraph id="par_id3147559" role="paragraph" xml-lang="en-US">If you want to test a query, double-click the query name in the database document. The query result is displayed in a table similar to the Data Source View. Note: the table displayed is only temporary.</paragraph>
@@ -121,13 +121,13 @@
 
 <paragraph id="hd_id3145365" role="heading" level="2" xml-lang="en-US">Table Relations</paragraph>
 <paragraph id="par_id3154145" role="paragraph" xml-lang="en-US">If there are data relations between a field name in one table and a field name in another table, you can use these relations for your query.</paragraph>
-<paragraph id="par_id3152577" role="paragraph" xml-lang="en-US">If, for example, you have a spreadsheet for articles identified by an article number, and a spreadsheet for customers in which you record all articles that a customer orders using the corresponding article numbers, then there is a relationship between the two "article number" data fields. If you now want to create a query that returns all articles that a customer has ordered, you must retrieve data from two spreadsheets. To do this, you must tell $[officename] what the relationship exists between the data in the two spreadsheets.</paragraph>
-<paragraph id="par_id3155302" role="paragraph" xml-lang="en-US">To do this, click a field name in a table (for example, the field name "Item-Number" from the Customer table), hold down the mouse button and then drag the field name to the field name of the other table ("Item-Number" from the Item table). When you release the mouse button, a line connecting the two fields in the two windows appears. The corresponding condition that the content of the two field names must be identical is entered in the resulting SQL query.</paragraph>
+<paragraph id="par_id3152577" role="paragraph" xml-lang="en-US">If, for example, you have a spreadsheet for articles identified by an article number, and a spreadsheet for customers in which you record all articles that a customer orders using the corresponding article numbers, then there is a relationship between the two "article number" data fields. If you now want to create a query that returns all articles that a customer has ordered, you must retrieve data from two spreadsheets. To do this, you must inform $[officename] about the relationship which exists between the data in the two spreadsheets.</paragraph>
+<paragraph id="par_id3155302" role="paragraph" xml-lang="en-US">To do this, click a field name in a table (for example, the field name "Item-Number" from the Customer table), hold down the mouse button and then drag the field name to the field name of the other table ("Item-Number" from the Item table). When you release the mouse button, a line connecting the two fields between the two table windows appears. The corresponding condition that the content of the two field names must be identical is entered in the resulting SQL query.</paragraph>
 <paragraph id="par_id3153876" role="paragraph" xml-lang="en-US">The creation of a query that is based on several related sheets is only possible if you use $[officename] as the interface for a relational database.</paragraph>
 <paragraph id="par_id3145646" role="note" xml-lang="en-US">You cannot access tables from different databases in a query. Queries involving multiple tables can only be created within one database.</paragraph>
 
-<paragraph id="hd_id3153279" role="heading" level="3" xml-lang="en-US">Specifying link type</paragraph>
-<paragraph id="par_id3154791" role="paragraph" xml-lang="en-US">If you double-click the line connecting two linked fields or call the menu command <emph>Insert - New Relation</emph>, you can specify the type of link in the <link href="text/shared/explorer/database/02010101.xhp" name="Relations"><emph>Relations</emph></link> dialog.</paragraph>
+<paragraph id="hd_id3153279" role="heading" level="3" xml-lang="en-US">Specifying the relation type</paragraph>
+<paragraph id="par_id3154791" role="paragraph" xml-lang="en-US">If you double-click on the line connecting two linked fields or call the menu command <emph>Insert - New Relation</emph>, you can specify the type of relation in the <link href="text/shared/explorer/database/02010101.xhp" name="Relations"><emph>Relations</emph></link> dialog.</paragraph>
 <bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_QUERY_EDIT_JOINCONNECTION" id="bm_id3145253" localize="false"/>
 <paragraph id="par_id3150094" role="paragraph" xml-lang="en-US"><ahelp hid="HID_QUERY_EDIT_JOINCONNECTION" visibility="hidden">Edit Join Properties.</ahelp> Alternatively, press Tab until the line is selected, then press Shift+F10 to display the context menu and there choose the command <emph>Edit</emph>. Some databases support only a subset of the possible join types.</paragraph>
 
@@ -136,17 +136,17 @@
 <paragraph id="par_id3150715" role="paragraph" xml-lang="en-US">Alternatively, delete the respective entries in <emph>Fields involved </emph>in the <emph>Relations</emph> dialog. Or press Tab until the connecting vector is displayed highlighted, then press Shift+F10 to open the context menu and select <emph>Delete </emph>command.</paragraph>
 <bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_CTL_QRYDGNCRIT" id="bm_id3152972" localize="false"/>
 
-<paragraph id="hd_id3151208" role="heading" level="2" xml-lang="en-US">Define query</paragraph>
+<paragraph id="hd_id3151208" role="heading" level="2" xml-lang="en-US">Defining the query</paragraph>
 <paragraph id="par_id3158416" role="paragraph" xml-lang="en-US"><ahelp hid="HID_CTL_QRYDGNCRIT">Select conditions to define the query.</ahelp> Each column of the design table accepts a data field for the query. The conditions in one row are linked with a Boolean AND.</paragraph>
 
-<paragraph id="hd_id3154161" role="heading" level="3" xml-lang="en-US">Specify field name</paragraph>
-<paragraph id="par_id3146791" role="paragraph" xml-lang="en-US">First, select all field names from the tables that you want to add to the query. You can do this either with drag-and-drop or by double-clicking a field name in the table window. With the drag-and-drop method, use the mouse to drag a field name from the table window into the lower area of the query design. As you do this, you can decide which column you want to add the field to. Select a field name by double-clicking. It will then be added to the next free column.</paragraph>
+<paragraph id="hd_id3154161" role="heading" level="3" xml-lang="en-US">Specifying field names</paragraph>
+<paragraph id="par_id3146791" role="paragraph" xml-lang="en-US">First, select all field names from the tables that you want to add to the query. You can do this either by drag-and-drop or by double-clicking a field name in the table window. With the drag-and-drop method, use the mouse to drag a field name from the table window into the lower area of the query design window. As you do this, you can decide which column in the query design window will receive the selected field. A field name can also be selected by double-clicking. It will then be added to the next free column in the query design window.</paragraph>
 
 <paragraph id="hd_id3150750" role="heading" level="3" xml-lang="en-US">Deleting field names</paragraph>
 <paragraph id="par_id3154479" role="paragraph" xml-lang="en-US">To remove a field name from the query, click the column header of the field and choose the <emph>Delete</emph> command on the context menu for the column.</paragraph>
 
-<paragraph id="hd_id3155764" role="heading" level="3" xml-lang="en-US">Save query</paragraph>
-<paragraph id="par_id3148481" role="paragraph" xml-lang="en-US">Use the <emph>Save</emph> icon on the Standard Bar to save the query. You see a dialog that asks you to enter a name for the query. If the database supports schemas, you can also enter a schema.</paragraph>
+<paragraph id="hd_id3155764" role="heading" level="3" xml-lang="en-US">Saving the query</paragraph>
+<paragraph id="par_id3148481" role="paragraph" xml-lang="en-US">Use the <emph>Save</emph> icon on the Standard toolbar to save the query. You will see a dialog that asks you to enter a name for the query. If the database supports schemas, you can also enter a schema name.</paragraph>
 <bookmark xml-lang="en-US" branch="hid/dbaccess/ui/savedialog/schema" id="bm_id3156378" localize="false"/>
 
 <paragraph id="hd_id3154362" role="heading" level="4" xml-lang="en-US">Schema</paragraph>
@@ -157,44 +157,44 @@
 <paragraph id="par_id3154253" role="paragraph" xml-lang="en-US"><ahelp hid="dbaccess/ui/savedialog/title">Enter the name of the query or table view.</ahelp></paragraph>
 
 <paragraph id="hd_id3163805" role="heading" level="3" xml-lang="en-US">Filtering data</paragraph>
-<paragraph id="par_id3154964" role="paragraph" xml-lang="en-US">To filter data for the query, set the desired preferences in the lower area of the Design View. The following lines are available:</paragraph>
+<paragraph id="par_id3154964" role="paragraph" xml-lang="en-US">To filter data for the query, set the desired criteria in the lower area of the query design window. The following options are available:</paragraph>
 <bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_QRYDGN_ROW_FIELD" id="bm_id3148536" localize="false"/>
 
 <paragraph id="hd_id3146916" role="heading" level="4" xml-lang="en-US">Field</paragraph>
-<paragraph id="par_id3156372" role="paragraph" xml-lang="en-US"><ahelp hid="HID_QRYDGN_ROW_FIELD">Enter the name of the data field that you referred to in the Query. All settings made in the lower rows refer to this field.</ahelp> If you activate a cell with a mouse click you'll see an arrow button, which enables you to select a field. The "Table name.*" option selects all data fields and the criteria is valid for all table fields.</paragraph>
+<paragraph id="par_id3156372" role="paragraph" xml-lang="en-US"><ahelp hid="HID_QRYDGN_ROW_FIELD">Enter the name of the data field that is referred to in the Query. All settings made in the filter option rows refer to this field.</ahelp> If you activate a cell here with a mouse click you'll see an arrow button, which enables you to select a field. The "Table name.*" option selects all data fields with the effect that the specified criteria will be applied to all table fields.</paragraph>
 <bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_QRYDGN_ROW_ALIAS" id="bm_id3154702" localize="false"/>
 
 <paragraph id="hd_id3145150" role="heading" level="4" xml-lang="en-US">Alias</paragraph>
-<paragraph id="par_id3146315" role="paragraph" xml-lang="en-US"><ahelp hid="HID_QRYDGN_ROW_ALIAS">Specifies an alias. This alias will be listed in a query instead of the field name. This makes it possible to use user-defined column labels.</ahelp> For example, if the data field has the name PtNo and, instead of that name, you would like to have PartNum appear in the query, enter PartNum as alias.</paragraph>
-<paragraph id="par_id3155959" role="paragraph" xml-lang="en-US">In an SQL statement, aliases are defined as following:</paragraph>
+<paragraph id="par_id3146315" role="paragraph" xml-lang="en-US"><ahelp hid="HID_QRYDGN_ROW_ALIAS">Specifies an alias. This alias will be listed in the query instead of the field name. This makes it possible to use user-defined column labels.</ahelp> For example, if the data field is named PtNo and, instead of that name, you would like to have PartNum appear in the query, enter PartNum as the alias.</paragraph>
+<paragraph id="par_id3155959" role="paragraph" xml-lang="en-US">In a SQL statement, aliases are defined as follows:</paragraph>
 <paragraph id="par_id3149922" role="paragraph" xml-lang="en-US">SELECT column AS alias FROM table.</paragraph>
 <paragraph id="par_id3159335" role="paragraph" xml-lang="en-US">For example:</paragraph>
 <paragraph id="par_id3148478" role="paragraph" xml-lang="en-US">SELECT "PtNo" AS "PartNum" FROM "Parts"</paragraph>
 <bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_QRYDGN_ROW_TABLE" id="bm_id3154665" localize="false"/>
 
 <paragraph id="hd_id3148485" role="heading" level="4" xml-lang="en-US">Table</paragraph>
-<paragraph id="par_id3163665" role="paragraph" xml-lang="en-US"><ahelp hid="HID_QRYDGN_ROW_TABLE">The corresponding database table of the selected data field is listed here.</ahelp> If you activate the a cell with a mouse click, an arrow will appear which enables you to select another table of the current query.</paragraph>
+<paragraph id="par_id3163665" role="paragraph" xml-lang="en-US"><ahelp hid="HID_QRYDGN_ROW_TABLE">The corresponding database table of the selected data field is listed here.</ahelp> If you activate this cell with a mouse click, an arrow will appear which enables you to select a different table for the current query.</paragraph>
 <bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_QRYDGN_ROW_ORDER" id="bm_id3154202" localize="false"/>
 
 <paragraph id="hd_id3154207" role="heading" level="4" xml-lang="en-US">Sort</paragraph>
-<paragraph id="par_id3150979" role="paragraph" xml-lang="en-US"><ahelp hid="HID_QRYDGN_ROW_ORDER">If you click the cell, you can select among the sorting options: ascending, descending and not sorted.</ahelp> Text fields will be sorted alphabetically and numerical fields numerically. For most databases, administrators can set the sorting options.</paragraph>
+<paragraph id="par_id3150979" role="paragraph" xml-lang="en-US"><ahelp hid="HID_QRYDGN_ROW_ORDER">If you click on this cell, you can choose a sort option: ascending, descending and unsorted.</ahelp> Text fields will be sorted alphabetically and numerical fields numerically. For most databases, administrators can set the sorting options at the database level.</paragraph>
 <bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_QRYDGN_ROW_VISIBLE" id="bm_id3149334" localize="false"/>
 
 <paragraph id="hd_id3150384" role="heading" level="4" xml-lang="en-US">Visible</paragraph>
-<paragraph id="par_id3146133" role="paragraph" xml-lang="en-US"><ahelp hid="HID_QRYDGN_ROW_VISIBLE">If you mark the <emph>Visible</emph> property for a data field, that field will be visible in the query</ahelp>. If you only use a data field to formulate a condition, you do not necessarily need to show it.</paragraph>
+<paragraph id="par_id3146133" role="paragraph" xml-lang="en-US"><ahelp hid="HID_QRYDGN_ROW_VISIBLE">If you mark the <emph>Visible</emph> property for a data field, that field will be visibly displayed in the resulting query</ahelp>. If you are only using a data field to formulate a condition or make a calculation, you do not necessarily need to display it.</paragraph>
 <bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_QRYDGN_ROW_CRIT" id="bm_id3147130" localize="false"/>
 
 <paragraph id="hd_id3154714" role="heading" level="4" xml-lang="en-US">Criteria</paragraph>
-<paragraph id="par_id3145134" role="paragraph" xml-lang="en-US"><ahelp hid="HID_QRYDGN_ROW_CRIT">Specifies the <link href="text/shared/explorer/database/02010100.xhp" name="criteria ">criteria </link>by which the content of the data field should be filtered.</ahelp></paragraph>
+<paragraph id="par_id3145134" role="paragraph" xml-lang="en-US"><ahelp hid="HID_QRYDGN_ROW_CRIT">Specifies a first <link href="text/shared/explorer/database/02010100.xhp" name="criteria ">criteria </link>by which the content of the data field is to be filtered.</ahelp></paragraph>
 
 <paragraph id="hd_id3152477" role="heading" level="4" xml-lang="en-US">or</paragraph>
-<paragraph id="par_id3154585" role="paragraph" xml-lang="en-US">Here you can enter one additional criterion for filtering in each line. Multiple criteria in one column will be connected by an OR link.</paragraph>
-<paragraph id="par_id3148800" role="paragraph" xml-lang="en-US">You can also use the context menu of the line headers in the lower area of the query design to insert another line for functions:</paragraph>
+<paragraph id="par_id3154585" role="paragraph" xml-lang="en-US">Here you can enter one additional filter criterion for each line. Multiple criteria in a single column will be interpreted as boolean OR.</paragraph>
+<paragraph id="par_id3148800" role="paragraph" xml-lang="en-US">You can also use the context menu of the line headers in the lower area of the query design window to insert a filter based on a function:</paragraph>
 <bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_QRYDGN_ROW_FUNCTION" id="bm_id3153275" localize="false"/>
 
 <paragraph id="hd_id3148419" role="heading" level="3" xml-lang="en-US">Functions</paragraph>
-<paragraph id="par_id3153233" role="paragraph" xml-lang="en-US"><ahelp hid="HID_QRYDGN_ROW_FUNCTION" visibility="hidden">Select a function to run in the query here.</ahelp> The functions you can run here depend on the database. </paragraph>
-<paragraph id="par_id8760818" role="paragraph" xml-lang="en-US">If you are working with the HSQL database, the list box in the <emph>Function</emph> row offers you the following options:</paragraph>
+<paragraph id="par_id3153233" role="paragraph" xml-lang="en-US"><ahelp hid="HID_QRYDGN_ROW_FUNCTION" visibility="hidden">Select a function to run in the query.</ahelp> The functions which are available here depend on those provided by the database engine. </paragraph>
+<paragraph id="par_id8760818" role="paragraph" xml-lang="en-US">If you are working with the embedded HSQL database, the list box in the <emph>Function</emph> row offers you the following options:</paragraph>
 
 <table id="tbl_id3148461">
   <tablerow>
@@ -202,7 +202,7 @@
       <paragraph id="par_id3150307" role="tablehead" xml-lang="en-US">Option</paragraph>
     </tablecell>
     <tablecell>
-      <paragraph id="par_id3166430" role="tablehead" xml-lang="en-US">SQL</paragraph>
+      <paragraph id="par_id3166430" role="tablehead" xml-lang="en-US" localize="false">SQL</paragraph>
     </tablecell>
     <tablecell>
       <paragraph id="par_id3152993" role="tablehead" xml-lang="en-US">Effect</paragraph>
@@ -223,7 +223,7 @@
       <paragraph id="par_id3166420" role="tablecontent" xml-lang="en-US">Average</paragraph>
     </tablecell>
     <tablecell>
-      <paragraph id="par_id3145268" role="tablecontent" xml-lang="en-US">AVG</paragraph>
+      <paragraph id="par_id3145268" role="tablecontent" xml-lang="en-US" localize="false">AVG</paragraph>
     </tablecell>
     <tablecell>
       <paragraph id="par_id3154486" role="tablecontent" xml-lang="en-US">Calculates the arithmetic mean of a field.</paragraph>
@@ -234,12 +234,12 @@
       <paragraph id="par_id3149979" role="tablecontent" xml-lang="en-US">Count</paragraph>
     </tablecell>
     <tablecell>
-      <paragraph id="par_id3154260" role="tablecontent" xml-lang="en-US">COUNT</paragraph>
+      <paragraph id="par_id3154260" role="tablecontent" xml-lang="en-US" localize="false">COUNT</paragraph>
     </tablecell>
     <tablecell>
-      <paragraph id="par_id3155810" role="tablecontent" xml-lang="en-US">Determines the number of records in the table. Empty fields can either be counted (a) or not (b).</paragraph>
+      <paragraph id="par_id3155810" role="tablecontent" xml-lang="en-US">Determines the number of records in the table. Empty fields can either be counted (a) or excluded (b).</paragraph>
       <paragraph id="par_id3151333" role="tablecontent" xml-lang="en-US">a) COUNT(*): Passing an asterisk as the argument counts all records in the table.</paragraph>
-      <paragraph id="par_id3152889" role="tablecontent" xml-lang="en-US">b) COUNT(column): Passing a field name as an argument counts only fields in which the field name in question contains a value. Null values (empty fields) will not be counted.</paragraph>
+      <paragraph id="par_id3152889" role="tablecontent" xml-lang="en-US">b) COUNT(column): Passing a field name as an argument counts only those records for fields in which the field name in question contains a value. Records with fields having Null values (i.e. fields containing no characters) will not be counted.</paragraph>
     </tablecell>
   </tablerow>
   <tablerow>
@@ -247,10 +247,10 @@
       <paragraph id="par_id3153067" role="tablecontent" xml-lang="en-US">Maximum</paragraph>
     </tablecell>
     <tablecell>
-      <paragraph id="par_id3148840" role="tablecontent" xml-lang="en-US">MAX</paragraph>
+      <paragraph id="par_id3148840" role="tablecontent" xml-lang="en-US" localize="false">MAX</paragraph>
     </tablecell>
     <tablecell>
-      <paragraph id="par_id3159221" role="tablecontent" xml-lang="en-US">Determines the highest value of a field.</paragraph>
+      <paragraph id="par_id3159221" role="tablecontent" xml-lang="en-US">Determines the highest value of a record for that field.</paragraph>
     </tablecell>
   </tablerow>
   <tablerow>
@@ -258,10 +258,10 @@
       <paragraph id="par_id3146866" role="tablecontent" xml-lang="en-US">Minimum</paragraph>
     </tablecell>
     <tablecell>
-      <paragraph id="par_id3148604" role="tablecontent" xml-lang="en-US">MIN</paragraph>
+      <paragraph id="par_id3148604" role="tablecontent" xml-lang="en-US" localize="false">MIN</paragraph>
     </tablecell>
     <tablecell>
-      <paragraph id="par_id3157982" role="tablecontent" xml-lang="en-US">Determines the lowest value of a field.</paragraph>
+      <paragraph id="par_id3157982" role="tablecontent" xml-lang="en-US">Determines the lowest value of a record for that field.</paragraph>
     </tablecell>
   </tablerow>
   <tablerow>
@@ -269,10 +269,10 @@
       <paragraph id="par_id3154828" role="tablecontent" xml-lang="en-US">Sum</paragraph>
     </tablecell>
     <tablecell>
-      <paragraph id="par_id3147070" role="tablecontent" xml-lang="en-US">SUM</paragraph>
+      <paragraph id="par_id3147070" role="tablecontent" xml-lang="en-US" localize="false">SUM</paragraph>
     </tablecell>
     <tablecell>
-      <paragraph id="par_id3154536" role="tablecontent" xml-lang="en-US">Calculates the sum of values of associated fields.</paragraph>
+      <paragraph id="par_id3154536" role="tablecontent" xml-lang="en-US">Calculates the sum of the values of records for the associated fields.</paragraph>
     </tablecell>
   </tablerow>
   <tablerow>
@@ -280,10 +280,10 @@
       <paragraph id="par_id3148820" role="tablecontent" xml-lang="en-US">Group</paragraph>
     </tablecell>
     <tablecell>
-      <paragraph id="par_id3145375" role="tablecontent" xml-lang="en-US">GROUP BY</paragraph>
+      <paragraph id="par_id3145375" role="tablecontent" xml-lang="en-US" localize="false">GROUP BY</paragraph>
     </tablecell>
     <tablecell>
-      <paragraph id="par_id3149438" role="tablecontent" xml-lang="en-US">Groups query data according to the field name selected. Functions are executed according to the specified groups. In SQL, this option corresponds to the GROUP BY clause. If a criterion is added, this entry appears in the SQL HAVING.</paragraph>
+      <paragraph id="par_id3149438" role="tablecontent" xml-lang="en-US">Groups query data according to the selected field name. Functions are executed according to the specified groups. In SQL, this option corresponds to the GROUP BY clause. If a criterion is added, this entry appears in the SQL HAVING sub-clause.</paragraph>
     </tablecell>
   </tablerow>
 </table>
@@ -292,14 +292,14 @@
 <paragraph id="par_id3156340" role="paragraph" xml-lang="en-US">SELECT FUNCTION(column) FROM table.</paragraph>
 <paragraph id="par_id3155075" role="paragraph" xml-lang="en-US">For example, the function call in SQL for calculating a sum is:</paragraph>
 <paragraph id="par_id3154591" role="paragraph" xml-lang="en-US">SELECT SUM("Price") FROM "Article".</paragraph>
-<paragraph id="par_id3159205" role="paragraph" xml-lang="en-US">Except for the <emph>Group</emph> function, the above functions are so-called Aggregate functions. These are functions that calculate data to create summaries from the results. Additional functions that are not listed in the list box might be also possible. These depend on the specific database system in use and on the current state of the Base driver.</paragraph>
-<paragraph id="par_id3148651" role="paragraph" xml-lang="en-US">To use other functions not listed in the list box, you must enter them under <emph>Field</emph>.</paragraph>
-<paragraph id="par_id3155098" role="paragraph" xml-lang="en-US">You can also assign aliases to function calls. If the query is not to be displayed in the column header, enter the desired name under <emph>Alias</emph>.</paragraph>
+<paragraph id="par_id3159205" role="paragraph" xml-lang="en-US">Except for the <emph>Group</emph> function, the above functions are called Aggregate functions. These are functions that calculate data to create summaries from the results. Additional functions that are not listed in the list box might be also possible. These depend on the specific database engine in use and on the current functionality provided by the Base driver used to connect to that database engine.</paragraph>
+<paragraph id="par_id3148651" role="paragraph" xml-lang="en-US">To use other functions not listed in the list box, you must enter them manually under <emph>Field</emph>.</paragraph>
+<paragraph id="par_id3155098" role="paragraph" xml-lang="en-US">You can also assign aliases to function calls. If you not wish the query string to be displayed in the column header, enter a desired substitute name under <emph>Alias</emph>.</paragraph>
 <paragraph id="par_id3155539" role="paragraph" xml-lang="en-US">The corresponding function in an SQL statement is:</paragraph>
 <paragraph id="par_id3149425" role="paragraph" xml-lang="en-US">SELECT FUNCTION() AS alias FROM table</paragraph>
 <paragraph id="par_id3144431" role="paragraph" xml-lang="en-US">Example:</paragraph>
 <paragraph id="par_id3154614" role="paragraph" xml-lang="en-US">SELECT COUNT(*) AS count FROM "Item"</paragraph>
-<paragraph id="par_id3154610" role="note" xml-lang="en-US">If you run this function, you cannot insert any additional columns for the query other than receiving these columns as a "Group" function.</paragraph>
+<paragraph id="par_id3154610" role="note" xml-lang="en-US">If you run such a function, you cannot insert any additional columns for the query other than as an argument in a "Group" function.</paragraph>
 <paragraph id="par_id3154644" role="paragraph" xml-lang="en-US"> <emph>Examples</emph> </paragraph>
 <paragraph id="par_id3151120" role="paragraph" xml-lang="en-US">In the following example, a query is run through two tables: an "Item" table with the "Item_No" field and a "Suppliers" table with the "Supplier_Name" field. In addition, both tables have a common field name "Supplier_No."</paragraph>
 <paragraph id="par_id3155144" role="paragraph" xml-lang="en-US">The following steps are required to create a query containing all suppliers who deliver more than three items.</paragraph>
@@ -312,7 +312,7 @@
     <paragraph id="par_id3148807" role="listitem" xml-lang="en-US">Link the "Supplier_No" fields of the two tables if there is not already a relation of this type.</paragraph>
   </listitem>
   <listitem>
-    <paragraph id="par_id3161652" role="listitem" xml-lang="en-US">Double-click the "Item_No" field from the "Item" table. Display the <emph>Function</emph> line using the context menu and select the Count function.</paragraph>
+    <paragraph id="par_id3161652" role="listitem" xml-lang="en-US">Double-click on the "Item_No" field from the "Item" table. Display the <emph>Function</emph> line using the context menu and select the Count function.</paragraph>
   </listitem>
   <listitem>
     <paragraph id="par_id3151009" role="listitem" xml-lang="en-US">Enter &gt;3 as a criterion and disable the Visible field.</paragraph>
@@ -349,7 +349,7 @@
 <paragraph id="par_id3147549" role="paragraph" xml-lang="en-US">The following context menu commands and symbols are available:</paragraph>
 
 <paragraph id="hd_id3154172" role="heading" level="3" xml-lang="en-US">Functions</paragraph>
-<paragraph id="par_id3150414" role="paragraph" xml-lang="en-US"><ahelp hid="HID_QRYDGN_ROW_FUNCTION">Shows or hides a row for selection of functions.</ahelp></paragraph>
+<paragraph id="par_id3150414" role="paragraph" xml-lang="en-US"><ahelp hid="HID_QRYDGN_ROW_FUNCTION">Shows or hides a row for the selection of functions.</ahelp></paragraph>
 
 <paragraph id="hd_id3149872" role="heading" level="3" xml-lang="en-US">Table Name</paragraph>
 <paragraph id="par_id3147246" role="paragraph" xml-lang="en-US"><ahelp hid="HID_QRYDGN_ROW_FUNCTION">Shows or hides the row for the table name.</ahelp></paragraph>
@@ -358,19 +358,19 @@
 <paragraph id="par_id3155754" role="paragraph" xml-lang="en-US"><ahelp hid="HID_QRYDGN_ROW_FUNCTION">Shows or hides the row for the alias name.</ahelp></paragraph>
 
 <paragraph id="hd_id3153298" role="heading" level="3" xml-lang="en-US">Distinct Values</paragraph>
-<paragraph id="par_id3147500" role="paragraph" xml-lang="en-US"><ahelp hid="HID_QRYDGN_ROW_FUNCTION">Applies only distinct values to the query.</ahelp> This applies to records containing data that appears several times in the selected fields. If the <emph>Distinct Values</emph> command is active, you will see only one record in the query (DISTINCT). Otherwise, you will see all records corresponding to the query criteria (ALL).</paragraph>
+<paragraph id="par_id3147500" role="paragraph" xml-lang="en-US"><ahelp hid="HID_QRYDGN_ROW_FUNCTION">Retrieves only distinct values from the query.</ahelp> This applies to multiple records that might contain several repeating occurrences of data in the selected fields. If the <emph>Distinct Values</emph> command is active, you should only see one record in the query (DISTINCT). Otherwise, you will see all records corresponding to the query criteria (ALL).</paragraph>
 <paragraph id="par_id3150436" role="paragraph" xml-lang="en-US">For example, if the name "Smith" occurs several times in your address database, you can choose the<emph> Distinct Values</emph> command to specify in the query that the name "Smith" will occur only once.</paragraph>
 <paragraph id="par_id3152352" role="paragraph" xml-lang="en-US">For a query involving several fields, the combination of values from all fields must be unique so that the result can be formed from a specific record. For example, you have "Smith in Chicago" once in your address book and "Smith in London" twice. With the<emph> Distinct Values</emph> command, the query will use the two fields "last name" and "city" and return the query result "Smith in Chicago" once and "Smith in London" once.</paragraph>
 <paragraph id="par_id3149825" role="paragraph" xml-lang="en-US">In SQL, this command corresponds to the DISTINCT predicate.</paragraph>
 
 <paragraph id="hd_id3153290" role="heading" level="3" xml-lang="en-US">Limit</paragraph>
-<paragraph id="par_id3147501" role="paragraph" xml-lang="en-US"><ahelp hid="HID_QRYDGN_ROW_FUNCTION">Allows you to maximize the number of records with which query returns.</ahelp></paragraph>
-<paragraph id="par_id3152350" role="paragraph" xml-lang="en-US">If there is added a <emph>Limit</emph>, you will get at most as many rows as the number you specify. Otherwise, you will see all records corresponding to the query criteria.</paragraph>
+<paragraph id="par_id3147501" role="paragraph" xml-lang="en-US"><ahelp hid="HID_QRYDGN_ROW_FUNCTION">Allows you to limit the maximum number of records returned by a query.</ahelp></paragraph>
+<paragraph id="par_id3152350" role="paragraph" xml-lang="en-US">If a <emph>Limit</emph> construction is added, you will get at most as many rows as the number you specify. Otherwise, you will see all records corresponding to the query criteria.</paragraph>
 
 <paragraph id="hd_id3148926" role="heading" level="3" xml-lang="en-US">Formulating filter conditions</paragraph>
 
 <section id="abfragekriterien">
-<paragraph id="par_id3153162" role="paragraph" xml-lang="en-US">When formulating filter conditions, various operators and commands are available to you. Apart from the relational operators, there are SQL-specific commands that query the content of database fields. If you use these commands in the $[officename] syntax, $[officename] automatically converts these into the corresponding SQL syntax. You can also enter the SQL command directly. The following tables give an overview of the operators and commands:</paragraph>
+<paragraph id="par_id3153162" role="paragraph" xml-lang="en-US">When formulating filter conditions, various operators and commands are available to you. Apart from the relational operators, there are SQL-specific commands that query the content of database fields. If you use these commands in the $[officename] syntax, $[officename] automatically converts these into the corresponding SQL syntax via an internal parser. You can also enter the SQL command directly and bypass the internal parser. The following tables give an overview of the operators and commands:</paragraph>
 
 <table id="tbl_id3152803">
   <tablerow>
@@ -386,19 +386,19 @@
   </tablerow>
   <tablerow>
     <tablecell>
-      <paragraph id="par_id3156161" role="tablecontent" xml-lang="en-US">=</paragraph>
+      <paragraph id="par_id3156161" role="tablecontent" xml-lang="en-US" localize="false">=</paragraph>
     </tablecell>
     <tablecell>
       <paragraph id="par_id3153026" role="tablecontent" xml-lang="en-US">equal to</paragraph>
     </tablecell>
     <tablecell>
       <paragraph id="par_id3148895" role="tablecontent" xml-lang="en-US">... the content of the field is identical to the indicated expression.</paragraph>
-      <paragraph id="par_id3153120" role="tablecontent" xml-lang="en-US">The operator = will not be displayed in the query fields. If you enter a value without any operator, the operator = will be automatically adopted.</paragraph>
+      <paragraph id="par_id3153120" role="tablecontent" xml-lang="en-US">The operator = will not be displayed in the query fields. If you enter a value without any operator, the = operator is automatically assumed.</paragraph>
     </tablecell>
   </tablerow>
   <tablerow>
     <tablecell>
-      <paragraph id="par_id3150470" role="tablecontent" xml-lang="en-US">&lt;&gt;</paragraph>
+      <paragraph id="par_id3150470" role="tablecontent" xml-lang="en-US" localize="false">&lt;&gt;</paragraph>
     </tablecell>
     <tablecell>
       <paragraph id="par_id3145223" role="tablecontent" xml-lang="en-US">not equal to</paragraph>
@@ -409,7 +409,7 @@
   </tablerow>
   <tablerow>
     <tablecell>
-      <paragraph id="par_id3153015" role="tablecontent" xml-lang="en-US">&gt;</paragraph>
+      <paragraph id="par_id3153015" role="tablecontent" xml-lang="en-US" localize="false">&gt;</paragraph>
     </tablecell>
     <tablecell>
       <paragraph id="par_id3146815" role="tablecontent" xml-lang="en-US">greater than</paragraph>
@@ -420,7 +420,7 @@
   </tablerow>
   <tablerow>
     <tablecell>
-      <paragraph id="par_id3147270" role="tablecontent" xml-lang="en-US">&lt;</paragraph>
+      <paragraph id="par_id3147270" role="tablecontent" xml-lang="en-US" localize="false">&lt;</paragraph>
     </tablecell>
     <tablecell>
       <paragraph id="par_id3147379" role="tablecontent" xml-lang="en-US">less than</paragraph>
@@ -431,7 +431,7 @@
   </tablerow>
   <tablerow>
     <tablecell>
-      <paragraph id="par_id3149787" role="tablecontent" xml-lang="en-US">&gt;=</paragraph>
+      <paragraph id="par_id3149787" role="tablecontent" xml-lang="en-US" localize="false">&gt;=</paragraph>
     </tablecell>
     <tablecell>
       <paragraph id="par_id3150636" role="tablecontent" xml-lang="en-US">greater than or equal to</paragraph>
@@ -442,7 +442,7 @@
   </tablerow>
   <tablerow>
     <tablecell>
-      <paragraph id="par_id3157964" role="tablecontent" xml-lang="en-US">&lt;=</paragraph>
+      <paragraph id="par_id3157964" role="tablecontent" xml-lang="en-US" localize="false">&lt;=</paragraph>
     </tablecell>
     <tablecell>
       <paragraph id="par_id3154052" role="tablecontent" xml-lang="en-US">less than or equal to</paragraph>
@@ -471,132 +471,132 @@
   </tablerow>
   <tablerow>
     <tablecell>
-      <paragraph id="par_id3154275" role="tablecontent" xml-lang="en-US">IS EMPTY</paragraph>
+      <paragraph id="par_id3154275" role="tablecontent" xml-lang="en-US" localize="false">IS EMPTY</paragraph>
     </tablecell>
     <tablecell>
-      <paragraph id="par_id3149893" role="tablecontent" xml-lang="en-US">IS NULL</paragraph>
+      <paragraph id="par_id3149893" role="tablecontent" xml-lang="en-US" localize="false">IS NULL</paragraph>
     </tablecell>
     <tablecell>
       <paragraph id="par_id3143236" role="tablecontent" xml-lang="en-US">is null</paragraph>
     </tablecell>
     <tablecell>
-      <paragraph id="par_id3154744" role="tablecontent" xml-lang="en-US">... The value of the field is empty. For Yes/No fields with three states, this command automatically queries the undetermined state (neither Yes nor No).</paragraph>
+      <paragraph id="par_id3154744" role="tablecontent" xml-lang="en-US">... the field contains no data. For Yes/No fields with three possible states, this command automatically queries the undetermined state (neither Yes nor No).</paragraph>
     </tablecell>
   </tablerow>
   <tablerow>
     <tablecell>
-      <paragraph id="par_id3146940" role="tablecontent" xml-lang="en-US">IS NOT EMPTY</paragraph>
+      <paragraph id="par_id3146940" role="tablecontent" xml-lang="en-US" localize="false">IS NOT EMPTY</paragraph>
     </tablecell>
     <tablecell>
-      <paragraph id="par_id3147471" role="tablecontent" xml-lang="en-US">IS NOT NULL</paragraph>
+      <paragraph id="par_id3147471" role="tablecontent" xml-lang="en-US" localize="false">IS NOT NULL</paragraph>
     </tablecell>
     <tablecell>
       <paragraph id="par_id3151229" role="tablecontent" xml-lang="en-US">is not empty</paragraph>
     </tablecell>
     <tablecell>
-      <paragraph id="par_id3145304" role="tablecontent" xml-lang="en-US">... the field name is not empty.</paragraph>
+      <paragraph id="par_id3145304" role="tablecontent" xml-lang="en-US">... the field is not empty, i.e it contains data.</paragraph>
     </tablecell>
   </tablerow>
   <tablerow>
     <tablecell>
-      <paragraph id="par_id3153578" role="tablecontent" xml-lang="en-US">LIKE</paragraph>
-      <paragraph id="par_id3153891" role="tablecontent" xml-lang="en-US">(placeholder * for any number of characters</paragraph>
-      <paragraph id="par_id3148887" role="tablecontent" xml-lang="en-US">placeholder ? for exactly one character)</paragraph>
+      <paragraph id="par_id3153578" role="tablecontent" xml-lang="en-US" localize="false">LIKE</paragraph>
+      <paragraph id="par_id3153891" role="tablecontent" xml-lang="en-US">placeholder (*) for any number of characters</paragraph>
+      <paragraph id="par_id3148887" role="tablecontent" xml-lang="en-US">placeholder (?) for exactly one character</paragraph>
     </tablecell>
     <tablecell>
-      <paragraph id="par_id3148623" role="tablecontent" xml-lang="en-US">LIKE</paragraph>
+      <paragraph id="par_id3148623" role="tablecontent" xml-lang="en-US" localize="false">LIKE</paragraph>
 <bookmark xml-lang="en-US" branch="index" id="bm_id3157985">
   <bookmark_value>placeholders; in SQL queries</bookmark_value>
 </bookmark>
 
-      <paragraph id="par_id3157985" role="tablecontent" xml-lang="en-US">(% placeholder for any number of characters</paragraph>
-      <paragraph id="par_id3147422" role="tablecontent" xml-lang="en-US">Placeholder _ for exactly one character)</paragraph>
+      <paragraph id="par_id3157985" role="tablecontent" xml-lang="en-US">placeholder (%) for any number of characters</paragraph>
+      <paragraph id="par_id3147422" role="tablecontent" xml-lang="en-US">Placeholder (_) for exactly one character</paragraph>
     </tablecell>
     <tablecell>
       <paragraph id="par_id3154845" role="tablecontent" xml-lang="en-US">is an element of</paragraph>
     </tablecell>
     <tablecell>
-      <paragraph id="par_id3156130" role="tablecontent" xml-lang="en-US">... the data field contains the indicated expression. The (*) placeholder indicates whether the expression x occurs at the beginning of (x*), at the end of (*x) or inside the field content (*x*). You can enter as a placeholder in SQL queries either the SQL % character or the familiar (*) file system placeholder in the $[officename] interface.</paragraph>
-      <paragraph id="par_id3150271" role="tablecontent" xml-lang="en-US">The * or % placeholder stands for any number of characters. The question mark (?) in the $[officename] interface or the underscore (_) in SQL queries is used to represent exactly one character.</paragraph>
+      <paragraph id="par_id3156130" role="tablecontent" xml-lang="en-US">... the data field must contain the indicated search string in the order given. The position of the (*) placeholder indicates whether the searched for string (x) occurs before the placeholder (x*), after the placeholder (*x) or between the placeholders (*x*). Instead of the familiar file system (*) placeholder, you can also use the SQL (%) character as a placeholder in SQL queries in the $[officename] interface.</paragraph>
+      <paragraph id="par_id3150271" role="tablecontent" xml-lang="en-US">The (*) or (%) placeholder stands for any number of characters. The question mark (?) in the $[officename] interface or the underscore (_) in SQL queries is used to represent exactly one character.</paragraph>
     </tablecell>
   </tablerow>
   <tablerow>
     <tablecell>
-      <paragraph id="par_id3152954" role="tablecontent" xml-lang="en-US">NOT LIKE</paragraph>
+      <paragraph id="par_id3152954" role="tablecontent" xml-lang="en-US" localize="false">NOT LIKE</paragraph>
     </tablecell>
     <tablecell>
-      <paragraph id="par_id3161669" role="tablecontent" xml-lang="en-US">NOT LIKE</paragraph>
+      <paragraph id="par_id3161669" role="tablecontent" xml-lang="en-US" localize="false">NOT LIKE</paragraph>
     </tablecell>
     <tablecell>
       <paragraph id="par_id3159141" role="tablecontent" xml-lang="en-US">Is not an element of</paragraph>
     </tablecell>
     <tablecell>
-      <paragraph id="par_id3161664" role="tablecontent" xml-lang="en-US">... the field name does not contain the specified expression.</paragraph>
+      <paragraph id="par_id3161664" role="tablecontent" xml-lang="en-US">... the field does not contain data having the specified expression.</paragraph>
     </tablecell>
   </tablerow>
   <tablerow>
     <tablecell>
-      <paragraph id="par_id3149185" role="tablecontent" xml-lang="en-US">BETWEEN x AND y</paragraph>
+      <paragraph id="par_id3149185" role="tablecontent" xml-lang="en-US" localize="false">BETWEEN x AND y</paragraph>
     </tablecell>
     <tablecell>
-      <paragraph id="par_id3151259" role="tablecontent" xml-lang="en-US">BETWEEN x AND y</paragraph>
+      <paragraph id="par_id3151259" role="tablecontent" xml-lang="en-US" localize="false">BETWEEN x AND y</paragraph>
     </tablecell>
     <tablecell>
       <paragraph id="par_id3159184" role="tablecontent" xml-lang="en-US">falls within the interval [x,y]</paragraph>
     </tablecell>
     <tablecell>
-      <paragraph id="par_id3154395" role="tablecontent" xml-lang="en-US">... the field name contains a value that lies between the two values x and y.</paragraph>
+      <paragraph id="par_id3154395" role="tablecontent" xml-lang="en-US">... the field contains a data value that lies between the two values x and y.</paragraph>
     </tablecell>
   </tablerow>
   <tablerow>
     <tablecell>
-      <paragraph id="par_id3154561" role="tablecontent" xml-lang="en-US">NOT BETWEEN x AND y</paragraph>
+      <paragraph id="par_id3154561" role="tablecontent" xml-lang="en-US" localize="false">NOT BETWEEN x AND y</paragraph>
     </tablecell>
     <tablecell>
-      <paragraph id="par_id3148753" role="tablecontent" xml-lang="en-US">NOT BETWEEN x AND y</paragraph>
+      <paragraph id="par_id3148753" role="tablecontent" xml-lang="en-US" localize="false">NOT BETWEEN x AND y</paragraph>
     </tablecell>
     <tablecell>
       <paragraph id="par_id3155498" role="tablecontent" xml-lang="en-US">Does not fall within the interval [x,y]</paragraph>
     </tablecell>
     <tablecell>
-      <paragraph id="par_id3148992" role="tablecontent" xml-lang="en-US">... the field name contains a value that does not lie between the two values x and y.</paragraph>
+      <paragraph id="par_id3148992" role="tablecontent" xml-lang="en-US">... the field contains a data value that does not lie between the two values x and y.</paragraph>
     </tablecell>
   </tablerow>
   <tablerow>
     <tablecell>
-      <paragraph id="par_id3149995" role="tablecontent" xml-lang="en-US">IN (a; b; c...)</paragraph>
-      <paragraph id="par_id3159167" role="tablecontent" xml-lang="en-US">Note that the semicolons are used as separators in all value lists!</paragraph>
+      <paragraph id="par_id3149995" role="tablecontent" xml-lang="en-US" localize="false">IN (a; b; c...)</paragraph>
+      <paragraph id="par_id3159167" role="tablecontent" xml-lang="en-US">Note that semicolons are used as separators in all value lists!</paragraph>
     </tablecell>
     <tablecell>
-      <paragraph id="par_id3159085" role="tablecontent" xml-lang="en-US">IN (a, b, c...)</paragraph>
+      <paragraph id="par_id3159085" role="tablecontent" xml-lang="en-US" localize="false">IN (a, b, c...)</paragraph>
     </tablecell>
     <tablecell>
       <paragraph id="par_id3154809" role="tablecontent" xml-lang="en-US">contains a, b, c...</paragraph>
     </tablecell>
     <tablecell>
-      <paragraph id="par_id3148399" role="tablecontent" xml-lang="en-US">... the field name contains one of the specified expressions a, b, c,... Any number of expressions can be specified, and the result of the query is determined by an Or link. The expressions a, b, c... can be either numbers or characters</paragraph>
+      <paragraph id="par_id3148399" role="tablecontent" xml-lang="en-US">... the field name contains one of the specified expressions a, b, c,... Any number of expressions can be specified, and the result of the query is determined by a boolean OR operator. The expressions a, b, c... can be either numbers or characters</paragraph>
     </tablecell>
   </tablerow>
   <tablerow>
     <tablecell>
-      <paragraph id="par_id3154112" role="tablecontent" xml-lang="en-US">NOT IN (a; b; c...)</paragraph>
+      <paragraph id="par_id3154112" role="tablecontent" xml-lang="en-US" localize="false">NOT IN (a; b; c...)</paragraph>
     </tablecell>
     <tablecell>
-      <paragraph id="par_id3153544" role="tablecontent" xml-lang="en-US">NOT IN (a, b, c...)</paragraph>
+      <paragraph id="par_id3153544" role="tablecontent" xml-lang="en-US" localize="false">NOT IN (a, b, c...)</paragraph>
     </tablecell>
     <tablecell>
       <paragraph id="par_id3150679" role="tablecontent" xml-lang="en-US">does not contain a, b, c...</paragraph>
     </tablecell>
     <tablecell>
-      <paragraph id="par_id3158439" role="tablecontent" xml-lang="en-US">... the field name does not contain one of the specified expressions a, b, c,...</paragraph>
+      <paragraph id="par_id3158439" role="tablecontent" xml-lang="en-US">... the field does not contain one of the specified expressions a, b, c,...</paragraph>
     </tablecell>
   </tablerow>
   <tablerow>
     <tablecell>
-      <paragraph id="par_id3145145" role="tablecontent" xml-lang="en-US">= TRUE</paragraph>
+      <paragraph id="par_id3145145" role="tablecontent" xml-lang="en-US" localize="false">= TRUE</paragraph>
     </tablecell>
     <tablecell>
-      <paragraph id="par_id3146804" role="tablecontent" xml-lang="en-US">= TRUE</paragraph>
+      <paragraph id="par_id3146804" role="tablecontent" xml-lang="en-US" localize="false">= TRUE</paragraph>
     </tablecell>
     <tablecell>
       <paragraph id="par_id3149248" role="tablecontent" xml-lang="en-US">has the value True</paragraph>
@@ -607,16 +607,16 @@
   </tablerow>
   <tablerow>
     <tablecell>
-      <paragraph id="par_id3159212" role="tablecontent" xml-lang="en-US">= FALSE</paragraph>
+      <paragraph id="par_id3159212" role="tablecontent" xml-lang="en-US" localize="false">= FALSE</paragraph>
     </tablecell>
     <tablecell>
-      <paragraph id="par_id3144751" role="tablecontent" xml-lang="en-US">= FALSE</paragraph>
+      <paragraph id="par_id3144751" role="tablecontent" xml-lang="en-US" localize="false">= FALSE</paragraph>
     </tablecell>
     <tablecell>
       <paragraph id="par_id3149955" role="tablecontent" xml-lang="en-US">has the value false</paragraph>
     </tablecell>
     <tablecell>
-      <paragraph id="par_id3146850" role="tablecontent" xml-lang="en-US">... the field name has the value false.</paragraph>
+      <paragraph id="par_id3146850" role="tablecontent" xml-lang="en-US">... the field data value is set to false.</paragraph>
     </tablecell>
   </tablerow>
 </table>
@@ -627,7 +627,7 @@
 <table id="tbl_id3083279">
   <tablerow>
     <tablecell>
-      <paragraph id="par_id3153792" role="paragraph" xml-lang="en-US">='Ms.'</paragraph>
+      <paragraph id="par_id3153792" role="paragraph" xml-lang="en-US" localize="false">='Ms.'</paragraph>
     </tablecell>
     <tablecell>
       <paragraph id="par_id3150948" role="paragraph" xml-lang="en-US">returns field names with the field content "Ms."</paragraph>
@@ -635,7 +635,7 @@
   </tablerow>
   <tablerow>
     <tablecell>
-      <paragraph id="par_id315379A" role="paragraph" xml-lang="en-US">&lt;'2001-01-10'</paragraph>
+      <paragraph id="par_id315379A" role="paragraph" xml-lang="en-US" localize="false">&lt;'2001-01-10'</paragraph>
     </tablecell>
     <tablecell>
       <paragraph id="par_id315094A" role="paragraph" xml-lang="en-US">returns dates that occurred before January 10, 2001</paragraph>
@@ -643,42 +643,42 @@
   </tablerow>
   <tablerow>
     <tablecell>
-      <paragraph id="par_id3150333" role="paragraph" xml-lang="en-US">LIKE 'g?ve'</paragraph>
+      <paragraph id="par_id3150333" role="paragraph" xml-lang="en-US" localize="false">LIKE 'g?ve'</paragraph>
     </tablecell>
     <tablecell>
-      <paragraph id="par_id3147332" role="paragraph" xml-lang="en-US">returns field names with field content such as "give" and "gave".</paragraph>
+      <paragraph id="par_id3147332" role="paragraph" xml-lang="en-US">returns records with field content such as "give" and "gave".</paragraph>
     </tablecell>
   </tablerow>
   <tablerow>
     <tablecell>
-      <paragraph id="par_id3146062" role="paragraph" xml-lang="en-US">LIKE 'S*'</paragraph>
+      <paragraph id="par_id3146062" role="paragraph" xml-lang="en-US" localize="false">LIKE 'S*'</paragraph>
     </tablecell>
     <tablecell>
-      <paragraph id="par_id3155350" role="paragraph" xml-lang="en-US">returns data fields with field contents such as "Sun".</paragraph>
+      <paragraph id="par_id3155350" role="paragraph" xml-lang="en-US">returns records with field contents such as "Sun".</paragraph>
     </tablecell>
   </tablerow>
   <tablerow>
     <tablecell>
-      <paragraph id="par_id3152883" role="paragraph" xml-lang="en-US">BETWEEN 10 AND 20</paragraph>
+      <paragraph id="par_id3152883" role="paragraph" xml-lang="en-US" localize="false">BETWEEN 10 AND 20</paragraph>
     </tablecell>
     <tablecell>
-      <paragraph id="par_id3159406" role="paragraph" xml-lang="en-US">returns field names with field content between the values 10 and 20. (The fields can be either text fields or number fields).</paragraph>
+      <paragraph id="par_id3159406" role="paragraph" xml-lang="en-US">returns records with field content between the values 10 and 20. (The fields can be either text fields or number fields).</paragraph>
     </tablecell>
   </tablerow>
   <tablerow>
     <tablecell>
-      <paragraph id="par_id3148765" role="paragraph" xml-lang="en-US">IN (1; 3; 5; 7)</paragraph>
+      <paragraph id="par_id3148765" role="paragraph" xml-lang="en-US" localize="false">IN (1; 3; 5; 7)</paragraph>
     </tablecell>
     <tablecell>
-      <paragraph id="par_id3149712" role="paragraph" xml-lang="en-US">returns field names with the values 1, 3, 5, 7. If the field name contains an item number, for example, you can create a query that returns the item having the specified number.</paragraph>
+      <paragraph id="par_id3149712" role="paragraph" xml-lang="en-US">returns records with the values 1, 3, 5, 7. If the field name contains an item number, for example, you can create a query that returns the item having the specified number.</paragraph>
     </tablecell>
   </tablerow>
   <tablerow>
     <tablecell>
-      <paragraph id="par_id3152948" role="paragraph" xml-lang="en-US">NOT IN ('Smith')</paragraph>
+      <paragraph id="par_id3152948" role="paragraph" xml-lang="en-US" localize="false">NOT IN ('Smith')</paragraph>
     </tablecell>
     <tablecell>
-      <paragraph id="par_id3147279" role="paragraph" xml-lang="en-US">returns field names that do not contain "Smith".</paragraph>
+      <paragraph id="par_id3147279" role="paragraph" xml-lang="en-US">returns records that do not contain "Smith".</paragraph>
     </tablecell>
   </tablerow>
 </table>
@@ -691,7 +691,7 @@
 <paragraph id="par_id3156052" role="paragraph" xml-lang="en-US">Example: select Article.* from {oj item LEFT OUTER JOIN orders ON item.no=orders.ANR}</paragraph>
 
 <paragraph id="hd_id3153674" role="heading" level="3" xml-lang="en-US">Querying text fields</paragraph>
-<paragraph id="par_id3149134" role="paragraph" xml-lang="en-US">To query the content of a text field, you must put the expression between single quotes. The distinction between uppercase and lowercase letters depends on the database in use. LIKE, by definition, is case-sensitive (though some databases don't see it that strict).</paragraph>
+<paragraph id="par_id3149134" role="paragraph" xml-lang="en-US">To query the content of a text field, you must put the expression between single quotes. The distinction between uppercase and lowercase letters depends on the database in use. LIKE, by definition, is case-sensitive (though some databases don't interpret this strictly).</paragraph>
 
 <paragraph id="hd_id3149302" role="heading" level="3" xml-lang="en-US">Querying date fields</paragraph>
 <paragraph id="par_id3157998" role="paragraph" xml-lang="en-US"> <emph>Date fields</emph> are represented as #Date# to clearly identify them as dates. Date, time and date/time constants (literals) used in conditions can be of either the SQL Escape Syntax type, or default SQL2 syntax.</paragraph>
@@ -716,13 +716,13 @@
       <paragraph id="par_id315913111" role="paragraph" xml-lang="en-US">Date</paragraph>
     </tablecell>
     <tablecell>
-      <paragraph id="par_id315913112" role="paragraph" xml-lang="en-US">{D'YYYY-MM-DD'}</paragraph>
+      <paragraph id="par_id315913112" role="paragraph" xml-lang="en-US" localize="false">{D'YYYY-MM-DD'}</paragraph>
     </tablecell>
     <tablecell>
-      <paragraph id="par_id314975313" role="paragraph" xml-lang="en-US">{d 'YYYY-MM-DD'}</paragraph>
+      <paragraph id="par_id314975313" role="paragraph" xml-lang="en-US" localize="false">{d 'YYYY-MM-DD'}</paragraph>
     </tablecell>
     <tablecell>
-      <paragraph id="par_id314975314" role="paragraph" xml-lang="en-US">'YYYY-MM-DD'</paragraph>
+      <paragraph id="par_id314975314" role="paragraph" xml-lang="en-US" localize="false">'YYYY-MM-DD'</paragraph>
     </tablecell>
   </tablerow>
   <tablerow>
@@ -730,13 +730,13 @@
       <paragraph id="par_id31559471" role="paragraph" xml-lang="en-US">Time</paragraph>
     </tablecell>
     <tablecell>
-      <paragraph id="par_id31559472" role="paragraph" xml-lang="en-US">{D'HH:MM:SS'}</paragraph>
+      <paragraph id="par_id31559472" role="paragraph" xml-lang="en-US" localize="false">{D'HH:MM:SS'}</paragraph>
     </tablecell>
     <tablecell>
-      <paragraph id="par_id31559473" role="paragraph" xml-lang="en-US">{t 'HH:MI:SS[.SS]'} </paragraph>
+      <paragraph id="par_id31559473" role="paragraph" xml-lang="en-US" localize="false">{t 'HH:MI:SS[.SS]'} </paragraph>
     </tablecell>
     <tablecell>
-      <paragraph id="par_id31559474" role="paragraph" xml-lang="en-US">'HH:MI:SS[.SS]' </paragraph>
+      <paragraph id="par_id31559474" role="paragraph" xml-lang="en-US" localize="false">'HH:MI:SS[.SS]' </paragraph>
     </tablecell>
   </tablerow>
   <tablerow>
@@ -744,20 +744,20 @@
       <paragraph id="par_id31509641" role="paragraph" xml-lang="en-US">DateTime</paragraph>
     </tablecell>
     <tablecell>
-      <paragraph id="par_id31509642" role="paragraph" xml-lang="en-US">{D'YYYY-MM-DD HH:MM:SS'}</paragraph>
+      <paragraph id="par_id31509642" role="paragraph" xml-lang="en-US" localize="false">{D'YYYY-MM-DD HH:MM:SS'}</paragraph>
     </tablecell>
     <tablecell>
-      <paragraph id="par_id31509643" role="paragraph" xml-lang="en-US">{ts 'YYYY-MM-DD HH:MI:SS[.SS]'} </paragraph>
+      <paragraph id="par_id31509643" role="paragraph" xml-lang="en-US" localize="false">{ts 'YYYY-MM-DD HH:MI:SS[.SS]'} </paragraph>
     </tablecell>
     <tablecell>
-      <paragraph id="par_id31509644" role="paragraph" xml-lang="en-US">'YYYY-MM-DD HH:MI:SS[.SS]' </paragraph>
+      <paragraph id="par_id31509644" role="paragraph" xml-lang="en-US" localize="false">'YYYY-MM-DD HH:MI:SS[.SS]' </paragraph>
     </tablecell>
   </tablerow>
 </table>
 
 <paragraph id="par_id3149539" role="paragraph" xml-lang="en-US">Example: select {d '1999-12-31'} from world.years</paragraph>
 <paragraph id="par_id3149540" role="paragraph" xml-lang="en-US">Example: select * from mytable where years='1999-12-31' </paragraph>
-<paragraph id="par_id3150510" role="paragraph" xml-lang="en-US">All date expressions (literals) must be enclosed with single quotation marks. (Consult the reference for the particular database and connector you are using for more details.)</paragraph>
+<paragraph id="par_id3150510" role="paragraph" xml-lang="en-US">All date expressions (date literals) must be enclosed with single quotation marks. (Consult the reference for the particular database and connector you are using for more details.)</paragraph>
 
 <paragraph id="hd_id3150427" role="heading" level="3" xml-lang="en-US">Querying Yes/No fields</paragraph>
 <paragraph id="par_id3149523" role="paragraph" xml-lang="en-US">To query Yes/No fields, use the following syntax for dBASE tables:</paragraph>
@@ -827,10 +827,10 @@
 <section id="sqlmode">
 <paragraph id="hd_id3145181" role="heading" level="2" xml-lang="en-US">SQL Mode</paragraph>
 <paragraph id="par_id3147013" role="paragraph" xml-lang="en-US">SQL stands for "Structured Query Language" and describes instructions for updating and administering relational databases.</paragraph>
-<paragraph id="par_id3152570" role="paragraph" xml-lang="en-US">In $[officename] you do not need any knowledge of SQL for most queries, since you do not have to enter the SQL code. If you create a query in the query design, $[officename] automatically converts your instructions into the corresponding SQL syntax. If, with the help of the <emph>Switch Design View On/Off </emph>button, you change to the SQL view, you can see the SQL commands for a query that has been created previously.</paragraph>
-<paragraph id="par_id3152412" role="paragraph" xml-lang="en-US">You can formulate your query directly in the SQL code. Note, however, that the special syntax is dependent upon the database system that you use.</paragraph>
-<paragraph id="par_id3146842" role="paragraph" xml-lang="en-US">If you enter the SQL code manually, you can create SQL-specific queries that are not supported by the graphical interface in <emph>Query design</emph>. These queries must be executed in native SQL mode.</paragraph>
-<paragraph id="par_id3149632" role="paragraph" xml-lang="en-US">By clicking the <link href="text/shared/02/14030000.xhp" name="Run SQL command directly"><emph>Run SQL command directly</emph></link> icon in the SQL view, you can formulate a query that is not processed by $[officename].</paragraph>
+<paragraph id="par_id3152570" role="paragraph" xml-lang="en-US">In $[officename] you do not need any knowledge of SQL for most queries, since you do not have to enter the SQL code. If you create a query in the query designer, $[officename] automatically converts your instructions into the corresponding SQL syntax. If, with the help of the <emph>Switch Design View On/Off </emph>button, you change to the SQL view, you can see the SQL commands for a query that has already been created.</paragraph>
+<paragraph id="par_id3152412" role="paragraph" xml-lang="en-US">You can formulate your query directly in SQL code. Note, however, that the special syntax is dependent upon the database system that you use.</paragraph>
+<paragraph id="par_id3146842" role="paragraph" xml-lang="en-US">If you enter the SQL code manually, you can create SQL-specific queries that are not supported by the graphical interface in the <emph>Query designer</emph>. These queries must be executed in native SQL mode.</paragraph>
+<paragraph id="par_id3149632" role="paragraph" xml-lang="en-US">By clicking the <link href="text/shared/02/14030000.xhp" name="Run SQL command directly"><emph>Run SQL command directly</emph></link> icon in the SQL view, you can formulate a query that is not processed by $[officename]and sent directly to the database engine.</paragraph>
 </section>
 </body>
 
diff --git a/source/text/shared/explorer/database/02010101.xhp b/source/text/shared/explorer/database/02010101.xhp
index e2d81a848b..934764bf73 100644
--- a/source/text/shared/explorer/database/02010101.xhp
+++ b/source/text/shared/explorer/database/02010101.xhp
@@ -1,6 +1,6 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <helpdocument version="1.0">
-	
+
 <!--
  * This file is part of the LibreOffice project.
  *
@@ -18,8 +18,8 @@
  *   except in compliance with the License. You may obtain a copy of
  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  -->
- 
-	
+
+
 <meta>
       <topic id="textsharedexplorerdatabase02010101xml" indexer="include" status="PUBLISH">
          <title xml-lang="en-US" id="tit">Join Properties</title>
@@ -48,16 +48,16 @@
       <paragraph xml-lang="en-US" id="hd_id3159267" role="heading" level="2">Options</paragraph>
 <bookmark xml-lang="en-US" branch="hid/dbaccess/ui/joindialog/type" id="bm_id3147321" localize="false"/>
 <paragraph xml-lang="en-US" id="hd_id3147340" role="heading" level="3">Type</paragraph>
-      <paragraph xml-lang="en-US" id="par_id3152482" role="paragraph"><ahelp hid="dbaccess/ui/joindialog/type">Specifies the link type of the selected link.</ahelp> Some databases support only a subset of the possible types.</paragraph>
+      <paragraph xml-lang="en-US" id="par_id3152482" role="paragraph"><ahelp hid="dbaccess/ui/joindialog/type">Specifies the join type of the selected join.</ahelp> Some databases support only a subset of the various possible types.</paragraph>
       <paragraph xml-lang="en-US" id="hd_id3155334" role="heading" level="3">Inner Join</paragraph>
-      <paragraph xml-lang="en-US" id="par_id3155936" role="paragraph"><ahelp hid="dbaccess/ui/joindialog/type">With the internal join, the results table contains only the records for which the content of the linked fields is the same.</ahelp> In $[officename] SQL this type of link is created by a corresponding WHERE clause.</paragraph>
+      <paragraph xml-lang="en-US" id="par_id3155936" role="paragraph"><ahelp hid="dbaccess/ui/joindialog/type">In an inner join, the results table contains only those records for which the content of the linked fields is the same.</ahelp> In $[officename] SQL this type of link is created by a corresponding WHERE clause.</paragraph>
       <paragraph xml-lang="en-US" id="hd_id3156372" role="heading" level="3">Left Join</paragraph>
-      <paragraph xml-lang="en-US" id="par_id3166450" role="paragraph"><ahelp hid="dbaccess/ui/joindialog/type">With the left join, the results table contains all fields of the left table and only those fields of the right table for which the content of the linked fields is the same.</ahelp> In $[officename] SQL this type of link corresponds to the LEFT OUTER JOIN command.</paragraph>
+      <paragraph xml-lang="en-US" id="par_id3166450" role="paragraph"><ahelp hid="dbaccess/ui/joindialog/type">In a left join, the results table contains all records of the queried fields from the left table and only those records of the queried fields from the right table for which the content of the linked fields is the same.</ahelp> In $[officename] SQL this type of link corresponds to the LEFT OUTER JOIN command.</paragraph>
       <paragraph xml-lang="en-US" id="hd_id3155607" role="heading" level="3">Right Join</paragraph>
-      <paragraph xml-lang="en-US" id="par_id3150647" role="paragraph"><ahelp hid="dbaccess/ui/joindialog/type">With the right join, the results table contains all fields of the right table and only those fields of the left table for which the content of the linked fields is the same.</ahelp> In $[officename] SQL this type of link corresponds to the RIGHT OUTER JOIN command.</paragraph>
+      <paragraph xml-lang="en-US" id="par_id3150647" role="paragraph"><ahelp hid="dbaccess/ui/joindialog/type">In a right join, the results table contains all records of the queried fields from the right table and only those records of the queried fields from the left table for which the content of the linked fields is the same.</ahelp> In $[officename] SQL this type of link corresponds to the RIGHT OUTER JOIN command.</paragraph>
       <paragraph xml-lang="en-US" id="hd_id3158215" role="heading" level="3">Full Join</paragraph>
-      <paragraph xml-lang="en-US" id="par_id3163665" role="paragraph"><ahelp hid="dbaccess/ui/joindialog/type">For a full join, the results table contains all fields of the left and right tables.</ahelp> In the SQL of $[officename] this type of link corresponds to the FULL OUTER JOIN command.</paragraph>
+      <paragraph xml-lang="en-US" id="par_id3163665" role="paragraph"><ahelp hid="dbaccess/ui/joindialog/type">In a full join, the results table contains all records of the queried fields from the left and right tables.</ahelp> In the SQL of $[officename] this type of link corresponds to the FULL OUTER JOIN command.</paragraph>
 <paragraph xml-lang="en-US" id="hd_id0305200912031976" role="heading" level="3">Natural</paragraph>
-      <paragraph xml-lang="en-US" id="par_id0305200912031977" role="paragraph"><ahelp hid=".">Inserts the keyword NATURAL into the SQL statement that defines the relation. The relation joins all columns that have the same column name in both tables. The resulting joined table contains only one column for each pair of equally named columns.</ahelp></paragraph>
+      <paragraph xml-lang="en-US" id="par_id0305200912031977" role="paragraph"><ahelp hid=".">In a nautral join, the keyword NATURAL in inserted into the SQL statement that defines the relation. The relation joins all columns that have the same column name in both tables. The resulting joined table contains only one column for each pair of equally named columns.</ahelp></paragraph>
    </body>
 </helpdocument>
diff --git a/source/text/shared/explorer/database/04000000.xhp b/source/text/shared/explorer/database/04000000.xhp
index b44e4976e6..2498eecc83 100644
--- a/source/text/shared/explorer/database/04000000.xhp
+++ b/source/text/shared/explorer/database/04000000.xhp
@@ -19,7 +19,7 @@
  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  -->
 
-	
+
 <helpdocument version="1.0">
 <meta>
 <topic id="textsharedexplorerdatabase04000000xml" indexer="exclude" status="PUBLISH">
@@ -39,7 +39,7 @@
 </section>
 <paragraph role="heading" id="hd_id3157910" xml-lang="en-US" level="2"><link href="text/shared/autopi/01090000.xhp" name="Form Wizard">FormWizard</link></paragraph>
 <paragraph role="heading" id="hd_id3156003" xml-lang="en-US" level="2"><link href="text/shared/02/01170000.xhp" name="Form Controls">Form Controls</link></paragraph>
-<paragraph role="paragraph" id="par_id3156156" xml-lang="en-US">The Form Controls toolbar offers the tools required to create a form in a text, table, drawing, or presentation document.</paragraph>
+<paragraph role="paragraph" id="par_id3156156" xml-lang="en-US">The Form Controls toolbar provides the tools required to create a form in a text, table, drawing, or presentation document.</paragraph>
 <paragraph role="heading" id="hd_id3155388" xml-lang="en-US" level="2"><link href="text/shared/explorer/database/04030000.xhp" name="Form in Design Mode">Form in Design Mode</link></paragraph>
 <paragraph role="paragraph" id="par_id3150504" xml-lang="en-US">In design mode, the form is designed and the properties of the form and the controls contained in it are defined.</paragraph>
 <embed href="text/shared/02/12100200.xhp#datensatzsuche"/>
diff --git a/source/text/shared/explorer/database/04030000.xhp b/source/text/shared/explorer/database/04030000.xhp
index a26a9b5ada..2cbf9da84a 100644
--- a/source/text/shared/explorer/database/04030000.xhp
+++ b/source/text/shared/explorer/database/04030000.xhp
@@ -19,7 +19,7 @@
  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  -->
 
-	
+
 <helpdocument version="1.0">
 <meta>
 <topic id="textsharedexplorerdatabase04030000xml" indexer="exclude" status="PUBLISH">
@@ -37,13 +37,13 @@
 </variable></paragraph>
 <paragraph role="paragraph" id="par_id3154230" xml-lang="en-US">Any $[officename] document can be expanded into a form. Simply add one or more form controls.</paragraph>
 <paragraph role="paragraph" id="par_id3145382" xml-lang="en-US">Open the Form Controls toolbar. The Form Controls toolbar contains the <link href="text/shared/02/01170000.xhp" name="functions">functions</link> needed to edit a form. More functions can be found in the <emph>Form Design</emph> bar and <emph>More Controls</emph> bar.</paragraph>
-<paragraph role="paragraph" id="par_id3153146" xml-lang="en-US">In the form design you can <link href="text/shared/02/01170000.xhp" name="include controls">include controls</link>, <link href="text/shared/02/01170100.xhp" name="apply properties">apply properties</link> to them, define <link href="text/shared/02/01170200.xhp" name="Form properties">Form properties</link>, and <link href="text/shared/02/01170203.xhp" name="define subforms">define subforms</link>.</paragraph>
-<paragraph role="paragraph" id="par_id3154924" xml-lang="en-US">The<emph> Form Navigator</emph> icon 
+<paragraph role="paragraph" id="par_id3153146" xml-lang="en-US">In form design mode you can <link href="text/shared/02/01170000.xhp" name="include controls">include controls</link>, <link href="text/shared/02/01170100.xhp" name="apply properties">apply properties</link> to them, define <link href="text/shared/02/01170200.xhp" name="Form properties">Form properties</link>, and <link href="text/shared/02/01170203.xhp" name="define subforms">define subforms</link>.</paragraph>
+<paragraph role="paragraph" id="par_id3154924" xml-lang="en-US">The<emph> Form Navigator</emph> icon
 <image id="img_id3156002" src="cmd/sc_showfmexplorer.png" width="4.23mm" height="4.23mm"><alt id="alt_id3156002" xml-lang="en-US">Icon</alt>
 	</image> on the Form Design bar opens the <link href="text/shared/02/01170600.xhp" name="Form Navigator"><emph>Form Navigator</emph></link>.</paragraph>
-<paragraph role="paragraph" id="par_id3153968" xml-lang="en-US">The <link href="text/shared/02/01171000.xhp" name="Open in Design Mode"><emph>Open in Design Mode</emph></link> icon 
+<paragraph role="paragraph" id="par_id3153968" xml-lang="en-US">The <link href="text/shared/02/01171000.xhp" name="Open in Design Mode"><emph>Open in Design Mode</emph></link> icon
 <image id="img_id1871395" src="cmd/sc_openreadonly.png" width="5.59mm" height="5.59mm"><alt id="alt_id1871395" xml-lang="en-US">Icon</alt>
-	</image> allows you to save a form document so that it always opens in editing mode.</paragraph>
-<paragraph role="paragraph" id="par_id3154948" xml-lang="en-US">If there is an error when assigning properties to the objects contained in the form (for example, when assigning a non-existent database table to an object), a corresponding error message appears. This error message may contain a <emph>More</emph> button. <ahelp hid="dummy">If you click <emph>More</emph>, a dialog displaying more information about the current problem appears.</ahelp></paragraph>
+	</image> allows you to save a form document so that it always opens in form design mode.</paragraph>
+<paragraph role="paragraph" id="par_id3154948" xml-lang="en-US">If there is an error when assigning properties to the objects contained in the form (for example, when assigning a non-existent database table to an object), a corresponding error message appears. This error message may contain a <emph>More</emph> button. <ahelp hid="dummy">If you click on <emph>More</emph>, a dialog displaying more information about the current problem appears.</ahelp></paragraph>
 </body>
 </helpdocument>
diff --git a/source/text/shared/explorer/database/05000000.xhp b/source/text/shared/explorer/database/05000000.xhp
index 9872515a39..bb36000171 100644
--- a/source/text/shared/explorer/database/05000000.xhp
+++ b/source/text/shared/explorer/database/05000000.xhp
@@ -20,7 +20,7 @@
  -->
 
 
-	
+
 <helpdocument version="1.0">
 <meta>
 <topic id="textsharedexplorerdatabase05000000xml" indexer="exclude" status="PUBLISH">
@@ -34,7 +34,7 @@
 <body>
 <section id="tabellen">
 <paragraph role="heading" id="hd_id3148520" xml-lang="en-US" level="1"><link href="text/shared/explorer/database/05000000.xhp" name="Tables">Tables</link></paragraph>
-<paragraph role="paragraph" id="par_id3147102" xml-lang="en-US">Data sources tables allow you see your data line by line. You can make new entries and deletions.</paragraph>
+<paragraph role="paragraph" id="par_id3147102" xml-lang="en-US">Table data edit mode allows you to see your data as rows of records, with optional filtering and sorting of that data. In this mode, you can also enter new records, make changes to, and delete existing records.</paragraph>
 </section>
 <paragraph role="paragraph" id="par_id3147226" xml-lang="en-US">In the $[officename] Help, you will find further information on the following subjects:</paragraph>
 <paragraph role="heading" id="hd_id3152425" xml-lang="en-US" level="2"><link href="text/shared/explorer/database/05010000.xhp" name="Create new or edit table design">Create new or edit table design</link></paragraph>
diff --git a/source/text/shared/explorer/database/05000001.xhp b/source/text/shared/explorer/database/05000001.xhp
index 5e6b80233c..040e27c28c 100644
--- a/source/text/shared/explorer/database/05000001.xhp
+++ b/source/text/shared/explorer/database/05000001.xhp
@@ -20,7 +20,7 @@
  -->
 
 
-	
+
 <helpdocument version="1.0">
 <meta>
 <topic id="textsharedexplorerdatabase05000001xml" indexer="exclude" status="PUBLISH">
@@ -34,12 +34,12 @@
 <body>
 <section id="kontext">
 <paragraph role="heading" id="hd_id3148983" xml-lang="en-US" level="1"><link href="text/shared/explorer/database/05000001.xhp" name="Table Context Menus">Table Context Menus</link></paragraph>
-<paragraph role="paragraph" id="par_id3163829" xml-lang="en-US">The context menu of the table container offers various functions that apply to all database tables. To edit a special table within the database, select the corresponding table and open its context menu.</paragraph>
+<paragraph role="paragraph" id="par_id3163829" xml-lang="en-US">The context menu of the table container offers various functions that apply to all database tables. To edit a particular table within the database, select the corresponding table and open its context menu.</paragraph>
 </section>
 <section id="howtoget">
   <embed href="text/shared/00/00000450.xhp#Tabellen"/>
 </section>
-<paragraph role="note" id="par_id3146958" xml-lang="en-US">Depending on the context, it is possible that not all the functions for your current database are listed in the context menus. For example, the <emph>Relationships</emph> command for defining relationships between various tables is only available with relational databases.</paragraph>
+<paragraph role="note" id="par_id3146958" xml-lang="en-US">Depending on the context, it is possible that not all the functions for your current database will be listed in the context menus. For example, the <emph>Relationships</emph> command for defining relationships between various tables is only available with relational databases.</paragraph>
 <paragraph role="paragraph" id="par_id3145382" xml-lang="en-US">Depending on the database system used, you will find the following entries on the context menus:</paragraph>
 <embed href="text/shared/00/00000010.xhp#oeffnen"/>
 <paragraph role="paragraph" id="par_id3166461" xml-lang="en-US">If a <link href="text/shared/01/05340400.xhp" name="table is open">table is open</link>, there are several functions available to edit the data.</paragraph>
diff --git a/source/text/shared/explorer/database/05000003.xhp b/source/text/shared/explorer/database/05000003.xhp
index 8980fc8a17..56227495a9 100644
--- a/source/text/shared/explorer/database/05000003.xhp
+++ b/source/text/shared/explorer/database/05000003.xhp
@@ -18,7 +18,7 @@
  *   except in compliance with the License. You may obtain a copy of
  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  -->
-	
+
 <helpdocument version="1.0">
 <meta>
 <topic id="textsharedexplorerdatabase05000003xml" indexer="include" status="PUBLISH">
@@ -31,13 +31,13 @@
 </meta>
 <body>
 <paragraph role="heading" id="hd_id3163829" xml-lang="en-US" level="1">Enter / change password</paragraph>
-<paragraph role="paragraph" id="par_id3148520" xml-lang="en-US">Allows you to enter and confirm a new or changed password. If you have defined a new user, enter the user's name in this dialog.</paragraph>
+<paragraph role="paragraph" id="par_id3148520" xml-lang="en-US">Allows you to enter and confirm a new or changed password. If you have defined a new user, enter the user name in this dialog.</paragraph>
 <bookmark xml-lang="en-US" branch="hid/sfx/ui/password/usered" id="bm_id3149283" localize="false"/>
 <paragraph role="heading" id="hd_id3157898" xml-lang="en-US" level="2">User</paragraph>
 <paragraph role="paragraph" id="par_id3149346" xml-lang="en-US"><ahelp hid="sfx/ui/password/usered">Specifies the name of the new user.</ahelp> This field is only visible if you have defined a new user.</paragraph>
 <bookmark xml-lang="en-US" branch="hid/dbaccess/ui/password/oldpassword" id="bm_id3145346" localize="false"/>
 <paragraph role="heading" id="hd_id3153681" xml-lang="en-US" level="2">Old password</paragraph>
-<paragraph role="paragraph" id="par_id3147576" xml-lang="en-US"><ahelp hid="dbaccess/ui/password/oldpassword">Enter the old password.</ahelp> This field is visible when you have started the dialog via <emph>Change password</emph>.</paragraph>
+<paragraph role="paragraph" id="par_id3147576" xml-lang="en-US"><ahelp hid="dbaccess/ui/password/oldpassword">Enter the old password here.</ahelp> This field is visible when you have opened the dialog via <emph>Change password</emph>.</paragraph>
 <bookmark xml-lang="en-US" branch="hid/dbaccess/ui/password/newpassword" id="bm_id3166411" localize="false"/>
 <paragraph role="heading" id="hd_id3153311" xml-lang="en-US" level="2">Password</paragraph>
 <paragraph role="paragraph" id="par_id3147243" xml-lang="en-US"><ahelp hid="dbaccess/ui/password/newpassword">Enter the new password.</ahelp></paragraph><comment>UFI: removed help id</comment>
diff --git a/source/text/shared/explorer/database/05010000.xhp b/source/text/shared/explorer/database/05010000.xhp
index 6e686a519e..cfd7dd0a57 100644
--- a/source/text/shared/explorer/database/05010000.xhp
+++ b/source/text/shared/explorer/database/05010000.xhp
@@ -20,7 +20,7 @@
  -->
 
 
-	
+
 <helpdocument version="1.0">
 <meta>
 <topic id="textsharedexplorerdatabase05010000xml" indexer="exclude" status="PUBLISH">
@@ -34,7 +34,7 @@
 <body>
 <section id="tabellenentwurf">
 <paragraph role="heading" id="hd_id3154228" xml-lang="en-US" level="1"><link href="text/shared/explorer/database/05010000.xhp" name="Table Design">Table Design</link></paragraph>
-<paragraph role="paragraph" id="par_id3152363" xml-lang="en-US">In the <emph>Table Design</emph> window you define new tables or edit the structure of a table.</paragraph>
+<paragraph role="paragraph" id="par_id3152363" xml-lang="en-US">In the <emph>Table Design</emph> window you define new tables or edit the structure of an existing table.</paragraph>
 </section>
 <section id="howtoget">
   <embed href="text/shared/00/00000450.xhp#tabellenentwurf"/>
@@ -47,13 +47,13 @@
 <paragraph role="paragraph" id="par_id3153681" xml-lang="en-US"><ahelp hid="HID_TABDESIGN_BACKGROUND">This area is where you define the table structure.</ahelp></paragraph>
 <bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_TABDESIGN_NAMECELL" id="bm_id3145382" localize="false"/>
 <paragraph role="heading" id="hd_id3153031" xml-lang="en-US" level="3">Field Name</paragraph>
-<paragraph role="paragraph" id="par_id3156113" xml-lang="en-US"><ahelp hid="HID_TABDESIGN_NAMECELL">Specifies the name of the data field. Note the database restrictions, such as the length of the name, special characters and spaces.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3156113" xml-lang="en-US"><ahelp hid="HID_TABDESIGN_NAMECELL">Specifies the name of the data field. The database engine may impose restrictions on the length of the table name, and the use of special characters and spaces within the table name.</ahelp></paragraph>
 <bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_TABDESIGN_TYPECELL" id="bm_id3148473" localize="false"/>
 <paragraph role="heading" id="hd_id3147618" xml-lang="en-US" level="3">Field type</paragraph>
-<paragraph role="paragraph" id="par_id3154897" xml-lang="en-US"><ahelp hid="HID_TABDESIGN_TYPECELL">Specifies the field type.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3154897" xml-lang="en-US"><ahelp hid="HID_TABDESIGN_TYPECELL">Specifies the field type. The available field types are limited by the database engine being used.</ahelp></paragraph>
 <bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_TABDESIGN_COMMENTCELL" id="bm_id3149233" localize="false"/>
 <paragraph role="heading" id="hd_id3156119" xml-lang="en-US" level="3">Description</paragraph>
-<paragraph role="paragraph" id="par_id3145315" xml-lang="en-US"><ahelp hid="HID_TABDESIGN_COMMENTCELL">Specifies an optional description.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3145315" xml-lang="en-US"><ahelp hid="HID_TABDESIGN_COMMENTCELL">Specifies an optional description for each field.</ahelp></paragraph>
 <paragraph role="paragraph" id="par_id3155630" xml-lang="en-US">The row headers contain the following context menu commands:</paragraph>
 <paragraph role="heading" id="hd_id3156330" xml-lang="en-US" level="3">Cut</paragraph>
 <paragraph role="paragraph" id="par_id3159157" xml-lang="en-US">Cuts the selected row to the clipboard.</paragraph>
@@ -65,14 +65,14 @@
 <paragraph role="paragraph" id="par_id3148550" xml-lang="en-US"><ahelp hid=".uno:Delete">Deletes the selected row.</ahelp></paragraph>
 <bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_TABLEDESIGN_INSERTROWS" id="bm_id3159414" localize="false"/>
 <paragraph role="heading" id="hd_id3147303" xml-lang="en-US" level="3">Insert Rows</paragraph>
-<paragraph role="paragraph" id="par_id3149456" xml-lang="en-US"><ahelp hid="SID_TABLEDESIGN_INSERTROWS">Inserts an empty row above the current row, if the table has not been saved. Inserts an empty row at the end of the table if the table has been saved.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3149456" xml-lang="en-US"><ahelp hid="SID_TABLEDESIGN_INSERTROWS">Inserts an empty row above the current row, if the table has not been saved. Inserts an empty row at the end of the table if the table has already been saved.</ahelp></paragraph>
 <bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_TABLEDESIGN_TABED_PRIMARYKEY" id="bm_id3150791" localize="false"/>
 <paragraph role="heading" id="hd_id3153524" xml-lang="en-US" level="3">Primary Key</paragraph>
-<paragraph role="paragraph" id="par_id3150398" xml-lang="en-US"><ahelp hid="SID_TABLEDESIGN_TABED_PRIMARYKEY">If this command has a check mark, the data field in this line is a primary key.</ahelp> By clicking the command you activate/deactivate the status. The command is only visible if the data source supports primary keys.</paragraph>
+<paragraph role="paragraph" id="par_id3150398" xml-lang="en-US"><ahelp hid="SID_TABLEDESIGN_TABED_PRIMARYKEY">If this command has a check mark, the data field is defined as a primary key.</ahelp> By clicking the command you activate/deactivate the primary key definition of the field. The command is only visible if the data source supports primary keys.</paragraph>
 <paragraph role="heading" id="hd_id3153104" xml-lang="en-US" level="2">Field properties</paragraph>
 <paragraph role="paragraph" id="par_id3148922" xml-lang="en-US">Defines the field properties of the currently selected field.</paragraph>
 <paragraph role="heading" id="hd_id3150767" xml-lang="en-US" level="3">Length</paragraph>
-<paragraph role="paragraph" id="par_id3144761" xml-lang="en-US">Specifies the length of the data field.</paragraph>
+<paragraph role="paragraph" id="par_id3144761" xml-lang="en-US">Specifies the maximum number of characters allowed for data entry of the corresponding data field including any spaces or special characters.</paragraph>
 <paragraph role="heading" id="hd_id3154948" xml-lang="en-US" level="3">Decimal places</paragraph>
 <paragraph role="paragraph" id="par_id3149203" xml-lang="en-US">Specifies the number of decimal places for a numerical field or decimal field.</paragraph>
 <bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_TAB_ENT_DEFAULT" id="bm_id3158410" localize="false"/>
@@ -80,12 +80,12 @@
 <paragraph role="paragraph" id="par_id3125863" xml-lang="en-US"><ahelp hid="HID_TAB_ENT_DEFAULT">Specifies the value that is the default in new data records.</ahelp></paragraph>
 <bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_TAB_ENT_FORMAT_SAMPLE" id="bm_id3149562" localize="false"/>
 <paragraph role="heading" id="hd_id3147289" xml-lang="en-US" level="3">Format example</paragraph>
-<paragraph role="paragraph" id="par_id3155131" xml-lang="en-US"><ahelp hid="HID_TAB_ENT_FORMAT_SAMPLE">Displays the format code that you can select with the<emph> ... </emph>button.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3155131" xml-lang="en-US"><ahelp hid="HID_TAB_ENT_FORMAT_SAMPLE">Displays the format code to assign to the field value that you can select with the<emph> ... </emph>button.</ahelp></paragraph>
 <bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_TAB_ENT_FORMAT" id="bm_id3147319" localize="false"/>
 <paragraph role="heading" id="hd_id3154129" xml-lang="en-US" level="3">...</paragraph>
 <paragraph role="paragraph" id="par_id3154146" xml-lang="en-US"><ahelp hid="HID_TAB_ENT_FORMAT">This button opens the <link href="text/shared/01/05340405.xhp" name="Field Format"><emph>Field Format</emph></link> dialog.</ahelp></paragraph>
 <bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_TABLE_DESIGN_HELP_WINDOW" id="bm_id3152941" localize="false"/>
 <paragraph role="heading" id="hd_id3152576" xml-lang="en-US" level="2">Help area</paragraph>
-<paragraph role="paragraph" id="par_id3150685" xml-lang="en-US"><ahelp hid="HID_TABLE_DESIGN_HELP_WINDOW">Displays help texts.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3150685" xml-lang="en-US"><ahelp hid="HID_TABLE_DESIGN_HELP_WINDOW">Displays a help string or hint defined by the database designer for the given field.</ahelp></paragraph>
 </body>
 </helpdocument>
diff --git a/source/text/shared/explorer/database/05010100.xhp b/source/text/shared/explorer/database/05010100.xhp
index db5d27ca7e..4381696f63 100644
--- a/source/text/shared/explorer/database/05010100.xhp
+++ b/source/text/shared/explorer/database/05010100.xhp
@@ -32,14 +32,14 @@
 <section id="indexentwurf">
 <bookmark xml-lang="en-US" branch="hid/dbaccess/ui/indexdesigndialog/IndexDesignDialog" id="bm_id3156410" localize="false"/>
 <bookmark xml-lang="en-US" branch="hid/.uno:DBIndexDesign" id="bm_id3149828" localize="false"/><paragraph role="heading" id="hd_id3153311" xml-lang="en-US" level="1"><link href="text/shared/explorer/database/05010100.xhp" name="Index design">Index design</link></paragraph>
-<paragraph role="paragraph" id="par_id3166460" xml-lang="en-US"><ahelp hid=".uno:DBIndexDesign">The <emph>Index Design </emph>dialog allows you edit the indexes for the current table.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3166460" xml-lang="en-US"><ahelp hid=".uno:DBIndexDesign">The <emph>Index Design </emph>dialog allows you to define and edit the indexes for the current table.</ahelp></paragraph>
 </section>
 <section id="howtoget">
   <embed href="text/shared/00/00000450.xhp#indexentwurf"/>
 </section>
 <embed href="text/shared/guide/data_tabledefine.xhp#data_tabledefine"/>
 <bookmark xml-lang="en-US" branch="hid/dbaccess/ui/indexdesigndialog/INDEX_LIST" id="bm_id3148473" localize="false"/><paragraph role="heading" id="hd_id3149578" xml-lang="en-US" level="2">Index list</paragraph>
-<paragraph role="paragraph" id="par_id3155342" xml-lang="en-US"><ahelp hid="dbaccess/ui/indexdesigndialog/INDEX_LIST">Displays the available indexes. Select an index from the list to edit. The details of the selected index are displayed in the dialog.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3155342" xml-lang="en-US"><ahelp hid="dbaccess/ui/indexdesigndialog/INDEX_LIST">Displays a list of available indexes. Select an index from the list to edit. The details of the selected index are displayed in the dialog.</ahelp></paragraph>
 <bookmark xml-lang="en-US" branch="hid/dbaccess/ui/indexdesigndialog/ID_INDEX_NEW" id="bm_id3158430" localize="false"/><paragraph role="heading" id="hd_id3149795" xml-lang="en-US" level="3">New Index</paragraph>
 <paragraph role="paragraph" id="par_id3150085" xml-lang="en-US"><ahelp hid="dbaccess/ui/indexdesigndialog/ID_INDEX_NEW">Creates a new index.</ahelp></paragraph>
 <bookmark xml-lang="en-US" branch="hid/dbaccess/ui/indexdesigndialog/ID_INDEX_DROP" id="bm_id3148642" localize="false"/><paragraph role="heading" id="hd_id3145317" xml-lang="en-US" level="3">Delete Current Index</paragraph>
@@ -51,7 +51,7 @@
 <bookmark xml-lang="en-US" branch="hid/dbaccess/ui/indexdesigndialog/ID_INDEX_RESET" id="bm_id3147265" localize="false"/><paragraph role="heading" id="hd_id3154924" xml-lang="en-US" level="3">Reset Current Index</paragraph>
 <paragraph role="paragraph" id="par_id3154758" xml-lang="en-US"><ahelp hid="dbaccess/ui/indexdesigndialog/ID_INDEX_RESET">Resets the current index to the setting that it had when the dialog was started.</ahelp></paragraph>
 <paragraph role="heading" id="hd_id3152812" xml-lang="en-US" level="2">Index details</paragraph>
-<paragraph role="paragraph" id="par_id3154938" xml-lang="en-US">As soon as you change a detail of the current index and then select another index, the change is immediately passed to the data source. You can only leave the dialog, or select another index, if the change has been successfully acknowledged by the data source. However, you can undo the change by clicking the <emph>Reset Current Index </emph>icon.</paragraph>
+<paragraph role="paragraph" id="par_id3154938" xml-lang="en-US">As soon as you change a detail of the current index and then select another index, the change is immediately passed on to the data source. You can only leave the dialog, or select another index, if the change has been successfully acknowledged by the data source. However, you can undo the change by clicking the <emph>Reset Current Index </emph>icon.</paragraph>
 <bookmark xml-lang="en-US" branch="hid/dbaccess/ui/indexdesigndialog/UNIQUE" id="bm_id3145171" localize="false"/><paragraph role="heading" id="hd_id3154138" xml-lang="en-US" level="3">Unique</paragraph>
 <paragraph role="paragraph" id="par_id3156282" xml-lang="en-US"><ahelp hid="dbaccess/ui/indexdesigndialog/UNIQUE">Specifies whether the current index allows only unique values.</ahelp> Checking the <emph>Unique </emph>option prevents duplicate data from being entered in the field and ensures data integrity.</paragraph>
 <paragraph role="heading" id="hd_id3150448" xml-lang="en-US" level="3">Fields</paragraph>
@@ -59,7 +59,7 @@
 <bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DLGINDEX_INDEXDETAILS_FIELD" id="bm_id3147230" localize="false"/><paragraph role="heading" id="hd_id3149765" xml-lang="en-US" level="3">Index field</paragraph>
 <paragraph role="paragraph" id="par_id3158408" xml-lang="en-US"><ahelp hid="HID_DLGINDEX_INDEXDETAILS_FIELD">Displays a list of the fields in the current table. You can select more than one field.</ahelp><comment>i73718</comment></paragraph>
 <bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DLGINDEX_INDEXDETAILS_SORTORDER" id="bm_id3154910" localize="false"/><paragraph role="heading" id="hd_id3153192" xml-lang="en-US" level="3">Sort order</paragraph>
-<paragraph role="paragraph" id="par_id3149561" xml-lang="en-US"><ahelp hid="HID_DLGINDEX_INDEXDETAILS_SORTORDER">Determines the sort order.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3149561" xml-lang="en-US"><ahelp hid="HID_DLGINDEX_INDEXDETAILS_SORTORDER">Determines the sort order of the indexes.</ahelp></paragraph>
 <bookmark xml-lang="en-US" branch="hid/dbaccess/ui/indexdesigndialog/close" id="bm_id3145785" localize="false"/><paragraph role="heading" id="hd_id3155132" xml-lang="en-US" level="2">Close</paragraph>
 <paragraph role="paragraph" id="par_id3154190" xml-lang="en-US"><ahelp hid="dbaccess/ui/indexdesigndialog/close">Closes the dialog.</ahelp></paragraph>
 </body>
diff --git a/source/text/shared/explorer/database/05020000.xhp b/source/text/shared/explorer/database/05020000.xhp
index c4eaad9724..96a89ef00e 100644
--- a/source/text/shared/explorer/database/05020000.xhp
+++ b/source/text/shared/explorer/database/05020000.xhp
@@ -39,25 +39,25 @@
 <embed href="text/shared/00/00000450.xhp#relationen"/>
 </section>
 <paragraph role="note" id="par_id3145316" xml-lang="en-US">This function is only available if you are working with a relational database.</paragraph>
-<paragraph role="paragraph" id="par_id3149235" xml-lang="en-US">When you choose <emph>Tools - Relationships</emph>, a window opens in which all the existing relationships between the tables of the current database are shown. If no relationships have been defined, or if you want to relate other tables of the database to each other, then click the <emph>Add Tables</emph> icon. The <link href="text/shared/02/14020100.xhp" name="Add Tables">Add Tables</link> dialog opens in which you can select the tables that you want.</paragraph>
+<paragraph role="paragraph" id="par_id3149235" xml-lang="en-US">When you choose <emph>Tools - Relationships</emph>, a window opens in which all the existing relationships between the tables of the current database are shown. If no relationships have been defined, or if you want to relate other tables of the database to each other, then click on the <emph>Add Tables</emph> icon. The <link href="text/shared/02/14020100.xhp" name="Add Tables">Add Tables</link> dialog opens in which you can select the tables with which to create a relation.</paragraph>
 <embed href="text/shared/00/00000450.xhp#sytabelle"/>
 <paragraph role="note" id="par_id3152812" xml-lang="en-US">If the <emph>Relation Design</emph> window is open, the selected tables cannot be modified, even in Table Design mode. This ensures that tables are not changed while the relations are being created.</paragraph>
-<paragraph role="paragraph" id="par_id3150541" xml-lang="en-US">The selected tables are shown in the top area of the design view. You can close a table window through the context menu or with the Delete key.</paragraph>
+<paragraph role="paragraph" id="par_id3150541" xml-lang="en-US">The selected tables are shown in the top area of the relation design view. You can close a table window through the context menu or with the Delete key.</paragraph>
 <embed href="text/shared/explorer/database/02010100.xhp#darstellungaendern"/>
 <bookmark xml-lang="en-US" branch="index" id="bm_id3148922"><bookmark_value>primary keys;inserting (Base)</bookmark_value>
 <bookmark_value>keys;primary keys (Base)</bookmark_value>
 <bookmark_value>external keys (Base)</bookmark_value>
 </bookmark><comment>mw added "(Base)" to all entries</comment>
-<paragraph role="heading" id="hd_id3148922" xml-lang="en-US" level="2">Primary key and other key</paragraph>
-<paragraph role="paragraph" id="par_id3149168" xml-lang="en-US">If you want to define a relation among the different tables, you should enter a <link href="text/shared/00/00000005.xhp#primaerschluessel" name="primary key">primary key</link> that clearly identifies a data field of the existing table. You can refer to the primary key from other tables to access the data of this table. All data fields referring to this primary key will be identified as an external key.</paragraph>
+<paragraph role="heading" id="hd_id3148922" xml-lang="en-US" level="2">Primary key and foreign keys</paragraph>
+<paragraph role="paragraph" id="par_id3149168" xml-lang="en-US">If you want to define a relation among the various tables, you should enter a <link href="text/shared/00/00000005.xhp#primaerschluessel" name="primary key">primary key</link> that uniquely identifies a data field of an existing table. You can refer to the primary key from other tables to access the data of this table. All data fields referring to this primary key will be identified as a foreign key.</paragraph>
 <paragraph role="paragraph" id="par_id3147085" xml-lang="en-US">All data fields referring to a primary key will be identified in the table window by a small key symbol.</paragraph>
 <paragraph role="heading" id="hd_id3153193" xml-lang="en-US" level="2">Define relations</paragraph>
 <bookmark xml-lang="en-US" branch="index" id="bm_id3155430"><bookmark_value>relations; creating and deleting (Base)</bookmark_value>
 </bookmark><comment>mw added "(Base)"</comment>
-<paragraph role="paragraph" id="par_id3155430" xml-lang="en-US">All existing relations are shown in the relations windows by a line that connects the primary and other key fields. You can add a relation by using drag-and-drop to drop the field of one table onto the field of the other table. A relation is removed again by selecting it and pressing the Delete key.</paragraph>
+<paragraph role="paragraph" id="par_id3155430" xml-lang="en-US">All existing relations are shown in the relations windows by a line that connects the primary and foreign key fields. You can add a relation by using drag-and-drop to drop the field of one table onto the field of the other table. A relation is removed again by selecting it and pressing the Delete key.</paragraph>
 <paragraph role="paragraph" id="par_id3149984" xml-lang="en-US">Alternatively, you can also click the <emph>New Relation</emph> icon in the top area of the relation field and define the relation between two tables in the <link href="text/shared/explorer/database/05020100.xhp" name="Relations"><emph>Relations</emph></link> dialog.</paragraph>
 <embed href="text/shared/00/00000450.xhp#SyRelationen"/>
-<paragraph role="warning" id="par_id3153093" xml-lang="en-US">If you use $[officename] as the front-end for a relational database, the creation and deletion of relationships is not placed in an intermediate memory by $[officename], but is forwarded directly to the external database.</paragraph>
+<paragraph role="warning" id="par_id3153093" xml-lang="en-US">If you use $[officename] as the front-end for a relational database, the creation and deletion of relationships is not placed in an intermediate memory by $[officename], but is forwarded directly to the database.</paragraph>
 <paragraph role="paragraph" id="par_id3155856" xml-lang="en-US">By double-clicking a connection line, you can assign certain properties to the relation. The <emph>Relations </emph>dialog opens.</paragraph>
 </body>
 </helpdocument>