Kexi/Handbook/Building Simple Databases: Difference between revisions
Merging Burkhards fixes to k.d.o version |
No edit summary |
||
| (6 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> | <translate> | ||
<!--T:24--> | <!--T:24--> | ||
<!--FIXME not implemented in kexi 2.4 | <!--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> | **[[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 62: | Line 59: | ||
<!--T:4--> | <!--T:4--> | ||
To learn the basics of ''' | 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--> | ||
We start by creating a new empty Phone Book. | |||
<!--T:6--> | <!--T:6--> | ||
| Line 71: | 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:
- Design database tables. Read the following section called Designing Database Tables.
- Enter data into tables. Read the following section called Entering Data Into Tables.
- Design database queries. Read the following section called Designing Database Queries.
- Design forms. Read the following section called Designing Forms.
- Use forms to enter data. Read the following section called Entering Data Using Forms.