Kexi/Handbook: Difference between revisions

From KDE UserBase Wiki
m (DTanis email change)
(Marked this version for translation)
Line 1: Line 1:
<languages />
<languages />
<translate>
<translate>
<!--T:1-->
[[Special:MyLanguage/Kexi|&larr; Back]]
[[Special:MyLanguage/Kexi|&larr; Back]]


<!--T:2-->
{{Info|This handbook for Kexi 2.x is meant to be based on the Kexi Handbook [http://docs.kde.org/stable/en/koffice/kexi/index.html for Kexi 1.1].<br/>The works are currently assigned to Dimitrios T Tanis, email: dimitrios.tanis at kdemail.net , so please do not start anything but minor corrections without coordinating with maintainer, Jarosław Staniek, email: kexi at kde.org!<br/>Please use rules from [http://edu.kde.org/development/document.php Documentation Tutorial].}}
{{Info|This handbook for Kexi 2.x is meant to be based on the Kexi Handbook [http://docs.kde.org/stable/en/koffice/kexi/index.html for Kexi 1.1].<br/>The works are currently assigned to Dimitrios T Tanis, email: dimitrios.tanis at kdemail.net , so please do not start anything but minor corrections without coordinating with maintainer, Jarosław Staniek, email: kexi 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]]==
==[[Special:MyLanguage/Kexi/Handbook/Introduction|Introduction]]== <!--T:3-->


==[[Special:MyLanguage/Kexi/Handbook/Kexi Basics|Kexi Basics]]==
==[[Special:MyLanguage/Kexi/Handbook/Kexi Basics|Kexi Basics]]== <!--T:4-->


<!--T:5-->
:[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/Kexi Databases|Kexi Databases]]
:[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/Kexi Databases|Kexi Databases]]
:[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/Creating a New Database File|Creating a New Database File]]
:[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/Creating a New Database File|Creating a New Database File]]
Line 19: Line 22:
:[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/Using built-in help|Using built-in help]]
:[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/Using built-in help|Using built-in help]]


==[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases|Building Simple Databases]]==
==[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases|Building Simple Databases]]== <!--T:6-->


<!--T:7-->
:[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases|Introduction]]
:[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases|Introduction]]
:[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Tables|Designing Database Tables]]
:[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Tables|Designing Database Tables]]
Line 40: Line 44:
:[[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/Configuring Kexi|Configuring Kexi]]==
==[[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]]-->
<!-- 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/Configuring Kexi/Docking and undocking side panels|Docking and undocking side panels]]


==[[Special:MyLanguage/Kexi/Handbook/Command Reference|Command Reference]]==
==[[Special:MyLanguage/Kexi/Handbook/Command Reference|Command Reference]]== <!--T:10-->


<!--T:11-->
:[[Special:MyLanguage/Kexi/Handbook/Command Reference/The Kexi Tab|The Kexi Tab]]
:[[Special:MyLanguage/Kexi/Handbook/Command Reference/The Kexi Tab|The Kexi Tab]]
:[[Special:MyLanguage/Kexi/Handbook/Command Reference/The Project Tab|The Project Tab]]
:[[Special:MyLanguage/Kexi/Handbook/Command Reference/The Project Tab|The Project Tab]]
Line 58: Line 64:
<!-- NOT PRESENT    The Help Menu -->
<!-- NOT PRESENT    The Help Menu -->


==[[Special:MyLanguage/Kexi/Handbook/Credits and License|Credits and License]]==
==[[Special:MyLanguage/Kexi/Handbook/Credits and License|Credits and License]]== <!--T:12-->


==[[Special:MyLanguage/Kexi/Handbook/Appendix A. Introduction to Databases|Appendix A. Introduction to Databases]]==
==[[Special:MyLanguage/Kexi/Handbook/Appendix A. Introduction to Databases|Appendix A. Introduction to Databases]]== <!--T:13-->


<!--T:14-->
:[[Special:MyLanguage/Kexi/Handbook/Introduction to Databases/What Is a Database?|What Is a Database?]]
:[[Special:MyLanguage/Kexi/Handbook/Introduction to Databases/What Is a Database?|What Is a Database?]]
:[[Special:MyLanguage/Kexi/Handbook/Introduction to Databases/Database and Spreadsheet|Database and Spreadsheet]]
:[[Special:MyLanguage/Kexi/Handbook/Introduction to Databases/Database and Spreadsheet|Database and Spreadsheet]]
Line 68: Line 75:
:[[Special:MyLanguage/Kexi/Handbook/Introduction to Databases/Database Creation Software|Database Creation Software]]
:[[Special:MyLanguage/Kexi/Handbook/Introduction to Databases/Database Creation Software|Database Creation Software]]


==[[Special:MyLanguage/Kexi/Handbook/Appendix B. Comparing Kexi to other database applications|Appendix B. Comparing Kexi to other database applications]]==
==[[Special:MyLanguage/Kexi/Handbook/Appendix B. Comparing Kexi to other database applications|Appendix B. Comparing Kexi to other database applications]]== <!--T:15-->


<!--T:16-->
:[[Special:MyLanguage/Kexi/Handbook/Comparing Kexi to other database applications/Data types|Data types]]
:[[Special:MyLanguage/Kexi/Handbook/Comparing Kexi to other database applications/Data types|Data types]]


==[[Special:MyLanguage/Kexi/Handbook/Appendix C. Reserved words for SQL|Appendix C. Reserved words for SQL]]==
==[[Special:MyLanguage/Kexi/Handbook/Appendix C. Reserved words for SQL|Appendix C. Reserved words for SQL]]== <!--T:17-->


<!--T:18-->
----
----


==Tools==
==Tools== <!--T:19-->


<!--T:20-->
*[[Kexi/Handbook/_Template|Page Template]]
*[[Kexi/Handbook/_Template|Page Template]]


<!--T:21-->
[[Category:Kexi]]
[[Category:Kexi]]
[[Category:Tutorials]]
[[Category:Tutorials]]
[[Category:Office]]
[[Category:Office]]
</translate>
</translate>

Revision as of 10:02, 13 December 2011

← Back

Information

This handbook for Kexi 2.x is meant to be based on the Kexi Handbook for Kexi 1.1.
The works are currently assigned to Dimitrios T Tanis, email: dimitrios.tanis at kdemail.net , so please do not start anything but minor corrections without coordinating with maintainer, Jarosław Staniek, email: kexi at kde.org!
Please use rules from Documentation Tutorial.


Introduction

Kexi Basics

Kexi Databases
Creating a New Database File
The Kexi Main Window
Main application elements
Opening an existing Kexi database file
Opening a database file in the Open Existing Project dialog
Opening an existing Kexi database file by clicking on .kexi file's icon
Using built-in help

Building Simple Databases

Introduction
Designing Database Tables
The Table Designer window
Entering Data Into Tables
Designing Database Queries
Designing Forms
Most important terms
Forms versus tables
Working with form design
Using the Widgets tab
Inserting widgets - text fields
Assigning data sources
Inserting text labels
Actions
Widget layouts
Setting widgets size and position by hand
Setting the tab order
Entering Data Using Forms

Configuring Kexi

Docking and undocking side panels

Command Reference

The Kexi Tab
The Project Tab
The Create Tab
The Data Tab
The External Data Tab
The Tools Tab
The Form Design Tab
The Report Design Tab

Credits and License

Appendix A. Introduction to Databases

What Is a Database?
Database and Spreadsheet
Database Design
Who Needs a Database?
Database Creation Software

Appendix B. Comparing Kexi to other database applications

Data types

Appendix C. Reserved words for SQL


Tools