1 <?xml version=
"1.0" encoding=
"UTF-8"?>
5 ***********************************************************************
7 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
9 * Copyright 2008 by Sun Microsystems, Inc.
11 * OpenOffice.org - a multi-platform office productivity suite
13 * $RCSfile: database_main.xhp,v $
16 * This file is part of OpenOffice.org.
18 * OpenOffice.org is free software: you can redistribute it and/or modify
19 * it under the terms of the GNU Lesser General Public License version 3
20 * only, as published by the Free Software Foundation.
22 * OpenOffice.org is distributed in the hope that it will be useful,
23 * but WITHOUT ANY WARRANTY; without even the implied warranty of
24 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
25 * GNU Lesser General Public License version 3 for more details
26 * (a copy is included in the LICENSE file that accompanied this code).
28 * You should have received a copy of the GNU Lesser General Public License
29 * version 3 along with OpenOffice.org. If not, see
30 * <http://www.openoffice.org/license.html>
31 * for a copy of the LGPLv3 License.
33 ************************************************************************
36 <helpdocument version=
"1.0">
38 <topic id=
"textsharedguidedatabase_mainxml" indexer=
"include" status=
"PUBLISH">
39 <title id=
"tit" xml-lang=
"en-US">Database Overview
</title>
40 <filename>/text/shared/guide/database_main.xhp
</filename>
43 <created date=
"2003-10-31T00:00:00">Sun Microsystems, Inc.
</created>
44 <lastedited date=
"2006-06-14T15:08:46">FPE: Deleted screenshot.
</lastedited>
48 <bookmark xml-lang=
"en-US" branch=
"index" id=
"bm_id3153031"><bookmark_value>databases; overview
</bookmark_value>
49 <bookmark_value>data source view; overview
</bookmark_value>
50 <bookmark_value>data source explorer
</bookmark_value>
51 <bookmark_value>explorer of data sources
</bookmark_value>
53 <paragraph role=
"paragraph" id=
"par_id3153031" xml-lang=
"en-US" l10n=
"E" oldref=
"1" localize=
"false"/>
54 <paragraph role=
"heading" id=
"hd_id3148474" xml-lang=
"en-US" level=
"1" l10n=
"CHG" oldref=
"2"><variable id=
"database_main"><link href=
"text/shared/guide/database_main.xhp" name=
"Data Source Overview">Database Overview
</link>
55 </variable><comment>remove this file when all links are resolved
</comment></paragraph>
56 <paragraph role=
"paragraph" id=
"par_idN105F1" xml-lang=
"en-US" l10n=
"NEW"><link href=
"text/shared/explorer/database/main.xhp">Working with databases in %PRODUCTNAME
</link></paragraph>
57 <paragraph role=
"heading" id=
"hd_id3153821" xml-lang=
"en-US" level=
"2" l10n=
"U" oldref=
"3">Data Source View
</paragraph>
58 <paragraph role=
"paragraph" id=
"par_id3149415" xml-lang=
"en-US" l10n=
"CHG" oldref=
"4">Choose
<emph>View - Data Sources
</emph> or press F4 to call the data source view from a text document or spreadsheet.
</paragraph>
59 <paragraph role=
"paragraph" id=
"par_id3147531" xml-lang=
"en-US" l10n=
"U" oldref=
"5">On the left you can see the
<link href=
"text/shared/02/12000000.xhp" name=
"Data source explorer">Data source explorer
</link>. If you select a table or query there, you see the contents of this table or query on the right. At the top margin is the
<link href=
"text/shared/main0212.xhp" name=
"Database bar">Table Data bar
</link>.
</paragraph>
60 <paragraph role=
"heading" id=
"hd_id3149047" xml-lang=
"en-US" level=
"2" l10n=
"U" oldref=
"6">Data Sources
</paragraph>
61 <paragraph role=
"paragraph" id=
"par_id3145069" xml-lang=
"en-US" l10n=
"CHG" oldref=
"7"><link href=
"text/shared/guide/data_addressbook.xhp" name=
"address book as data source">Address book as data source
</link></paragraph>
62 <paragraph role=
"paragraph" id=
"par_id3150398" xml-lang=
"en-US" l10n=
"U" oldref=
"9"><link href=
"text/shared/01/04180100.xhp" name=
"View data source contents">View data source contents
</link></paragraph>
63 <paragraph role=
"paragraph" id=
"par_idN106A4" xml-lang=
"en-US" l10n=
"NEW"><link href=
"text/shared/explorer/database/menubar.xhp">Menu bar of a database file
</link></paragraph>
64 <paragraph role=
"heading" id=
"hd_id3154123" xml-lang=
"en-US" level=
"2" l10n=
"CHG" oldref=
"16">Forms and Reports
</paragraph>
65 <paragraph role=
"paragraph" id=
"par_id3154909" xml-lang=
"en-US" l10n=
"CHG" oldref=
"17"><link href=
"text/shared/explorer/database/04030000.xhp" name=
"Create new form document">Create new form document
</link>,
<link href=
"text/shared/02/01170000.xhp" name=
"edit form functions">edit form controls
</link>,
<link href=
"text/shared/autopi/01090000.xhp">Form Wizard
</link></paragraph>
66 <paragraph role=
"paragraph" id=
"par_id3152920" xml-lang=
"en-US" l10n=
"CHG" oldref=
"18"><link href=
"text/shared/02/01170500.xhp" name=
"entering data versus editing form">Entering data versus editing form
</link></paragraph>
67 <paragraph role=
"paragraph" id=
"par_id3151380" xml-lang=
"en-US" l10n=
"U" oldref=
"23"><link href=
"text/shared/autopi/01100000.xhp" name=
"Report AutoPilot">Report Wizard
</link></paragraph>
68 <embed href=
"text/shared/guide/data_report.xhp#data_report"/>
69 <paragraph role=
"heading" id=
"hd_id3145606" xml-lang=
"en-US" level=
"2" l10n=
"U" oldref=
"13">Queries
</paragraph>
70 <paragraph role=
"paragraph" id=
"par_id3125864" xml-lang=
"en-US" l10n=
"U" oldref=
"14"><link href=
"text/shared/explorer/database/02000000.xhp" name=
"Create new query or table view, edit query structure">Create new query or table view, edit query structure
</link></paragraph>
71 <paragraph role=
"paragraph" id=
"par_idN1072A" xml-lang=
"en-US" l10n=
"NEW"><link href=
"text/shared/explorer/database/querywizard00.xhp">Query Wizard
</link></paragraph>
72 <paragraph role=
"paragraph" id=
"par_id3155430" xml-lang=
"en-US" l10n=
"U" oldref=
"15"><link href=
"text/shared/01/05340400.xhp" name=
"Enter, edit and copy records">Enter, edit and copy records
</link></paragraph>
73 <paragraph role=
"heading" id=
"hd_id3147287" xml-lang=
"en-US" level=
"2" l10n=
"U" oldref=
"10">Tables
</paragraph>
74 <paragraph role=
"paragraph" id=
"par_id3163713" xml-lang=
"en-US" l10n=
"U" oldref=
"11"><link href=
"text/shared/explorer/database/05010000.xhp" name=
"Create new table, edit table structure">Create new table, edit table structure
</link>,
<link href=
"text/shared/explorer/database/05010100.xhp" name=
"index">index
</link>,
<link href=
"text/shared/explorer/database/05020000.xhp" name=
"relations">relations
</link></paragraph>
75 <paragraph role=
"paragraph" id=
"par_idN1078F" xml-lang=
"en-US" l10n=
"NEW"><link href=
"text/shared/explorer/database/tablewizard00.xhp">Table Wizard
</link></paragraph>
76 <paragraph role=
"paragraph" id=
"par_id3159196" xml-lang=
"en-US" l10n=
"U" oldref=
"12"><link href=
"text/shared/01/05340400.xhp" name=
"Enter, edit and copy records">Enter, edit and copy records
</link></paragraph>