Kexi/Handbook

← Back

Information

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. There is also old Kexi 1.x Handbook. Other calligra handbooks are available at [1].
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.

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

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

---

Tools

• Page Template