1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
|
<?xml version="1.0" encoding="UTF-8"?>
<!--
* This file is part of the LibreOffice project.
*
* This Source Code Form is subject to the terms of the Mozilla Public
* License, v. 2.0. If a copy of the MPL was not distributed with this
* file, You can obtain one at http://mozilla.org/MPL/2.0/.
*
* This file incorporates work covered by the following license notice:
*
* Licensed to the Apache Software Foundation (ASF) under one or more
* contributor license agreements. See the NOTICE file distributed
* with this work for additional information regarding copyright
* ownership. The ASF licenses this file to you under the Apache
* License, Version 2.0 (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.apache.org/licenses/LICENSE-2.0 .
-->
<helpdocument version="1.0">
<meta>
<topic id="textsharedguidedatabase_mainxml" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">Database Overview</title>
<filename>/text/shared/guide/database_main.xhp</filename>
</topic>
<history>
<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
</history>
</meta>
<body>
<bookmark xml-lang="en-US" branch="index" id="bm_id3153031"><bookmark_value>databases; overview</bookmark_value>
<bookmark_value>data source view; overview</bookmark_value>
<bookmark_value>data source explorer</bookmark_value>
<bookmark_value>explorer of data sources</bookmark_value>
</bookmark>
<paragraph role="paragraph" id="par_id3153031" xml-lang="en-US" localize="false"/>
<h1 id="hd_id3148474"><variable id="database_main"><link href="text/shared/guide/database_main.xhp" name="Data Source Overview">Database Overview</link>
</variable><comment>remove this file when all links are resolved</comment></h1>
<paragraph role="paragraph" id="par_idN105F1" xml-lang="en-US"><link href="text/sdatabase/main.xhp">Working with databases in %PRODUCTNAME</link></paragraph>
<h2 id="hd_id3153821">Data Source View</h2>
<paragraph role="paragraph" id="par_id3149415" xml-lang="en-US">Choose <emph>View - Data Sources</emph> or press <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> + Shift + F4 keys to call the data source view from a text document or spreadsheet.</paragraph>
<paragraph role="paragraph" id="par_id3147531" xml-lang="en-US">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>
<h2 id="hd_id3149047">Data Sources</h2>
<paragraph role="paragraph" id="par_id3145069" xml-lang="en-US"><link href="text/shared/guide/data_addressbook.xhp" name="address book as data source">Address book as data source</link></paragraph>
<paragraph role="paragraph" id="par_id3150398" xml-lang="en-US"><link href="text/shared/01/04180100.xhp" name="View data source contents">View data source contents</link></paragraph>
<paragraph role="paragraph" id="par_idN106A4" xml-lang="en-US"><link href="text/sdatabase/menubar.xhp">Menu bar of a database file</link></paragraph>
<h2 id="hd_id3154123">Forms and Reports</h2>
<paragraph role="paragraph" id="par_id3154909" xml-lang="en-US"><link href="text/sdatabase/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>
<paragraph role="paragraph" id="par_id3152920" xml-lang="en-US"><link href="text/shared/02/01170500.xhp" name="entering data versus editing form">Entering data versus editing form</link></paragraph>
<paragraph role="paragraph" id="par_id3151380" xml-lang="en-US"><link href="text/shared/autopi/01100000.xhp" name="Report AutoPilot">Report Wizard</link></paragraph>
<embed href="text/shared/guide/data_report.xhp#data_report"/>
<h2 id="hd_id3145606">Queries</h2>
<paragraph role="paragraph" id="par_id3125864" xml-lang="en-US"><link href="text/sdatabase/02000000.xhp" name="Create new query or table view, edit query structure">Create new query or table view, edit query structure</link></paragraph>
<paragraph role="paragraph" id="par_idN1072A" xml-lang="en-US"><link href="text/sdatabase/querywizard00.xhp">Query Wizard</link></paragraph>
<paragraph role="paragraph" id="par_id3155430" xml-lang="en-US"><link href="text/shared/01/05340400.xhp" name="Enter, edit and copy records">Enter, edit and copy records</link></paragraph>
<h2 id="hd_id3147287">Tables</h2>
<paragraph role="paragraph" id="par_id3163713" xml-lang="en-US"><link href="text/sdatabase/05010000.xhp" name="Create new table, edit table structure">Create new table, edit table structure</link>, <link href="text/sdatabase/05010100.xhp" name="index">index</link>, <link href="text/sdatabase/05020000.xhp" name="relations">relations</link></paragraph>
<paragraph role="paragraph" id="par_idN1078F" xml-lang="en-US"><link href="text/sdatabase/tablewizard00.xhp">Table Wizard</link></paragraph>
<paragraph role="paragraph" id="par_id3159196" xml-lang="en-US"><link href="text/shared/01/05340400.xhp" name="Enter, edit and copy records">Enter, edit and copy records</link></paragraph>
</body>
</helpdocument>
|
