Difference between revisions of "Kexi/Handbook/Building Simple Databases"

(Marked this version for translation)
m (small textual edits to make easier reading)
 
(5 intermediate revisions by 2 users not shown)
Line 5: Line 5:
 
<!--T:2-->
 
<!--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]]
  
Line 26: Line 62:
  
 
<!--T:4-->
 
<!--T:4-->
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.  
+
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.  
  
 
<!--T:5-->
 
<!--T:5-->
Start by creating a new empty Phone Book.  
+
We start by creating a new empty Phone Book.  
  
 
<!--T:6-->
 
<!--T:6-->
Line 35: Line 71:
  
 
<!--T:7-->
 
<!--T:7-->
# Design database tables. Read the section called [[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Tables|Designing Database Tables]].
+
# Design database tables. Read the following section called [[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Tables|Designing Database Tables]].</translate>
# Enter data into tables. Read the section called [[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Entering Data Into Tables|Entering Data Into Tables]].
+
<translate>
# Design database queries. Read the section called [[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Queries|Designing Database Queries]].
+
<!--T:27-->
# Design forms. Read the section called [[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms|Designing 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>
# Use forms to enter data. Read the section called [[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Entering Data Using Forms|Entering Data Using Forms]].
+
<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-->
 
<!--T:8-->

Latest revision as of 16:59, 26 April 2015

Other languages:
English • ‎dansk

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.

This page was last edited on 26 April 2015, at 16:59. Content is available under Creative Commons License SA 4.0 unless otherwise noted.
-->