1<?xml version="1.0" encoding="UTF-8"?> 2 3 4<!-- 5 *********************************************************************** 6 * 7 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. 8 * 9 * Copyright 2000, 2010 Oracle and/or its affiliates. 10 * 11 * OpenOffice.org - a multi-platform office productivity suite 12 * 13 * This file is part of OpenOffice.org. 14 * 15 * OpenOffice.org is free software: you can redistribute it and/or modify 16 * it under the terms of the GNU Lesser General Public License version 3 17 * only, as published by the Free Software Foundation. 18 * 19 * OpenOffice.org is distributed in the hope that it will be useful, 20 * but WITHOUT ANY WARRANTY; without even the implied warranty of 21 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 22 * GNU Lesser General Public License version 3 for more details 23 * (a copy is included in the LICENSE file that accompanied this code). 24 * 25 * You should have received a copy of the GNU Lesser General Public License 26 * version 3 along with OpenOffice.org. If not, see 27 * <http://www.openoffice.org/license.html> 28 * for a copy of the LGPLv3 License. 29 * 30 ************************************************************************ 31 --> 32 33<helpdocument version="1.0"> 34<meta> 35<topic id="textsharedguidedatabase_mainxml" indexer="include" status="PUBLISH"> 36<title id="tit" xml-lang="en-US">Database Overview</title> 37<filename>/text/shared/guide/database_main.xhp</filename> 38</topic> 39<history> 40<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> 41<lastedited date="2006-06-14T15:08:46">FPE: Deleted screenshot.</lastedited> 42</history> 43</meta> 44<body> 45<bookmark xml-lang="en-US" branch="index" id="bm_id3153031"><bookmark_value>databases; overview</bookmark_value> 46<bookmark_value>data source view; overview</bookmark_value> 47<bookmark_value>data source explorer</bookmark_value> 48<bookmark_value>explorer of data sources</bookmark_value> 49</bookmark> 50<paragraph role="paragraph" id="par_id3153031" xml-lang="en-US" l10n="E" oldref="1" localize="false"/> 51<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> 52</variable><comment>remove this file when all links are resolved</comment></paragraph> 53<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> 54<paragraph role="heading" id="hd_id3153821" xml-lang="en-US" level="2" l10n="U" oldref="3">Data Source View</paragraph> 55<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> 56<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> 57<paragraph role="heading" id="hd_id3149047" xml-lang="en-US" level="2" l10n="U" oldref="6">Data Sources</paragraph> 58<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> 59<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> 60<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> 61<paragraph role="heading" id="hd_id3154123" xml-lang="en-US" level="2" l10n="CHG" oldref="16">Forms and Reports</paragraph> 62<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> 63<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> 64<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> 65<embed href="text/shared/guide/data_report.xhp#data_report"/> 66<paragraph role="heading" id="hd_id3145606" xml-lang="en-US" level="2" l10n="U" oldref="13">Queries</paragraph> 67<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> 68<paragraph role="paragraph" id="par_idN1072A" xml-lang="en-US" l10n="NEW"><link href="text/shared/explorer/database/querywizard00.xhp">Query Wizard</link></paragraph> 69<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> 70<paragraph role="heading" id="hd_id3147287" xml-lang="en-US" level="2" l10n="U" oldref="10">Tables</paragraph> 71<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> 72<paragraph role="paragraph" id="par_idN1078F" xml-lang="en-US" l10n="NEW"><link href="text/shared/explorer/database/tablewizard00.xhp">Table Wizard</link></paragraph> 73<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> 74</body> 75</helpdocument> 76