Jump to content

Kexi/Handbook: Difference between revisions

From KDE UserBase Wiki
← Older edit
Yurchor (talk | contribs)
Bureaucrats, Administrators, translate-proofr, translator, trusted
63,436 edits
m fix tags
Claus chr (talk | contribs)
Bureaucrats, Administrators, translate-proofr, translator
75,541 edits
Marked this version for translation
 
(54 intermediate revisions by 5 users not shown)
Line 5: Line 5:


<!--T:2-->
<!--T:2-->
{{Info|This handbook for Kexi 2.x is 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 is a handbook for KEXI 3.3, work in progress based on version 2.4. It is always the newest version.''' Based on it, a [https://docs.kde.org/trunk5/en/kexi/kexi/index.html HTML version], and [https://docs.kde.org/stable5/en/kexi/kexi/kexi.pdf PDF version] is generated (note: outdated for now). Translation to other languages may be available (select your language on the left hand at [https://docs.kde.org/index.php?application&#x3d;kexi]).<br/>
Please do not make any major change without coordinating with the maintainer, Jarosław Staniek, email: staniek @ kde.org.<br />Please follow rules from the [https://l10n.kde.org/docs/doc-primer/ Documentation Guide].}}
__NOTOC__
__NOTOC__


Line 13: Line 14:


<!--T:5-->
<!--T:5-->
:[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/Kexi Databases|Kexi Databases]]
:[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/Kexi Databases|Kexi Databases]]</translate>
:[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/Creating a New Database File|Creating a New Database File]]
<translate>
:[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/The Kexi Main Window|The Kexi Main Window]]
<!--T:22-->
::[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/The Kexi Main Window/Main application elements|Main application elements]]
:[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/Creating a New Database File|Creating a New Database File]]</translate>
:[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/Opening an existing Kexi database file|Opening an existing Kexi database file]]
<translate>
::[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/Opening an existing Kexi database file/Opening a database file in the Open Existing Project dialog|Opening a database file in the Open Existing Project dialog]]
<!--T:23-->
::[[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]]
:[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/The Kexi Main Window|The Kexi Main Window]]</translate>
:[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/Using built-in help|Using built-in help]]
<!-- <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 Project|Opening an Existing KEXI Project]]</translate>
<translate>
<!--T:81-->
::[[Special:MyLanguage/Kexi/Handbook/Kexi_Basics/Opening an Existing KEXI Project/Opening Recent Project from Welcome Screen|Opening Recent Project from Welcome Screen]]</translate>
<translate>
<!--T:26-->
::[[Special:MyLanguage/Kexi/Handbook/Kexi_Basics/Opening an Existing KEXI Project/Selecting a Project from the Open Project Screen|Selecting a Project from the Open Project Screen]]</translate>
<translate>
<!--T:27-->
::[[Special:MyLanguage/Kexi/Handbook/Kexi_Basics/Opening an Existing KEXI Project/Opening an Existing KEXI Project by Clicking on a .kexi File|Opening an Existing KEXI Project by Clicking on a .kexi File]]</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-->
==[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases|Building Simple Databases]]== <!--T:6-->


<!--T:7-->
<!--T:7-->
:[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases|Introduction]]
:[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases|Introduction]]</translate>
:[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Tables|Designing Database Tables]]
<translate>
::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Tables/The Table Designer window|The Table Designer window]]
<!--T:29-->
:[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Entering Data Into Tables|Entering Data Into Tables]]
:[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Tables|Designing Database Tables]]</translate>
:[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Queries|Designing Database Queries]]
<translate>
:[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms|Designing Forms]]
<!--T:30-->
::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Most important terms|Most important terms]]
::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Tables/The Table Designer window|The Table Designer window]]</translate>
::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Forms versus tables|Forms versus tables]]
<translate>
::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Working with form design|Working with form design]]
<!--T:31-->
::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Using the Widgets tab|Using the Widgets tab]]
:[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Entering Data Into Tables|Entering Data Into Tables]]</translate>
::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Inserting widgets - text fields|Inserting widgets - text fields]]
<translate>
::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Assigning data sources|Assigning data sources]]
<!--T:32-->
::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Inserting text labels|Inserting text labels]]
:[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Queries|Designing Database Queries]]</translate>
::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Actions|Actions]]
<translate>
::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Widget layouts|Widget layouts]]
<!--T:33-->
::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Setting widgets size and position by hand|Setting widgets size and position by hand]]
:[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms|Designing Forms]]</translate>
::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Setting the tab order|Setting the tab order]]
<translate>
<!--T:34-->
::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Most important terms|Most 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-->
<!-- FIXME not implemented in KEXI since 2.4
::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Widget layouts|Widget layouts]]--></translate>
<translate>
<!--T:43-->
<!-- FIXME not implemented in KEXI since 2.4
::[[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-->
<!-- FIXME not implemented in KEXI since 2.4
::[[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/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-->


<!--T:9-->
<!--T:82-->
<!-- 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]]
<!-- UNIMPLEMENTED::[[Special:MyLanguage/Kexi/Handbook/Configuring Kexi/Docking and undocking side panels|Docking and undocking side panels]]-->


==[[Special:MyLanguage/Kexi/Handbook/Command Reference|Command Reference]]== <!--T:10-->
==[[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/Command Reference/The Kexi Tab|The Kexi Tab]]
:[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands|Menu Commands]]
:[[Special:MyLanguage/Kexi/Handbook/Command Reference/The Project Tab|The Project Tab]]
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The KEXI Menu|The KEXI Menu]]</translate>
:[[Special:MyLanguage/Kexi/Handbook/Command Reference/The Create Tab|The Create Tab]]
<translate>
:[[Special:MyLanguage/Kexi/Handbook/Command Reference/The Data Tab|The Data Tab]]
<!--T:83-->
:[[Special:MyLanguage/Kexi/Handbook/Command Reference/The External Data Tab|The External Data Tab]]
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The File Menu|The File Menu]]</translate>
:[[Special:MyLanguage/Kexi/Handbook/Command Reference/The Tools Tab|The Tools Tab]]
<translate>
:[[Special:MyLanguage/Kexi/Handbook/Command Reference/The Form Design Tab|The Form Design Tab]]
<!--T:84-->
:[[Special:MyLanguage/Kexi/Handbook/Command Reference/The Report Design Tab|The Report Design Tab]]
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The Edit Menu|The Edit Menu]]</translate>
<!-- NOT PRESENT    The Settings Menu -->
<translate>
<!-- NOT PRESENT    The Help Menu -->
<!--T:85-->
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The Data Menu|The Data Menu]]</translate>
<translate>
<!--T:86-->
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The Tools Menu|The Tools Menu]]</translate>
<translate>
<!--T:87-->
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The Settings Menu|The Settings Menu]]</translate>
<translate>
<!--T:88-->
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The Window Menu|The Window Menu]]</translate>
<translate>
<!--T:89-->
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The Help Menu|The Help Menu]]</translate>
<translate>
<!--T:90-->
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/Context Menus in the Project Navigator|Context Menus in the Project Navigator]]</translate>
<translate>
<!--T:91-->
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/Context Menu in the Object Tab|Context Menu in the Object Tab]]</translate>
<translate>
<!--T:92-->
:[[Special:MyLanguage/Kexi/Handbook/References/Toolbar Commands|Toolbar Commands]]</translate>
<translate>
 
<!--T:93-->
::[[Special:MyLanguage/Kexi/Handbook/References/Toolbar Commands/The Create Toolbar|The Create Toolbar]]</translate>
<translate>


==[[Special:MyLanguage/Kexi/Handbook/Credits and License|Credits and License]]== <!--T:12-->
<!--T:94-->
::[[Special:MyLanguage/Kexi/Handbook/References/Toolbar Commands/The Form Design Toolbar|The Form Design Toolbar]]</translate>
<translate>


==[[Special:MyLanguage/Kexi/Handbook/Appendix A. Introduction to Databases|Appendix A. Introduction to Databases]]== <!--T:13-->
<!--T:95-->
::[[Special:MyLanguage/Kexi/Handbook/References/Toolbar Commands/The Report Design Toolbar|The Report Design Toolbar]]</translate>


<!--T:14-->
<translate>
:[[Special:MyLanguage/Kexi/Handbook/Introduction to Databases/What Is a Database?|What Is a Database?]]
<!--T:67-->
:[[Special:MyLanguage/Kexi/Handbook/Introduction to Databases/Database and Spreadsheet|Database and Spreadsheet]]
:[[Special:MyLanguage/Kexi/Handbook/References/Keyboard Shortcuts|Keyboard Shortcuts]]</translate>
:[[Special:MyLanguage/Kexi/Handbook/Introduction to Databases/Database Design|Database Design]]
<translate>
:[[Special:MyLanguage/Kexi/Handbook/Introduction to Databases/Who Needs a Database?|Who Needs a Database?]]
<!--T:68-->
:[[Special:MyLanguage/Kexi/Handbook/Introduction to Databases/Database Creation Software|Database Creation Software]]
<!-- 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/Appendix B. Comparing Kexi to other database applications|Appendix B. Comparing Kexi to other database applications]]== <!--T:15-->
==[[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/Comparing Kexi to other database applications/Data types|Data types]]
:[[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/Appendix C. Reserved words for SQL|Appendix C. Reserved words for SQL]]== <!--T:17-->
==[[Special:MyLanguage/Kexi/Handbook/Contributing to the Kexi Project|Contributing to the Kexi Project]]== <!--T:63-->  


<!--T:18-->
<!--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-->
==Tools== <!--T:19-->

Latest revision as of 16:13, 26 December 2024

Other languages:

← Back

Information

This is a handbook for KEXI 3.3, work in progress based on version 2.4. It is always the newest version. Based on it, a HTML version, and PDF version is generated (note: outdated for now). Translation to other languages may be available (select your language on the left hand at [1]).
Please do not make any major change without coordinating with the maintainer, Jarosław Staniek, email: staniek @ kde.org.
Please follow rules from the Documentation Guide.


Introduction

Kexi Basics

Kexi Databases
Creating a New Database File
The Kexi Main Window
Opening an Existing KEXI Project
Opening Recent Project from Welcome Screen
Selecting a Project from the Open Project Screen
Opening an Existing KEXI Project by Clicking on a .kexi File
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
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
The KEXI Menu
The File Menu
The Edit Menu
The Data Menu
The Tools Menu
The Settings Menu
The Window Menu
The Help Menu
Context Menus in the Project Navigator
Context Menu in the Object Tab
Toolbar Commands
The Create Toolbar
The Form Design Toolbar
The Report Design Toolbar
Keyboard Shortcuts
Data Types
SQL Reference
SQL Reserved Words
Form Widgets
Report Elements
Command-Line Options
Supported File Formats
Microsoft Access File Formats
Comma-separated Values Format (CSV)
Kexi Specifications

Appendix D. Kexi and Other Database Applications

Data Types

Technical Support

Contributing to the Kexi Project

Reporting Bugs or Wishes

Bibliography

Index

Credits and License

Tools

Retrieved from "https://userbase.kde.org/index.php?title=Kexi/Handbook&oldid=497817"