English terms are bracketed.
Kexi | MS Access | dBase i FoxPro | Paradox |
---|---|---|---|
Database (Database) | Database | Catalog (Catalog) | Directory of Related files (Directory of Related files) |
Table (Table) | Table | Database file (Database file) | Table |
Datasheet (Datasheet) | Datasheet | BROWSE Command | View Command |
Table design (Table design) | Table design | MODIFY STRUCTURE Command | Modify Restructure Command |
Primary key (Primary key) | Primary key | Unique Index | Key field |
Index (Index) | Index | Index | Tools QuerySpeed |
Validation rule | Validation rule | PICTURE/VALID Clause | ValChecks |
Query (Query) | Query | Query, QBE, View | Query |
Form (Form) | Form | Screen | Forms |
Subform (Subform) | Subform | Multiple File Screen | Multiple-record selection |
"Open a form" Command (Open a form | Open a form Command | SET FORMAT TO, EDIT Command | Image PickForm |
Find command (Find command) | Find command | LOCATE AND SEEK Command | Zoom |
List box, combo box | List box, combo box | Pick list | Lookup |
Macro (Macro) | Macro | - | - |
Script (Script) | Script | Program file | Script |
As you can see from the table above the terminology used in Kexi is close to the one used in MS Access application.
Kexi | MS Access | dBase i FoxPro | Paradox |
---|---|---|---|
Text (Text) | Text | Character | Alphanumeric |
Long text (Long text) | Memo | Memo | Memo |
Date, Time (Date, Time) | Date, Time | Date | DateTime |
Object (Object) | OLE Object (OLE Object) | General | OLE, Graphical, Binary |
Yes/No (Yes/No) | Yes/No | Logical | Logical |
Integer number (Integer number) | Number (Integer) | Numeric | Integer |
Big Integer number (Big integer number) | Liczba całkowita długa (Long integer) | Numeric | Long Integer | Floating-point number: Single/Double precision (Floating-point number) | Single/Double precision number (Single/Double precision number) | Float | Number |