Kexi/Handbook

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"

/Introduction/

/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 External Data Tab

The Tools Tab

The Form Design Tab

The Report Design Tab

/Credits and License/

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