Jump to: navigation, search
Other languages:Danish 100% • ‎English 100% • ‎Ukrainian 100%

← Back

This is original Kexi handbook for Kexi 2.x. It is always most up-to-date version. Based on it, HTML version, and PDF version is auto-generated. Translation to other languages may be available (select your language and click on calligra link at 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 Please do not start anything but minor corrections without coordinating with maintainer, Jarosław Staniek, email: staniek at
Please use rules from Documentation Tutorial.


Kexi Basics

Kexi Databases
Creating a New Database File
The Kexi Main Window
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

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
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

Where to go next

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

Appendix D. Supported File Formats


This page was last modified on 4 November 2012, at 19:54. This page has been accessed 24,780 times. Content is available under Creative Commons License SA 3.0 and the GNU Free Documentation License 1.2.
KDE® and the K Desktop Environment® logo are registered trademarks of KDE e.V.Legal