Again the trumpet calls for the road, but, as always, I blow the trumpet myself.
Primakov Е.М.
Contents
| 📝 Theory | 🔨 Practice |
|---|---|
| Introduction What is non-code development? Who can become a non-code developer? Limitations of non-code technology. |  |
| Overview of DataExpress features Scope, DBMS used, stored data and visual components of DataExpress |  |
 | Data Express. First project Installation, configuration and creation of the first project in Data Express. Overview of the development environment interface. |
| Software Design Basics Application Design Basics. Customer requirements and technical specifications. Layout and object approach. |  |
 | Project “Library” v.1.0 DX Application with one table. Quickly create an editing form and configure a table view. |
| User mode Overview of DataExpress features in user mode: main menu and toolbar. |  |
| Designer mode Overview of DataExpress capabilities in user mode: component panel, form editor, service menu. |  |
| Relational Databases Structure of relational databases. Types of relationships (one-to-one, one-to-many, many-to-many), normalization (first, second and third form). |  |
| Database structure editor Features of the database structure editor built into DataExpress |  |
 | Project “Library” v.2.0 An educational non-code project on a library topic to reinforce knowledge about relational databases and information about the capabilities of the MVDB editor. |
| Forms Form component properties reference. General properties of DataExpress components | |
| Magic buttons DataExpress | |
| Project “Library” v.2.1 We continue to consolidate the acquired knowledge about forms and buttons and are finalizing the “Library” project v.2.0 |
| Displaying Tabular Data Table component – customizing appearance and behavior: filtering, sorting, editing, alignment, | |
| Data Entry Components | |
| Editing form | |
| Entering text and numbers To enter text and numeric data (data type: text, integer, real number, money), the TextBox (TdbEdit) component is used. | |
| Project “Library v.2.2” Editing form. Creation and configuration of buttons for calling the form and saving data. Setting up the delete button. |
| Drop-down list Drop-down list (Combo Box) – a component for editing reference fields. Display styles and cascade filtering. | |
| date and time A universal component for entering and displaying dates and times with a drop-down calendar. | |
| Entering long text Component for entering and displaying multi-line text information TdbMemo. | |
| Project Library v.3.0. Components for entering numbers, dates, and multiline text. Setting up a drop-down list for editing reference values. |
| Checkbox The CheckBox component is used to enter two Boolean values: “Yes” or “No” (True, False). | |
| Calendar Component for displaying a calendar. Enter one or more dates. Display of several months. | |
| Image storage Storing images in DataExpress. TdbImageDataBase component – storage in database and file storage. | |
| File storage The TdbFileDataBase component is designed to store arbitrary files in a database | |
| Project Library v.4.0. Educational project “Library”. Using a checkbox, as well as components for storing files and images. |
| Text editor Text editor (TdbRichEdit) with extensive capabilities for text formatting, inserting images and tables with the ability to print. | |
| Edit form with child table In some cases, on the editing form it is necessary to place not only fields for data entry, but also a table that displays detailed information related to the data being edited. | |
| Project Library v.4.1. Educational project “Library”. Using the advanced editor, as well as setting up a table to display child information. |
| Additional components Additional components display static data or data that is already in the database. Container components are designed to group child components to improve appearance or functionality. | |
| Label Label is a simple component that is used to display static text. | |
| Images A component for placing static images on a form, supports the following formats: jpeg, png, bmp, gif. | |
| Group A Group Box is a container: a frame on a background, the color of which matches the color of the parent component, with a label in the upper left corner. | |
| Multi-page panel and tabs The multi-page panel allows you to place components on separate tabs and switch the display of tabs using shortcuts. | |
| Counter This interface element is required if your table in your project has a field of the COUNTER type. The component looks like a text input field, but only serves to display a value. | |
| GUI Design Basics Basic principles for designing a user interface, which above all should be simple and understandable. |  |
| Project “Library” v.4.2. We add decorative elements to the program interface that add style and increase ease of use. |
| Search and filtering The Database has a built-in filtering mechanism based on modifying the SQL query to retrieve data. | |
| Table: additional functions You can use a table as a data source for reference fields. This method may be useful in special cases. | |
| Displaying tree information The TreeView component is used to display data in a hierarchical form (tree structure). | |
| Access Control Access control allows you to configure the user interface so that a group of users specified in the settings has access only to certain parts of the application or information. | |
| Glossary |  |