Kexi/Handbook/Building Simple Databases: Difference between revisions

    From KDE UserBase Wiki
    m (add prevnext)
    m (small textual edits to make easier reading)
     
    (7 intermediate revisions by 4 users not shown)
    Line 1: Line 1:
    <languages/>
    <languages/>
    <translate>
    <translate>
    ==Building Simple Databases==
    ==Building Simple Databases== <!--T:1-->


    <!--T:2-->
    *[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases|Introduction]]
    *[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases|Introduction]]
    *[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Tables|Designing Database Tables]]
     
    **[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Tables/The Table Designer window|The Table Designer window]]
    <!--T:10-->
    *[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Tables|Designing Database Tables]]</translate>
    <translate>
    <!--T:11-->
    **[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Tables/The Table Designer window|The Table Designer window]]</translate>
    <translate>
    <!--T:12-->
    *[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Entering Data Into Tables|Entering Data Into Tables]]
    *[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Entering Data Into Tables|Entering Data Into Tables]]
    <!--T:13-->
    *[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Queries|Designing Database Queries]]
    *[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Queries|Designing Database Queries]]
    *[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms|Designing Forms]]
     
    **[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Most important terms|Most important terms]]
    <!--T:14-->
    **[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Forms versus tables|Forms versus tables]]
    *[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms|Designing Forms]]</translate>
    **[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Working with form design|Working with form design]]
    <translate>
    **[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Using the Widgets tab|Using the Widgets tab]]
    <!--T:15-->
    **[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Inserting widgets - text fields|Inserting widgets - text fields]]
    **[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Most important terms|Most important terms]]</translate>
    **[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Assigning data sources|Assigning data sources]]
    <translate>
    **[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Inserting text labels|Inserting text labels]]
    <!--T:16-->
    **[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Actions|Actions]]
    **[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Forms versus tables|Forms versus tables]]</translate>
    **[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Widget layouts|Widget layouts]]
    <translate>
    **[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Setting widgets size and position by hand|Setting widgets size and position by hand]]
    <!--T:17-->
    **[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Working with form design|Working with form design]]</translate>
    <translate>
    <!--T:18-->
    **[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Using the Widgets tab|Using the Widgets tab]]</translate>
    <translate>
    <!--T:19-->
    **[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Inserting widgets - text fields|Inserting widgets - text fields]]</translate>
    <translate>
    <!--T:20-->
    **[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Assigning data sources|Assigning data sources]]</translate>
    <translate>
    <!--T:21-->
    **[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Inserting text labels|Inserting text labels]]</translate>
    <translate>
    <!--T:22-->
    **[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Actions|Actions]]</translate>
    <translate>
    <!--T:23-->
    **[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Widget layouts|Widget layouts]]</translate>
    <translate>
    <!--T:24-->
    <!--FIXME not implemented in kexi 2.4
    **[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Setting widgets size and position by hand|Setting widgets size and position by hand]]</translate>
    <translate>
    <!--T:25-->
    -->
    **[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Setting the tab order|Setting the tab order]]
    **[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Setting the tab order|Setting the tab order]]
    <!--T:26-->
    *[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Entering Data Using Forms|Entering Data Using Forms]]
    *[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Entering Data Using Forms|Entering Data Using Forms]]


    ===Introduction===
    ===Introduction=== <!--T:3-->


    To learn the basics of '''Kexi''', you could build a simple database utilizing most elementary '''Kexi's''' features. To make things simpler, advanced database design topics will not be covered here.  
    <!--T:4-->
    To learn the basics of '''Kexi''' we will build a simple database utilizing most of the elementary features of  '''Kexi'''. To make things simpler, advanced database design topics will not be covered here.  


    Start by creating a new empty Phone Book.  
    <!--T:5-->
    We start by creating a new empty Phone Book.  


    <!--T:6-->
    Having a new empty database project, perform the following steps:
    Having a new empty database project, perform the following steps:


    # Design database tables. Read the section called [[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Tables|Designing Database Tables]].
    <!--T:7-->
    # Enter data into tables. Read the section called [[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Entering Data Into Tables|Entering Data Into Tables]].
    # Design database tables. Read the following section called [[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Tables|Designing Database Tables]].</translate>
    # Design database queries. Read the section called [[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Queries|Designing Database Queries]].
    <translate>
    # Design forms. Read the section called [[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms|Designing Forms]].
    <!--T:27-->
    # Use forms to enter data. Read the section called [[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Entering Data Using Forms|Entering Data Using Forms]].
    # Enter data into tables. Read the following section called [[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Entering Data Into Tables|Entering Data Into Tables]].</translate>
    <translate>
    <!--T:28-->
    # Design database queries. Read the following section called [[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Queries|Designing Database Queries]].</translate>
    <translate>
    <!--T:29-->
    # Design forms. Read the following section called [[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms|Designing Forms]].</translate>
    <translate>
    <!--T:30-->
    # Use forms to enter data. Read the following section called [[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Entering Data Using Forms|Entering Data Using Forms]].


    <!--T:8-->
    {{Prevnext2
    {{Prevnext2
    |prevpage=Special:MyLanguage/Kexi/Handbook/Building_Simple_Databases/Designing_Database_Tables
    |prevpage=Special:MyLanguage/Kexi/Handbook/Kexi_Basics/Using_built-in_help
    |prevtext=Designing Database Tables
    |prevtext=Using built-in help
    |nextpage=Special:MyLanguage/Kexi/Handbook/Kexi_Basics/Using_built-in_help
    |nextpage=Special:MyLanguage/Kexi/Handbook/Building_Simple_Databases/Designing_Database_Tables
    |nexttext=Using built-in help
    |nexttext=Designing Database Tables
    |index=Special:MyLanguage/Kexi/Handbook|indextext=Back to menu
    |index=Special:MyLanguage/Kexi/Handbook|indextext=Back to menu
    }}
    }}


    <!--T:9-->
    [[Category:Kexi]]
    [[Category:Kexi]]
    [[Category:Tutorials]]
    [[Category:Tutorials]]
    </translate>
    </translate>

    Latest revision as of 16:59, 26 April 2015

    Other languages:

    Building Simple Databases

    Introduction

    To learn the basics of Kexi we will build a simple database utilizing most of the elementary features of Kexi. To make things simpler, advanced database design topics will not be covered here.

    We start by creating a new empty Phone Book.

    Having a new empty database project, perform the following steps:

    1. Design database tables. Read the following section called Designing Database Tables.
    2. Enter data into tables. Read the following section called Entering Data Into Tables.
    3. Design database queries. Read the following section called Designing Database Queries.
    4. Design forms. Read the following section called Designing Forms.
    5. Use forms to enter data. Read the following section called Entering Data Using Forms.