Kexi/Handbook: Difference between revisions
< Kexi
m (synchronise wording of links and headings) |
|||
(40 intermediate revisions by 6 users not shown) | |||
Line 1: | Line 1: | ||
[[Kexi|← Back]] | <languages /> | ||
<translate> | |||
<!--T:1--> | |||
[[Special:MyLanguage/Kexi|← Back]] | |||
<!--T:2--> | |||
{{Info|This handbook for Kexi 2.x is | {{Info|'''This is original Kexi handbook for Kexi 2.x. It is always most up-to-date version.''' Based on it, [http://docs.kde.org/development/en/calligra/kexi/index.html on docs.kde.org HTML version], and [http://docs.kde.org/stable/en/calligra/kexi/kexi.pdf PDF version] is auto-generated. Translation to other languages may be available (select your language and click on ''calligra'' link at http://docs.kde.org). You can find handbooks for other calligra apps there too.<br/> | ||
The works on this handbook are currently assigned to Dimitrios T Tanis, email: dimitrios.tanis at kdemail.net. Please do not start anything but minor corrections without coordinating with maintainer, Jarosław Staniek, email: staniek at kde.org.<br />Please use rules from [http://edu.kde.org/development/document.php Documentation Tutorial].}} | |||
__NOTOC__ | __NOTOC__ | ||
==[[Special:MyLanguage/Kexi/Handbook/Introduction|Introduction]]== <!--T:3--> | |||
==[[ | ==[[Special:MyLanguage/Kexi/Handbook/Kexi Basics|Kexi Basics]]== <!--T:4--> | ||
: | |||
: | |||
<!--T:5--> | |||
:[[/ | :[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/Kexi Databases|Kexi Databases]]</translate> | ||
:[[/ | <translate> | ||
::[[/ | <!--T:22--> | ||
:[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/Creating a New Database File|Creating a New Database File]]</translate> | |||
<translate> | |||
: | <!--T:23--> | ||
::[[/ | :[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/The Kexi Main Window|The Kexi Main Window]]</translate> | ||
<!-- <translate> | |||
::[[/ | <!--T:24--> | ||
::[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/The Kexi Main Window/Main application elements|Main Application Elements]]</translate> --> | |||
: | <translate> | ||
::[[/ | <!--T:25--> | ||
:[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/Opening an existing Kexi database file|Opening an Existing Kexi Database File]]</translate> | |||
: | <translate> | ||
::[[/ | <!--T:26--> | ||
::[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/Opening an existing Kexi database file/Opening an existing database file in the Open Project dialog|Opening an Existing Database File in the Open Project Dialog]]</translate> | |||
::[[/ | <translate> | ||
<!--T:27--> | |||
::[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/Opening an existing Kexi database file/Opening an existing Kexi database file by clicking on .kexi file's icon|Opening an Existing Kexi Database File by Clicking on .kexi File's Icon]]</translate> | |||
<translate> | |||
<!--T:28--> | |||
:[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/Using built-in help|Using Built-In Help]] | |||
== | ==[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases|Building Simple Databases]]== <!--T:6--> | ||
<!-- | |||
<!--T:7--> | |||
:[[/ | :[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases|Introduction]]</translate> | ||
:[[/ | <translate> | ||
:[[/ | <!--T:29--> | ||
:[[/ | :[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Tables|Designing Database Tables]]</translate> | ||
:[[/ | <translate> | ||
:[[/ | <!--T:30--> | ||
:[[/ | ::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Tables/The Table Designer window|The Table Designer window]]</translate> | ||
:[[/ | <translate> | ||
<!-- | <!--T:31--> | ||
<!-- | :[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Entering Data Into Tables|Entering Data Into Tables]]</translate> | ||
<translate> | |||
<!--T:32--> | |||
:[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Queries|Designing Database Queries]]</translate> | |||
<translate> | |||
<!--T:33--> | |||
:[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms|Designing Forms]]</translate> | |||
<translate> | |||
<!--T:34--> | |||
::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Important terms|Important terms]]</translate> | |||
<translate> | |||
<!--T:35--> | |||
::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Forms versus tables|Forms versus tables]]</translate> | |||
<translate> | |||
<!--T:36--> | |||
::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Working with form design|Working with form design]]</translate> | |||
<translate> | |||
<!--T:37--> | |||
::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Using the Widgets tab|Using the Widgets tab]]</translate> | |||
<translate> | |||
<!--T:38--> | |||
::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Inserting widgets - text fields|Inserting widgets - text fields]]</translate> | |||
<translate> | |||
<!--T:39--> | |||
::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Assigning data sources|Assigning data sources]]</translate> | |||
<translate> | |||
<!--T:40--> | |||
::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Inserting text labels|Inserting text labels]]</translate> | |||
<translate> | |||
<!--T:41--> | |||
::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Actions|Actions]]</translate> | |||
<translate> | |||
<!--T:42--> | |||
::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Widget layouts|Widget layouts]]</translate> | |||
<translate> | |||
<!--T:43--> | |||
::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Setting widgets size and position by hand|Setting widgets size and position by hand]]</translate> | |||
<translate> | |||
<!--T:44--> | |||
::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Setting the tab order|Setting the tab order]]</translate> | |||
<translate> | |||
<!--T:45--> | |||
:[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Entering Data Using Forms|Entering Data Using Forms]] | |||
:[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Reports|Designing Reports]] | |||
==[[/ | ==[[Special:MyLanguage/Kexi/Handbook/Configuring Kexi|Configuring Kexi]]== <!--T:8--> | ||
<!--T:9--> | |||
:[[/ | <!-- UNIMPLEMENTED: :[[Special:MyLanguage/Kexi/Handbook/Configuring Kexi/Docking and Undocking Windows|Docking and Undocking Windows]]--> | ||
:[[Special:MyLanguage/Kexi/Handbook/Configuring Kexi/Docking and undocking side panels|Docking and undocking side panels]] | |||
:[[ | |||
: | |||
== | ==[[Special:MyLanguage/Kexi/Handbook/Where to go next|Where to Go Next?]]== <!--T:57--> | ||
==[[/Appendix | ==[[Special:MyLanguage/Kexi/Handbook/Glossary|Appendix A. Glossary]]== <!--T:60--> | ||
---- | ==[[Special:MyLanguage/Kexi/Handbook/Introduction to Databases|Appendix B. Introduction to Databases]]== <!--T:13--> | ||
==Tools== | <!--T:14--> | ||
:[[Special:MyLanguage/Kexi/Handbook/Introduction to Databases/What Is a Database?|What Is a Database?]]</translate> | |||
<translate> | |||
<!--T:53--> | |||
:[[Special:MyLanguage/Kexi/Handbook/Introduction to Databases/Database and Spreadsheet|Database and Spreadsheet]]</translate> | |||
<translate> | |||
<!--T:54--> | |||
:[[Special:MyLanguage/Kexi/Handbook/Introduction to Databases/Database Design|Database Design]]</translate> | |||
<translate> | |||
<!--T:55--> | |||
:[[Special:MyLanguage/Kexi/Handbook/Introduction to Databases/Who Needs a Database?|Who Needs a Database?]]</translate> | |||
<translate> | |||
<!--T:56--> | |||
:[[Special:MyLanguage/Kexi/Handbook/Introduction to Databases/Database Creation Software|Database Creation Software]] | |||
</translate> | |||
<translate> | |||
==[[Special:MyLanguage/Kexi/Handbook/References|Appendix C. References]]== <!--T:61--> | |||
<!--T:11--> | |||
:[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands|Menu Commands]] | |||
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The Kexi Tab|The Kexi Tab]]</translate> | |||
<translate> | |||
<!--T:47--> | |||
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The Create Tab|The Create Tab]]</translate> | |||
<translate> | |||
<!--T:48--> | |||
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The Data Tab|The Data Tab]]</translate> | |||
<translate> | |||
<!--T:49--> | |||
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The External Data Tab|The External Data Tab]]</translate> | |||
<translate> | |||
<!--T:50--> | |||
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The Tools Tab|The Tools Tab]]</translate> | |||
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The Help Menu|The Help Menu]] | |||
<translate> | |||
<!--T:51--> | |||
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The Form Design Tab|The Form Design Tab]]</translate> | |||
<translate> | |||
<!--T:52--> | |||
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The Report Design Tab|The Report Design Tab]]</translate> | |||
<translate> | |||
<!--T:67--> | |||
:[[Special:MyLanguage/Kexi/Handbook/References/Keyboard Shortcuts|Keyboard Shortcuts]]</translate> | |||
<translate> | |||
<!--T:68--> | |||
<!-- Table Design related references --> | |||
:[[Special:MyLanguage/Kexi/Handbook/References/Data Types|Data Types]]</translate> | |||
<translate> | |||
<!--T:69--> | |||
<!-- Query Design related references --> | |||
:[[Special:MyLanguage/Kexi/Handbook/References/SQL Reference|SQL Reference]]</translate> | |||
<translate> | |||
<!--T:70--> | |||
::[[Special:MyLanguage/Kexi/Handbook/References/SQL Reference/SQL Reserved Words|SQL Reserved Words]]</translate> | |||
<translate> | |||
<!--T:71--> | |||
<!-- Form Design related references --> | |||
:[[Special:MyLanguage/Kexi/Handbook/References/Form Widgets|Form Widgets]]</translate> | |||
<translate> | |||
<!--T:72--> | |||
<!-- Report Design related references --> | |||
:[[Special:MyLanguage/Kexi/Handbook/References/Report Elements|Report Elements]]</translate> | |||
<translate> | |||
<!--T:73--> | |||
<!-- Macro Design related references --> | |||
<!-- UNIMPLEMENTED: :[[Special:MyLanguage/Kexi/Handbook/References/Macro Commands|Macro Commands]] --></translate> | |||
<translate> | |||
<!--T:74--> | |||
<!-- Script Design related references --> | |||
<!-- UNIMPLEMENTED: :[[Special:MyLanguage/Kexi/Handbook/References/Scripting Object Model|Scripting Object Model]] --></translate> | |||
<translate> | |||
<!--T:75--> | |||
<!-- UNIMPLEMENTED: :[[Special:MyLanguage/Kexi/Handbook/References/Plugins|Plugins]] --> | |||
<!-- UNIMPLEMENTED: :[[Special:MyLanguage/Kexi/Handbook/References/Configuration Options|Configuration Options]] --></translate> | |||
<translate> | |||
<!--T:76--> | |||
:[[Special:MyLanguage/Kexi/Handbook/References/Command-Line Options|Command-Line Options]] </translate> | |||
<translate> | |||
<!--T:77--> | |||
<!-- Use 'kexi --help' --> | |||
:[[Special:MyLanguage/Kexi/Handbook/References/Supported File Formats|Supported File Formats]]</translate> | |||
<translate> | |||
<!--T:78--> | |||
::[[Special:MyLanguage/Kexi/Handbook/References/Supported File Formats/Microsoft Access File Formats|Microsoft Access File Formats]]</translate> | |||
<translate> | |||
<!--T:79--> | |||
::[[Special:MyLanguage/Kexi/Handbook/References/Supported File Formats/Comma-separated Values Format|Comma-separated Values Format (CSV)]]</translate> | |||
<translate> | |||
<!--T:80--> | |||
:[[Special:MyLanguage/Kexi/Handbook/References/Kexi Specifications|Kexi Specifications]] | |||
==[[Special:MyLanguage/Kexi/Handbook/Kexi and Other Database Applications|Appendix D. Kexi and Other Database Applications]]== <!--T:15--> | |||
<!--T:16--> | |||
:[[Special:MyLanguage/Kexi/Handbook/Kexi and Other Database Applications/Data Types|Data Types]] | |||
==[[Special:MyLanguage/Kexi/Handbook/Technical Support|Technical Support]]== <!--T:62--> | |||
==[[Special:MyLanguage/Kexi/Handbook/Contributing to the Kexi Project|Contributing to the Kexi Project]]== <!--T:63--> | |||
<!--T:64--> | |||
:[[Special:MyLanguage/Kexi/Handbook/Reporting Bugs or Wishes|Reporting Bugs or Wishes]] | |||
==[[Special:MyLanguage/Kexi/Handbook/Bibliography|Bibliography]]== <!--T:65--> | |||
==[[Special:MyLanguage/Kexi/Handbook/Index|Index]]== <!--T:66--> | |||
==[[Special:MyLanguage/Kexi/Handbook/Credits and License|Credits and License]]== <!--T:12--> | |||
==Tools== <!--T:19--> | |||
<!--T:20--> | |||
*[[Kexi/Handbook/_Template|Page Template]] | *[[Kexi/Handbook/_Template|Page Template]] | ||
<!--T:21--> | |||
[[Category:Kexi]] | |||
[[Category:Tutorials]] | |||
[[Category:Office]] | |||
</translate> |
Latest revision as of 19:28, 15 May 2015
Information
This is original Kexi handbook for Kexi 2.x. It is always most up-to-date version. Based on it, on docs.kde.org HTML version, and PDF version is auto-generated. Translation to other languages may be available (select your language and click on calligra link at http://docs.kde.org). You can find handbooks for other calligra apps there too.
The works on this handbook are currently assigned to Dimitrios T Tanis, email: dimitrios.tanis at kdemail.net. Please do not start anything but minor corrections without coordinating with maintainer, Jarosław Staniek, email: staniek at kde.org.
Please use rules from Documentation Tutorial.
The works on this handbook are currently assigned to Dimitrios T Tanis, email: dimitrios.tanis at kdemail.net. Please do not start anything but minor corrections without coordinating with maintainer, Jarosław Staniek, email: staniek at kde.org.
Please use rules from Documentation Tutorial.
Introduction
Kexi Basics
- Kexi Databases
- Creating a New Database File
- The Kexi Main Window
- Opening an Existing Kexi Database File
- Using Built-In Help
Building Simple Databases
- Introduction
- Designing Database Tables
- Entering Data Into Tables
- Designing Database Queries
- Designing Forms
- Entering Data Using Forms
- Designing Reports
Configuring Kexi
Where to Go Next?
Appendix A. Glossary
Appendix B. Introduction to Databases
- What Is a Database?
- Database and Spreadsheet
- Database Design
- Who Needs a Database?
- Database Creation Software
Appendix C. References
- Menu Commands
- Keyboard Shortcuts
- Data Types
- SQL Reference
- Form Widgets
- Report Elements
- Command-Line Options
- Supported File Formats
- Kexi Specifications