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

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

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

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 Tab

The Create Tab

The Data Tab

The External Data Tab

The Tools Tab

The Help Menu

The Form Design Tab

The Report Design Tab

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

Contributing to the Kexi Project

Reporting Bugs or Wishes

Tools

• Page Template