Jump to content

Kexi/Handbook/Building Simple Databases: Difference between revisions

From KDE UserBase Wiki
Claus chr (talk | contribs)
Marked this version for translation
Jstaniek (talk | contribs)
No edit summary
 
(7 intermediate revisions by 3 users not shown)
Line 4: Line 4:


<!--T:2-->
<!--T:2-->
*[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases|Introduction]]
*[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases#Introduction|Introduction]]


<!--T:10-->
<!--T:10-->
Line 44: Line 44:
<!--T:22-->
<!--T:22-->
**[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Actions|Actions]]</translate>
**[[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>
<translate>
<!--T:24-->
<!--T:24-->
**[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Setting widgets size and position by hand|Setting widgets size and position by hand]]</translate>
<!--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>
<translate>
<!--T:25-->
<!--T:25-->
**[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Setting the tab order|Setting the tab order]]
<!--FIXME not implemented in kexi 2.4
**[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Setting the tab order|Setting the tab order]]-->


<!--T:26-->
<!--T:26-->
Line 60: Line 59:


<!--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 69: Line 68:


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

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.