1 files changed, 194 insertions, 0 deletions
diff --git a/helpcontent2/source/text/shared/explorer/database/main.xhp b/helpcontent2/source/text/shared/explorer/database/main.xhp
new file mode 100755
index 0000000000..9eb38c6578
--- /dev/null
+++ b/helpcontent2/source/text/shared/explorer/database/main.xhp
@@ -0,0 +1,194 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--***********************************************************************
+ *
+ *  The Contents of this file are made available subject to the terms of
+ *  either of the following licenses
+ *
+ *         - GNU Lesser General Public License Version 2.1
+ *         - Sun Industry Standards Source License Version 1.1
+ *
+ *  Sun Microsystems Inc., October, 2000
+ *
+ *  GNU Lesser General Public License Version 2.1
+ *  =============================================
+ *  Copyright 2000 by Sun Microsystems, Inc.
+ *  901 San Antonio Road, Palo Alto, CA 94303, USA
+ *
+ *  This library is free software; you can redistribute it and/or
+ *  modify it under the terms of the GNU Lesser General Public
+ *  License version 2.1, as published by the Free Software Foundation.
+ *
+ *  This library is distributed in the hope that it will be useful,
+ *  but WITHOUT ANY WARRANTY; without even the implied warranty of
+ *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
+ *  Lesser General Public License for more details.
+ *
+ *  You should have received a copy of the GNU Lesser General Public
+ *  License along with this library; if not, write to the Free Software
+ *  Foundation, Inc., 59 Temple Place, Suite 330, Boston,
+ *  MA  02111-1307  USA
+ *
+ *
+ *  Sun Industry Standards Source License Version 1.1
+ *  =================================================
+ *  The contents of this file are subject to the Sun Industry Standards
+ *  Source License Version 1.1 (the "License"); You may not use this file
+ *  except in compliance with the License. You may obtain a copy of the
+ *  License at http://www.openoffice.org/license.html.
+ *
+ *  Software provided under this License is provided on an "AS IS" basis,
+ *  WITHOUT WARRUNTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING,
+ *  WITHOUT LIMITATION, WARRUNTIES THAT THE SOFTWARE IS FREE OF DEFECTS,
+ *  MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING.
+ *  See the License for the specific provisions governing your rights and
+ *  obligations concerning the Software.
+ *
+ *  The Initial Developer of the Original Code is: Sun Microsystems, Inc..
+ *
+ *  Copyright: 2000 by Sun Microsystems, Inc.
+ *
+ *  All Rights Reserved.
+ *
+ *  Contributor(s): _______________________________________
+ *
+ *
+ ************************************************************************-->
+	
+<helpdocument version="1.0">
+<meta>
+<topic id="textsharedexplorerdatabasemainxml" indexer="include" status="FINAL">
+<title id="tit" xml-lang="en-US">%PRODUCTNAME Database</title>
+<filename>text/shared/explorer/database/main.xhp</filename>
+</topic>
+<history>
+<created date="2004-05-06T10:33:36">UFI:  main file for database module</created>
+<lastedited date="2004-08-16T11:06:42"/>
+</history>
+</meta>
+<body>
+<section id="database">
+<bookmark xml-lang="en-US" branch="index" id="bm_id8622089"><bookmark_value>databases;main page</bookmark_value>
+<bookmark_value>$[officename] Base data sources</bookmark_value>
+<bookmark_value>Base; data sources in $[officename]</bookmark_value>
+<bookmark_value>queries;databases</bookmark_value>
+<bookmark_value>tables;databases</bookmark_value>
+<bookmark_value>forms;databases</bookmark_value>
+<bookmark_value>reports;databases</bookmark_value>
+</bookmark>
+<paragraph role="heading" id="par_idN10579" xml-lang="en-US" level="1" l10n="NEW"><variable id="base"><link href="text/shared/explorer/database/main.xhp">%PRODUCTNAME Base</link>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_idN107BD" xml-lang="en-US" l10n="CHG">In %PRODUCTNAME Base, you can access data that is stored in a wide variety of database file formats. Base natively supports some flat file database formats, such as the dBase format. You can also use Base to connect to a external relative databases, such as databases from MySQL or Oracle.</paragraph>
+</section>
+<paragraph role="heading" id="par_idN107C0" xml-lang="en-US" level="2" l10n="NEW">Using a Database in %PRODUCTNAME</paragraph>
+<paragraph role="paragraph" id="par_idN107CC" xml-lang="en-US" l10n="NEW">%PRODUCTNAME Base creates a new database file the same way as a new document file.</paragraph>
+<list type="unordered">
+<listitem>
+<paragraph role="paragraph" id="par_idN10838" xml-lang="en-US" l10n="NEW">To create a new database file, choose <emph>File - New - Database</emph>.</paragraph>
+</listitem>
+</list>
+<paragraph role="paragraph" id="par_idN1083B" xml-lang="en-US" l10n="NEW">The <link href="text/shared/explorer/database/dabawiz00.xhp">Database Wizard</link> helps you to create a database file and to register a new database within %PRODUCTNAME.</paragraph>
+<paragraph role="note" id="par_idN107E7" xml-lang="en-US" l10n="NEW">The database file contains queries, reports, and forms for the database as well as a link to the database, where the records are stored. Formatting information is also stored in the database file. Apart from a few exceptions, the database file does not include database records.<comment>UFI: but the Embedded database spec tells that it is possible. Unfortunately there are two specs with inconsistent info. Must wait for the wizard</comment></paragraph>
+<list type="unordered">
+<listitem>
+<paragraph role="paragraph" id="par_idN1084A" xml-lang="en-US" l10n="NEW">To open a database file, choose <emph>File - Open</emph>, and select a file with an *.odb <comment>UFI: also saw *.ood or oob  somewhere...</comment>extension.</paragraph>
+</listitem>
+</list>
+<paragraph role="heading" id="par_idN108E9" xml-lang="en-US" level="2" l10n="NEW">Viewing a Database in %PRODUCTNAME</paragraph>
+<paragraph role="paragraph" id="par_idN108ED" xml-lang="en-US" l10n="NEW">There are two different methods of viewing a database in %PRODUCTNAME.</paragraph>
+<list type="unordered">
+<listitem>
+<paragraph role="paragraph" id="par_idN108F3" xml-lang="en-US" l10n="NEW">Choose <emph>File - Open</emph> to open the database file.</paragraph>
+<paragraph role="paragraph" id="par_idN108FA" xml-lang="en-US" l10n="NEW">The <link href="text/shared/explorer/database/dabadoc.xhp">database file</link> gives you full access to tables, queries, reports, and forms. You can edit the structure of your tables and change the contents of the data records.</paragraph>
+</listitem>
+<listitem>
+<paragraph role="paragraph" id="par_idN1090C" xml-lang="en-US" l10n="NEW">Choose <emph>View - Data source</emph> to view the registered databases.</paragraph>
+<paragraph role="paragraph" id="par_idN10913" xml-lang="en-US" l10n="NEW">The <link href="text/shared/guide/database_main.xhp">data source view</link> can be used to drag-and-drop table fields from registered databases into your documents and to create mail merge letters, labels, or business cards.</paragraph>
+</listitem>
+</list>
+<paragraph role="heading" id="par_idN107EA" xml-lang="en-US" level="2" l10n="NEW">Registering an Existing Database to %PRODUCTNAME</paragraph>
+<paragraph role="paragraph" id="par_idN107ED" xml-lang="en-US" l10n="NEW">Data from any database file can be registered to %PRODUCTNAME. To register means to tell %PRODUCTNAME where the data is located, how it is organized, how to get that data, and more. Once the database is registered, you can use the menu command <emph>View - Data source</emph> to access the data records from your text documents and spreadsheets.</paragraph>
+<paragraph role="heading" id="par_idN107F0" xml-lang="en-US" level="3" l10n="NEW">To register an existing database file:</paragraph>
+<list type="ordered">
+<listitem>
+<paragraph role="paragraph" id="par_idN107F6" xml-lang="en-US" l10n="NEW">Choose <link href="text/shared/optionen/01160200.xhp">Tools - Options - %PRODUCTNAME Database - Databases</link>.</paragraph>
+</listitem>
+<listitem>
+<paragraph role="paragraph" id="par_idN10888" xml-lang="en-US" l10n="NEW">Click <emph>Add</emph> and select the database file. </paragraph>
+</listitem>
+</list>
+<paragraph role="heading" id="par_idN1081B" xml-lang="en-US" level="2" l10n="NEW">Working with Databases in %PRODUCTNAME</paragraph>
+<paragraph role="paragraph" id="par_idN1081E" xml-lang="en-US" l10n="NEW">The following sections describe how to enter, edit, delete, print, import and export data. </paragraph>
+<paragraph role="heading" id="par_idN10A01" xml-lang="en-US" level="3" l10n="NEW">Creating a New Database</paragraph>
+<list type="ordered">
+<listitem>
+<paragraph role="paragraph" id="par_idN10A08" xml-lang="en-US" l10n="NEW">Choose <emph>File - New - Database</emph>.</paragraph>
+<paragraph role="paragraph" id="par_idN10A0F" xml-lang="en-US" l10n="NEW">This opens the <link href="text/shared/explorer/database/dabawiz00.xhp">Database Wizard</link>, where you create a new database file.</paragraph>
+</listitem>
+<listitem>
+<paragraph role="paragraph" id="par_idN10A13" xml-lang="en-US" l10n="NEW">In the Database Wizard, select the type of database, and select the option to open the Table Wizard as the next wizard.</paragraph>
+<paragraph role="paragraph" id="par_idN10A16" xml-lang="en-US" l10n="NEW">The <link href="text/shared/explorer/database/tablewizard00.xhp">Table Wizard</link> helps you to add a table to the new database file.</paragraph>
+</listitem>
+</list>
+<paragraph role="heading" id="par_idN10821" xml-lang="en-US" level="3" l10n="NEW">Working with Tables</paragraph>
+<paragraph role="paragraph" id="par_idN10824" xml-lang="en-US" l10n="NEW">Data is stored in tables. As an example, your system addressbook that you use for your e-mail addresses is a table of the addressbook database. Each address is a data record, presented as a row in that table. The data records consist of data fields, for example the first and the last name fields and the e-mail field.</paragraph>
+<paragraph role="paragraph" id="par_idN10827" xml-lang="en-US" l10n="NEW">In %PRODUCTNAME you can create a new table using the <link href="text/shared/explorer/database/tablewizard00.xhp">Table Wizard</link>:</paragraph>
+<list type="ordered">
+<listitem>
+<paragraph role="paragraph" id="par_idN10A46" xml-lang="en-US" l10n="NEW">Open the database file where you want to create the new table.</paragraph>
+</listitem>
+<listitem>
+<paragraph role="paragraph" id="par_idN10A4A" xml-lang="en-US" l10n="NEW">In the left pane of the database window, click the <emph>Tables</emph> icon.</paragraph>
+</listitem>
+<listitem>
+<paragraph role="paragraph" id="par_idN1082D" xml-lang="en-US" l10n="NEW">Click <emph>Use Wizard to Create Table</emph>.</paragraph>
+</listitem>
+</list>
+<paragraph role="heading" id="par_idN10833" xml-lang="en-US" level="3" l10n="NEW">Working with Queries</paragraph>
+<paragraph role="paragraph" id="par_idN10836" xml-lang="en-US" l10n="NEW">If you often want to access only a subset of your data which can be well defined by a filter condition, you can define a query. This is basically a name for the new view at the filtered data. You open the query and see the current data in the table layout that you once defined.</paragraph>
+<paragraph role="paragraph" id="par_idN10839" xml-lang="en-US" l10n="NEW">In %PRODUCTNAME you can create a new query using the <link href="text/shared/explorer/database/querywizard00.xhp">Query Wizard</link>:</paragraph>
+<list type="ordered">
+<listitem>
+<paragraph role="paragraph" id="par_idN10A8C" xml-lang="en-US" l10n="NEW">Open the database file where you want to create the new query.</paragraph>
+</listitem>
+<listitem>
+<paragraph role="paragraph" id="par_idN10A90" xml-lang="en-US" l10n="NEW">In the left pane of the database window, click the <emph>Queries</emph> icon.</paragraph>
+</listitem>
+<listitem>
+<paragraph role="paragraph" id="par_idN10A98" xml-lang="en-US" l10n="NEW">Click <emph>Use Wizard to Create Query</emph>.</paragraph>
+</listitem>
+</list>
+<paragraph role="heading" id="par_idN10845" xml-lang="en-US" level="3" l10n="NEW">Working with Forms</paragraph>
+<paragraph role="paragraph" id="par_idN10848" xml-lang="en-US" l10n="NEW">With forms, you can define the layout how to present the data. Open a text document or a spreadsheet and insert the controls like push buttons, list boxes, and more. In the properties dialogs of the controls, define which data they should show.</paragraph>
+<paragraph role="paragraph" id="par_idN1084B" xml-lang="en-US" l10n="NEW">In %PRODUCTNAME you can create a new form using the <link href="text/shared/autopi/01090000.xhp">Form Wizard</link>:</paragraph>
+<list type="ordered">
+<listitem>
+<paragraph role="paragraph" id="par_idN10AD2" xml-lang="en-US" l10n="NEW">Open the database file where you want to create the new form.</paragraph>
+</listitem>
+<listitem>
+<paragraph role="paragraph" id="par_idN10AD6" xml-lang="en-US" l10n="NEW">In the left pane of the database window, click the <emph>Forms</emph> icon.</paragraph>
+</listitem>
+<listitem>
+<paragraph role="paragraph" id="par_idN10ADE" xml-lang="en-US" l10n="NEW">Click <emph>Use Wizard to Create Form</emph>.</paragraph>
+</listitem>
+</list>
+<paragraph role="paragraph" id="par_idN10854" xml-lang="en-US" l10n="NEW">As forms are normal text documents or spreadsheets, you can open them with <emph>File - Open</emph>. If you are in the database window, click the Forms icon to find links to all forms for the current database.</paragraph>
+<paragraph role="heading" id="par_idN10857" xml-lang="en-US" level="3" l10n="NEW">Working with Reports</paragraph>
+<paragraph role="paragraph" id="par_idN1085A" xml-lang="en-US" l10n="NEW">A report is a text document that either shows the current data or the data at the time the report was created.</paragraph>
+<paragraph role="paragraph" id="par_idN1085D" xml-lang="en-US" l10n="NEW">In %PRODUCTNAME you can create a new report using the <link href="text/shared/autopi/01100000.xhp">Report Wizard</link>:</paragraph>
+<list type="ordered">
+<listitem>
+<paragraph role="paragraph" id="par_idN10B25" xml-lang="en-US" l10n="NEW">Open the database file where you want to create the new report.</paragraph>
+</listitem>
+<listitem>
+<paragraph role="paragraph" id="par_idN10B29" xml-lang="en-US" l10n="NEW">In the left pane of the database window, click the <emph>Reports</emph> icon.</paragraph>
+</listitem>
+<listitem>
+<paragraph role="paragraph" id="par_idN10B31" xml-lang="en-US" l10n="NEW">Click <emph>Use Wizard to Create Report</emph>.</paragraph>
+</listitem>
+</list>
+<paragraph role="paragraph" id="par_idN10866" xml-lang="en-US" l10n="NEW">As reports are normal text documents or text document templates, you can open them with <emph>File - Open</emph>. If you are in the database window, click the Reports icon to find links to all reports for the current database.</paragraph>
+<section id="relatedtopics">
+<paragraph role="paragraph" id="par_idN1059C" xml-lang="en-US" l10n="NEW"><link href="text/shared/guide/database_main.xhp">Data Source View</link></paragraph>
+</section>
+</body>
+</helpdocument>