Kexi/Handbook: Difference between revisions

From KDE Wiki Sandbox
No edit summary
No edit summary
Line 8: Line 8:


==[[/Kexi Basics/]]==
==[[/Kexi Basics/]]==
    Kexi Databases
:[[/Kexi Basics/Kexi Databases|Kexi Databases]]
    Creating a New Database File
:[[/Kexi Basics/Creating a New Database File|Creating a New Database File]]
    The Kexi Main Window
:[[/Kexi Basics/The Kexi Main Window|The Kexi Main Window]]
::[[/Kexi Basics/The Kexi Main Window/Main application elements|Main application elements]]
:[[/Kexi Basics/Opening an existing Kexi database file|Opening an existing Kexi database file]]
::[[/Kexi Basics/Opening an existing Kexi database file/Opening a database file in the Open Existing Project dialog|Opening a database file in the Open Existing Project dialog]]
::[[/Kexi Basics/Opening an existing Kexi database file/Opening an existing Kexi database file by clicking on .kexi file's icon|Opening an existing Kexi database file by clicking on .kexi file's icon]]
:[[/Kexi Basics/Using built-in help|Using built-in help]]


        Main application elements
==Building Simple Databases==
:[[/Building Simple Databases|Introduction]]
:[[/Building Simple Databases/Designing Database Tables|Designing Database Tables]]
::[[/Building Simple Databases/Designing Database Tables/The Table Designer window|The Table Designer window]]
:[[/Building Simple Databases/Entering Data Into Tables|Entering Data Into Tables]]
:[[/Building Simple Databases/Designing Database Queries|Designing Database Queries]]
:[[/Building Simple Databases/Designing Forms|Designing Forms]]
::[[/Building Simple Databases/Designing Forms/Most important terms|Most important terms]]
::[[/Building Simple Databases/Designing Forms/Forms versus tables|Forms versus tables]]
::[[/Building Simple Databases/Designing Forms/Working with form design|Working with form design]]
::[[/Building Simple Databases/Designing Forms/Using the Widgets tab|Using the Widgets tab]]
::[[/Building Simple Databases/Designing Forms/Inserting widgets - text fields|Inserting widgets - text fields]]
::[[/Building Simple Databases/Designing Forms/Assigning data sources|Assigning data sources]]
::[[/Building Simple Databases/Designing Forms/Inserting text labels|Inserting text labels]]
::[[/Building Simple Databases/Designing Forms/Actions|Actions]]
::[[/Building Simple Databases/Designing Forms/Widget layouts|Widget layouts]]
::[[/Building Simple Databases/Designing Forms/Setting widgets size and position by hand|Setting widgets size and position by hand]]
::[[/Building Simple Databases/Designing Forms/Setting the tab order|Setting the tab order]]
:[[/Building Simple Databases/Entering Data Using Forms|Entering Data Using Forms]]


    Opening an existing Kexi database file
==Configuring Kexi==
:[[/Configuring Kexi/Docking and Undocking Windows|Docking and Undocking Windows]]
:[[/Configuring Kexi/Docking and undocking side panels|Docking and undocking side panels]]
<!-- UNIMPLEMENTED: Docking and undocking child windows -->


        Opening a database file in the Open Existing Project dialog
==Command Reference==
        Opening an existing Kexi database file by clicking on .kexi file's icon
:[[/Command Reference/The Kexi Tab|The Kexi Tab]]
:[[/Command Reference/The Project Tab|The Project Tab]]
:[[/Command Reference/The Create Tab|The Create Tab]]
:[[/Command Reference/The Data Tab|The Data Tab]]
:[[/Command Reference/The External Data Tab|The External Data Tab]]
:[[/Command Reference/The Tools Tab|The Tools Tab]]
:[[/Command Reference/The Form Design Tab|The Form Design Tab]]
:[[/Command Reference/The Report Design Tab|The Report Design Tab]]
<!-- NOT PRESENT    The Settings Menu -->
<!-- NOT PRESENT    The Help Menu -->


    Using built-in help
==[[/Credits and License/]]==


3. Building Simple Databases
==Appendix A. Introduction to Databases==
:[[/Introduction to Databases/What Is a Database?|What Is a Database?]]
:[[/Introduction to Databases/Database and Spreadsheet|Database and Spreadsheet]]
::[[/Introduction to Databases/Database and Spreadsheet|How Is a Database Different From a Spreadsheet?|How Is a Database Different From a Spreadsheet?]]
:[[/Introduction to Databases/Database Design|Database Design]]
:[[/Introduction to Databases/Who Needs a Database?|Who Needs a Database?]]
:[[/Introduction to Databases/Database Creation Software|Database Creation Software]]


    Introduction
==[[/Appendix B. Comparing Kexi to other database applications/]]==
    Designing Database Tables
:[[/Comparing Kexi to other database applications/Data types|Data types]]
 
        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
 
4. Configuring Kexi
 
    Window Layout
 
        IDEAl mode
        Childframe mode
 
    Docking and Undocking Windows
 
        Docking and undocking side panels
        Docking and undocking child windows
 
5. Command Reference
 
    The File Menu
    The Edit Menu
    The View Menu
    The Insert Menu
    The Format Menu
    The Data Menu
    The Tools Menu
    The Window Menu
    The Settings Menu
    The Help Menu
 
6. Credits and License
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
 
B. Comparing Kexi to other database applications
 
    Data types  


----
==Tools==
==Tools==
*[[Kexi/Handbook/_Template|Page Template]]
*[[Kexi/Handbook/_Template|Page Template]]

Revision as of 19:55, 11 July 2010

← Back

Under Construction
This is a new page, currently under construction!
Information
This handbook for Kexi 2.2 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


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

Tools