Kexi/Handbook/Building Simple Databases

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 the tab order

• Entering Data Using Forms

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.

• ← Using built-in help
• ↑ Back to menu ↑
• Designing Database Tables →