Table of contents
📝 Theory | 🔨 Practice |
---|---|
Introduction What is non-code development? Who can become a non-code developer? Limitations of non-code technology. | ![]() |
My Visual Database Features Overview Scope, DBMS used, stored data and visual components of MVDB | ![]() |
![]() | First application Installing, configuring and creating your first application in My Visual Database. 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 Application with one table. TAForm and TdbStringGridEx components. Properties Name, Top, Left, Width, Height, Sizeable, Editable, Settings, Anchors. |
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 My Visual Database (MVDB). | ![]() |
![]() | 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 (TAForm). General properties of My Visual Database components | ![]() |
Magic MVDB Button A button is a simple and powerful element of My Visual Database, with the help of which 90% of the main tasks of managing the operation of the application are solved. | ![]() |
![]() | 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 (TdbStringGridEx) – customizing appearance and behavior: filtering, sorting, editing, alignment | ![]() |
Data Input Components Data input and display components: TextBox, ComboBox, CheckBox, DateTimePicker, Memo, RichEdit, DBImage, DBFile, Calendar. | ![]() |
Editing form The editing form is intended for adding and changing individual records in the table. | ![]() |
Input text and numbers The TextBox (TdbEdit) component is used to input text and numeric data (data type: text, integer, real, money) | ![]() |
![]() | Project “Library v.2.2” Editing form. Creation and configuration of buttons for calling the form and saving data. Setting up the delete button. |
Dropdown list (TdbComboBox) Drop-down list (Combo Box) – a component for editing reference fields. Display styles and cascade filtering. | ![]() |
Date and time (TdbDateTimePicker) A universal component for inputing and displaying dates and times with a drop-down calendar. | ![]() |
Input long text (TdbMemo) Component for entering and displaying multi-line text information TdbMemo. | ![]() |
![]() | Project Library v.3.0. Components for inputing numbers, dates, and multiline text. Setting up a drop-down list for editing reference values. |
Checkbox (TdbCheckBox) The CheckBox component is used to input two Boolean values: “Yes” or “No” (True, False). | ![]() |
Calendar (TdbCalendar) Component for displaying a calendar. Enter one or more dates. Display of several months. | ![]() |
Image storage Storing images in My Visual Database. TdbImageDataBase component – storage in database and file storage. | ![]() |
File storage (TdbFileDataBase) 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 (TdbRichEdit) 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 (TdbLabel) Label is a simple component that is used to display static text. | ![]() |
Images (TdbImage) A component for placing static images on a form, supports the following formats: jpeg, png, bmp, gif. | ![]() |
Group (TdbGroup) 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. | ![]() |
Panel (TdbPanel) The panel component (TdbPanel) is a container for placing other elements, as well as a decorative element: you can set the color and customize the frame. | ![]() |
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. | ![]() |
Map (TdbMap) The component allows you not only to display a Google map, but also to visualize marks on it, information about which is in the database. | ![]() |
Counter (TdbCounter) 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 My Visual Database has a built-in filtering mechanism based on modifying an 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 | ![]() |