Difference between revisions of "Kexi/Handbook"
(Added "where to go next" section) |
m (synchronise wording of links and headings) |
||
(28 intermediate revisions by 4 users not shown) | |||
Line 5: | Line 5: | ||
<!--T:2--> | <!--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__ | ||
Line 20: | Line 21: | ||
<!--T:23--> | <!--T:23--> | ||
:[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/The Kexi Main Window|The Kexi Main Window]]</translate> | :[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/The Kexi Main Window|The Kexi Main Window]]</translate> | ||
− | <translate> | + | <!-- <translate> |
<!--T:24--> | <!--T:24--> | ||
− | ::[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/The Kexi Main Window/Main application elements|Main | + | ::[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/The Kexi Main Window/Main application elements|Main Application Elements]]</translate> --> |
<translate> | <translate> | ||
<!--T:25--> | <!--T:25--> | ||
− | :[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/Opening an existing Kexi database file|Opening an | + | :[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/Opening an existing Kexi database file|Opening an Existing Kexi Database File]]</translate> |
<translate> | <translate> | ||
<!--T:26--> | <!--T:26--> | ||
− | ::[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/Opening an existing Kexi database file/Opening | + | ::[[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> | <translate> | ||
<!--T:27--> | <!--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 | + | ::[[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> | <translate> | ||
<!--T:28--> | <!--T:28--> | ||
− | :[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/Using built-in help|Using | + | :[[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--> | ==[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases|Building Simple Databases]]== <!--T:6--> | ||
Line 57: | Line 58: | ||
<translate> | <translate> | ||
<!--T:34--> | <!--T:34--> | ||
− | ::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/ | + | ::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Important terms|Important terms]]</translate> |
<translate> | <translate> | ||
<!--T:35--> | <!--T:35--> | ||
Line 91: | Line 92: | ||
<!--T:45--> | <!--T:45--> | ||
:[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Entering Data Using Forms|Entering Data Using Forms]] | :[[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--> | ==[[Special:MyLanguage/Kexi/Handbook/Configuring Kexi|Configuring Kexi]]== <!--T:8--> | ||
Line 98: | Line 100: | ||
:[[Special:MyLanguage/Kexi/Handbook/Configuring Kexi/Docking and undocking side panels|Docking and undocking side panels]] | :[[Special:MyLanguage/Kexi/Handbook/Configuring Kexi/Docking and undocking side panels|Docking and undocking side panels]] | ||
− | ==[[Special:MyLanguage/Kexi/Handbook/ | + | ==[[Special:MyLanguage/Kexi/Handbook/Where to go next|Where to Go Next?]]== <!--T:57--> |
+ | |||
+ | ==[[Special:MyLanguage/Kexi/Handbook/Glossary|Appendix A. Glossary]]== <!--T:60--> | ||
+ | |||
+ | ==[[Special:MyLanguage/Kexi/Handbook/Introduction to Databases|Appendix B. Introduction to Databases]]== <!--T:13--> | ||
+ | |||
+ | <!--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--> | <!--T:11--> | ||
− | :[[Special:MyLanguage/Kexi/Handbook/ | + | :[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands|Menu Commands]] |
− | + | ::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The Kexi Tab|The Kexi Tab]]</translate> | |
− | |||
− | :[[Special:MyLanguage/Kexi/Handbook/ | ||
<translate> | <translate> | ||
<!--T:47--> | <!--T:47--> | ||
− | :[[Special:MyLanguage/Kexi/Handbook/ | + | ::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The Create Tab|The Create Tab]]</translate> |
<translate> | <translate> | ||
<!--T:48--> | <!--T:48--> | ||
− | :[[Special:MyLanguage/Kexi/Handbook/ | + | ::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The Data Tab|The Data Tab]]</translate> |
<translate> | <translate> | ||
<!--T:49--> | <!--T:49--> | ||
− | :[[Special:MyLanguage/Kexi/Handbook/ | + | ::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The External Data Tab|The External Data Tab]]</translate> |
<translate> | <translate> | ||
<!--T:50--> | <!--T:50--> | ||
− | :[[Special:MyLanguage/Kexi/Handbook/ | + | ::[[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> | <translate> | ||
<!--T:51--> | <!--T:51--> | ||
− | :[[Special:MyLanguage/Kexi/Handbook/ | + | ::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The Form Design Tab|The Form Design Tab]]</translate> |
<translate> | <translate> | ||
<!--T:52--> | <!--T:52--> | ||
− | :[[Special:MyLanguage/Kexi/Handbook/ | + | ::[[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--> | |
− | <!--T: | + | <!-- Query Design related references --> |
− | :[[Special:MyLanguage/Kexi/Handbook/ | + | :[[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> | <translate> | ||
− | <!--T: | + | <!--T:77--> |
− | :[[Special:MyLanguage/Kexi/Handbook/ | + | <!-- Use 'kexi --help' --> |
+ | :[[Special:MyLanguage/Kexi/Handbook/References/Supported File Formats|Supported File Formats]]</translate> | ||
<translate> | <translate> | ||
− | <!--T: | + | <!--T:78--> |
− | :[[Special:MyLanguage/Kexi/Handbook/ | + | ::[[Special:MyLanguage/Kexi/Handbook/References/Supported File Formats/Microsoft Access File Formats|Microsoft Access File Formats]]</translate> |
<translate> | <translate> | ||
− | <!--T: | + | <!--T:79--> |
− | :[[Special:MyLanguage/Kexi/Handbook/ | + | ::[[Special:MyLanguage/Kexi/Handbook/References/Supported File Formats/Comma-separated Values Format|Comma-separated Values Format (CSV)]]</translate> |
<translate> | <translate> | ||
− | <!--T: | + | <!--T:80--> |
− | :[[Special:MyLanguage/Kexi/Handbook/ | + | :[[Special:MyLanguage/Kexi/Handbook/References/Kexi Specifications|Kexi Specifications]] |
− | ==[[Special:MyLanguage/Kexi/Handbook/ | + | ==[[Special:MyLanguage/Kexi/Handbook/Kexi and Other Database Applications|Appendix D. Kexi and Other Database Applications]]== <!--T:15--> |
<!--T:16--> | <!--T:16--> | ||
− | :[[Special:MyLanguage/Kexi/Handbook/ | + | :[[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/ | + | ==[[Special:MyLanguage/Kexi/Handbook/Bibliography|Bibliography]]== <!--T:65--> |
− | <!--T: | + | ==[[Special:MyLanguage/Kexi/Handbook/Index|Index]]== <!--T:66--> |
− | ---- | + | |
+ | ==[[Special:MyLanguage/Kexi/Handbook/Credits and License|Credits and License]]== <!--T:12--> | ||
==Tools== <!--T:19--> | ==Tools== <!--T:19--> |
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
Appendix D. Kexi and Other Database Applications
Technical Support
Contributing to the Kexi Project
Bibliography
Index
Credits and License
Tools
This page was last edited on 15 May 2015, at 19:28. Content is available under Creative Commons License SA 4.0 unless otherwise noted.