Kexi/Handbook

    From KDE UserBase Wiki

    ← 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.
    The works are currently assigned to Dimitrios T Tanis, email: jtanis at tanisfood.gr, so please do not start anything but minor corrections without coordinating with maintainer, Jarosław Staniek, email: kexi at kde.org!
    Please use rules from Documentation Tutorial.


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

    Credits and License

    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

    Appendix C. Reserved words for SQL


    Tools