Difference between revisions of "Documentation/BASIC Guide/Database Access Types"

From Apache OpenOffice Wiki
Jump to: navigation, search
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{Documentation/NeedsRework}}
 
 
{{Documentation/BASICGuideTOC/v2
 
{{Documentation/BASICGuideTOC/v2
 
|ShowPrevNext=block
 
|ShowPrevNext=block
Line 8: Line 7:
 
}}
 
}}
 
{{DISPLAYTITLE:Types of Database Access}}
 
{{DISPLAYTITLE:Types of Database Access}}
 
+
 
The database interface from {{OOo}} is available in the {{OOo}} Writer and {{OOo}} Calc applications, as well as in the database forms.
 
The database interface from {{OOo}} is available in the {{OOo}} Writer and {{OOo}} Calc applications, as well as in the database forms.
  
In {{OOo}} Writer, standard letters can be created with the assistance of SDBC data sources and these can then be printed out. There is also an option for moving data from the database window into text documents using the drag-and-drop function.
+
In {{OOo}} Writer, standard letters can be created with the assistance of SDBC data sources and these can then be printed out. You can also move data from the database window into text documents using the drag-and-drop function.
  
If the user moves a database table into a spreadsheet, {{OOo}} creates a table area which can be updated at the click of the mouse if the original data has been modified. Conversely, spreadsheet data can be moved to a database table and a database import performed.
+
If you move a database table into a spreadsheet, {{OOo}} creates a table area which can be updated at the click of the mouse if the original data has been modified. Conversely, spreadsheet data can be moved to a database table and a database import performed.
  
Finally, {{OOo}} provides a mechanism for forms based on databases. To do this, the user first creates a standard {{OOo}} Writer or {{OOo}} Calc form and then links the fields to a database.
+
Finally, {{OOo}} provides a mechanism for forms based on databases. To do this, you first create a standard {{OOo}} Writer or {{OOo}} Calc form and then link the fields to a database.
  
 
All the options specified here are based on the user interface from {{OOo}}. No programming knowledge is needed to use the corresponding functions.
 
All the options specified here are based on the user interface from {{OOo}}. No programming knowledge is needed to use the corresponding functions.
  
This chapter, however, provides little information about the functions specified, but instead concentrates on the programming interface from SDBC, which allows for automated database querying and therefore permits a much greater range of applications to be used.
+
This section, however, provides little information about the functions specified, but instead concentrates on the programming interface from SDBC, which allows for automated database querying and therefore permits a much greater range of applications to be used.
  
 
Basic knowledge of the way in which databases function and the SQL query language is however needed to fully understand the following sections.
 
Basic knowledge of the way in which databases function and the SQL query language is however needed to fully understand the following sections.
  
 
+
{{InterWiki Languages BasicGuide|articletitle=Documentation/BASIC Guide/Database Access Types}}
 
{{PDL1}}
 
{{PDL1}}

Revision as of 10:02, 24 October 2008


The database interface from Apache OpenOffice is available in the Apache OpenOffice Writer and Apache OpenOffice Calc applications, as well as in the database forms.

In Apache OpenOffice Writer, standard letters can be created with the assistance of SDBC data sources and these can then be printed out. You can also move data from the database window into text documents using the drag-and-drop function.

If you move a database table into a spreadsheet, Apache OpenOffice creates a table area which can be updated at the click of the mouse if the original data has been modified. Conversely, spreadsheet data can be moved to a database table and a database import performed.

Finally, Apache OpenOffice provides a mechanism for forms based on databases. To do this, you first create a standard Apache OpenOffice Writer or Apache OpenOffice Calc form and then link the fields to a database.

All the options specified here are based on the user interface from Apache OpenOffice. No programming knowledge is needed to use the corresponding functions.

This section, however, provides little information about the functions specified, but instead concentrates on the programming interface from SDBC, which allows for automated database querying and therefore permits a much greater range of applications to be used.

Basic knowledge of the way in which databases function and the SQL query language is however needed to fully understand the following sections.


Content on this page is licensed under the Public Documentation License (PDL).
Personal tools