How to make an interface with "windows" for sql?

V

vTanke2016-10-23 14:17:24

SQL

vTanke, 2016-10-23 14:17:24

I don't know where to start, so I'm asking for advice.
There was a need to maintain a small database of several tables. It's simple: 1 person fills in the database, the second person makes queries in the database and receives the necessary reports. All in windows.
We need an interface without problems and store data in a database. To use all this on 2-4 computers on a local area.
The question is how to implement. I am familiar with a little sql (mysql and ms sql), knowledge in sql is enough to do all this with queries, but the problem is how to execute "beautiful windows" for this. It's not for me to work with the database, I just want to help people. What is needed is windows with fields for entering information and a window with plates for reports in a simple form. The web is not needed, although there is no fish ...
Advise how it is easier to be like this except to learn one of the programming languages.

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

R

Roman Mirilaczvili, 2016-10-23
@2ord

Are LibreOffice Base or Ms Access not suitable?

I

itHauntsMe, 2016-10-23
@itHauntsMe

The simplest type of application, which is just a "window interface" to the database, is CRUD ( create, read, update and delete). There is an example of such an application for every self-respecting technology stack. But you have to figure out how what is done in order to finish it for a specific task.
https://habrahabr.ru/post/269083/
Or teach people how to use SQL Server Management Studio/PHPMyAdmin. For me, the top in terms of usability is IBExpert, but it's for Interbase/Firebird.