Kexi/Handbook

← Back

Information

This is original Kexi handbook for Kexi 2.x. It is always the newest version. Based on it, a HTML version, and PDF version is auto-generated. 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.

Kexi Basics

Kexi Databases

Creating a New Database File

The Kexi Main Window

Opening an Existing Kexi Database File

Opening an Existing Database File in the Open 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

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

Designing Reports

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 Menu

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