Kexi/Handbook/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

Introduction

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.

Start by creating a new empty Phone Book.

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

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