Kexi/Handbook

← Back

Under Construction

This is a new page, currently under construction!

Information

This handbook for Kexi 2.x is meant to be based on the Kexi Handbook for Kexi 1.1.
Please coordinate any effort with Jarosław Staniek, email: kexi at kde.org

Warning

Links of this handbook are broken because this wiki lacks subpage feature for the Main namespace. There's a plan to fix it. For example "/Kexi Basics/Kexi Databases" should be the same as "Kexi/Handbook/Kexi Basics/Kexi Databases"

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 Windows

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

How Is a Database Different From a 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

The following lists contain words that are used internaly by Kexi when dealing with data sources. When designing your database you should do your best to avoid using these reserved words because otherwise you might end up having problems with your database file or even corrupt it.

Kexi SQL Reserved words

This list contains keywords that are resevered for use in Kexi SQL:

• AFTER
• ALL
• ASC
• BEFORE
• BEGIN
• BETWEEN
• BY
• CASCADE
• CASE
• CHECK
• COLLATE
• COMMIT
• CONSTRAINT
• CROSS
• DATABASE
• DEFAULT
• DELETE
• DESC
• DISTINCT
• DROP
• END
• ELSE
• EXPLAIN
• FOR
• FOREIGN
• FULL
• GROUP
• HAVING
• IGNORE
• INDEX
• INNER
• INSERT
• INTO
• KEY
• LIMIT
• MATCH
• NATURAL
• OFFSET
• ORDER
• OUTER
• PRIMARY
• REFERENCES
• REPLACE
• RESTRICT
• ROLLBACK
• ROW
• SET
• TEMPORARY
• THEN
• TRANSACTION
• UNION
• UNIQUE
• UPDATE
• USING
• VALUES
• WHEN

Kexi SQLite Driver Reserved words

This list contains keywords that are resevered for use by Kexi SQLite Driver:

• ABORT
• ATTACH
• CLUSTER
• CONFLICT
• DEFERRED
• DEFERRABLE
• DETACH
• EACH
• EXCEPT
• FAIL
• GLOB
• IMMEDIATE
• INITIALLY
• INSTEAD
• INTERSECT
• ISNULL
• NOTNULL
• OF
• PRAGMA
• RAISE
• STATEMENT
• TEMP
• TRIGGER
• VACUUM
• VIEW

---

Tools

• Page Template