1 <?xml version=
"1.0" encoding=
"UTF-8"?>
6 ***********************************************************************
8 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
10 * Copyright 2008 by Sun Microsystems, Inc.
12 * OpenOffice.org - a multi-platform office productivity suite
14 * $RCSfile: main.xhp,v $
17 * This file is part of OpenOffice.org.
19 * OpenOffice.org is free software: you can redistribute it and/or modify
20 * it under the terms of the GNU Lesser General Public License version 3
21 * only, as published by the Free Software Foundation.
23 * OpenOffice.org is distributed in the hope that it will be useful,
24 * but WITHOUT ANY WARRANTY; without even the implied warranty of
25 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
26 * GNU Lesser General Public License version 3 for more details
27 * (a copy is included in the LICENSE file that accompanied this code).
29 * You should have received a copy of the GNU Lesser General Public License
30 * version 3 along with OpenOffice.org. If not, see
31 * <http://www.openoffice.org/license.html>
32 * for a copy of the LGPLv3 License.
34 ************************************************************************
38 <helpdocument version=
"1.0">
40 <topic id=
"textsharedexplorerdatabasemainxml" indexer=
"include" status=
"PUBLISH">
41 <title id=
"tit" xml-lang=
"en-US">%PRODUCTNAME Database
</title>
42 <filename>/text/shared/explorer/database/main.xhp
</filename>
46 <section id=
"database">
47 <bookmark xml-lang=
"en-US" branch=
"index" id=
"bm_id8622089"><bookmark_value>databases;main page (Base)
</bookmark_value>
48 <bookmark_value>$[officename] Base data sources
</bookmark_value>
49 <bookmark_value>data sources;$[officename] Base
</bookmark_value>
50 </bookmark><comment>mw changed
"Base,..."</comment><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">Using Databases in %PRODUCTNAME Base
</link>
51 </variable></paragraph>
52 <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. %PRODUCTNAME Base natively supports some flat file database formats, such as the dBASE format. You can also use %PRODUCTNAME Base to connect to external relational databases, such as databases from MySQL or Oracle.
</paragraph>
54 <paragraph role=
"paragraph" id=
"par_id5864131" xml-lang=
"en-US" l10n=
"NEW">The following database types are read-only types in %PRODUCTNAME Base. From within %PRODUCTNAME Base it is not possible to change the database structure or to edit, insert, and delete database records for these database types:
</paragraph>
55 <list type=
"unordered">
57 <paragraph role=
"paragraph" id=
"par_id8865016" xml-lang=
"en-US" l10n=
"NEW">Spreadsheet files
</paragraph>
60 <paragraph role=
"paragraph" id=
"par_id3786736" xml-lang=
"en-US" l10n=
"NEW">Text files
</paragraph>
63 <paragraph role=
"paragraph" id=
"par_id6747337" xml-lang=
"en-US" l10n=
"NEW">Address book data
</paragraph>
66 <paragraph role=
"heading" id=
"par_idN107C0" xml-lang=
"en-US" level=
"2" l10n=
"NEW">Using a Database in %PRODUCTNAME
</paragraph>
67 <list type=
"unordered">
69 <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>
72 <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>
73 <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.
</paragraph>
74 <list type=
"unordered">
76 <paragraph role=
"paragraph" id=
"par_idN1084A" xml-lang=
"en-US" l10n=
"CHG">To open a database file, choose
<emph>File - Open
</emph>. In the
<emph>File type
</emph> list box, select to view only
"Database documents". Select a database document and click
<emph>Open
</emph>.
</paragraph>
79 <section id=
"relatedtopics">
80 <paragraph role=
"paragraph" id=
"par_idN1075F" xml-lang=
"en-US" l10n=
"NEW">
81 <embedvar href=
"text/shared/guide/data_view.xhp#data_view"/>
83 <paragraph role=
"paragraph" id=
"par_idN10767" xml-lang=
"en-US" l10n=
"NEW">
84 <embedvar href=
"text/shared/guide/data_register.xhp#data_register"/>
86 <paragraph role=
"paragraph" id=
"par_idN1076F" xml-lang=
"en-US" l10n=
"NEW">
87 <embedvar href=
"text/shared/guide/data_new.xhp#data_new"/>
89 <paragraph role=
"paragraph" id=
"par_idN10777" xml-lang=
"en-US" l10n=
"NEW">
90 <embedvar href=
"text/shared/guide/data_tables.xhp#data_tables"/>
92 <paragraph role=
"paragraph" id=
"par_idN1077F" xml-lang=
"en-US" l10n=
"NEW">
93 <embedvar href=
"text/shared/guide/data_queries.xhp#data_queries"/>
95 <paragraph role=
"paragraph" id=
"par_idN10787" xml-lang=
"en-US" l10n=
"NEW">
96 <embedvar href=
"text/shared/guide/data_forms.xhp#data_forms"/>
98 <paragraph role=
"paragraph" id=
"par_idN1078F" xml-lang=
"en-US" l10n=
"NEW">
99 <embedvar href=
"text/shared/guide/data_reports.xhp#data_reports"/>
101 <paragraph role=
"paragraph" id=
"par_id1311990" xml-lang=
"en-US" l10n=
"NEW">
102 <embedvar href=
"text/shared/guide/data_im_export.xhp#data_im_export"/>
104 <paragraph role=
"paragraph" id=
"par_idN10797" xml-lang=
"en-US" l10n=
"NEW">
105 <embedvar href=
"text/shared/guide/database_main.xhp#database_main"/>
107 <paragraph role=
"paragraph" id=
"par_idN107AD" xml-lang=
"en-US" l10n=
"NEW">
108 <embedvar href=
"text/shared/explorer/database/menubar.xhp#titletext"/>
110 <paragraph role=
"paragraph" id=
"par_idN107BB" xml-lang=
"en-US" l10n=
"NEW">
111 <embedvar href=
"text/shared/explorer/database/toolbars.xhp#toolbars"/>
113 <embed href=
"text/shared/04/01020000.xhp#DB_keys"/>
114 <paragraph role=
"paragraph" id=
"par_id6474806" xml-lang=
"en-US" l10n=
"NEW"><link href=
"http://wiki.services.openoffice.org/wiki/Database">Wiki page about Base
</link></paragraph>