Simple Database Program: Create App with Search, Color-Coded Data, Update & Delete Features

Welcome!!! I need to do a simple applet (I will be able to extend it in the future) to work with databases, but I don't really know what language (I have the basics of programming in different languages from school and from my own learning).

So: I have a database with columns (reference number, name, measuring range, date of the next review). And I would like to have a simple graphical environment with a few buttons to search for a given device, e.g. highlighting data in green (the device before the review yellow device for review this month and the red device had no review. And the possibility of leading to the database of new devices, or removal if it is no longer usable.

The only question is how to do it and what base to use? I wanted to make an excel or access base ready, but I work with an older gentleman for whom operating these programs is too difficult.

Ah, and what is important, the database would be stored on the company's server. And it would be great if it could be easily expanded with e.g. the ability to print filtered data, new columns in the type table. e.g. tool holder column.

Since the database is stored on the company's server, maybe it is possible to place the environment to support this database also on the server, and not locally?
If there are more users, then client via WWW. Eg in PHP.

With this Excel / Access it is not a bad idea. I understand you have them, so it's free. If bare Excel / Access is not enough, you can do a small application and hide M $ under it. At the beginning it should be enough, and in the future you will see. If you want to move it to a better environment then algorithms, SQL queries are for use.

I mean exactly something like kinggustav wrote mean. I do not want the service to be from the access level because too many and too small buttons for my colleague. I would like some tiny app made legibly to throw out the contents of the database on a few large buttons, i.e. I have an icon on the desktop, I click and have a base in a nice graphic design. Maybe in diffrent way. As I wrote, I have a base (excel, access), columns (ID number, name, measuring range, next inspection date) and over a thousand records, and I want to make a program for it (visual effort), with which you can pleasantly to search for the needed record, he highlighted dates with colors, and had a simple form with windows to enter a new record.

I think that it would be best for me to write in C #. I used to pat something in C ++ so on such banal operations as mine there should be no major problem I think.

You do what you want, the app is ok locally if one or two people use it.
I work similarly at work, by sharing reports. So also forms for BD. I am using Apache and PhP.
Advantage: access from any computer via WWW, many people have access, without sending applications etc. But for me, accessibility was the main criterion.

It will be used locally, i.e. the app will be on the company's server but only we will have access. Alternatively, I will confine something and do it so that we have access to the same database (to open and edit instruments), and the second position is a rental company that will only be able to display the condition of the device so that it does not have to call and ask about the validity of the device only so that they can see at home . I am already puking with reports because our company still has pure communism and only reports, lists, listings, etc. I wanted to get rid of it and have it in one place that will update itself.

Hey,
I think the easiest way to do this is to use C # .Net in WinForms. There, you'll be able to give buttons, tables and whatever you need quickly. And connecting to the base is a simple matter.

Is this database existing? On what BD engine?

I used to make such a database - Microsoft SQL engine + C # application:

Tzok is exactly the way I need it xD That's it then ....
And the base, I currently have access, but I can easily tap to something else if it makes it easier for me.

C # .Net - WinForms

rudyroman wrote:

Tzok is exactly the way I need it xD That's it then ....
And the base, I currently have access, but I can easily tap to something else if it makes it easier for me.

rudyroman wrote:

Tzok is exactly the way I need it xD That's it then ....

Unfortunately, the program was made to order and I can't support you with a code, because this one was also the subject of the contract. However, screenshots can give you some ideas / functionalities. For example, the ability to attach equipment calibration certificates in PDF or correction tables from calibration in XLS. Binary files were stored in the database as BLOB (generally it would be better to keep them on a server, e.g. FTP, but this would complicate the program). The program requires no installation and works over the network. The base is a solid relational base, probably in the 2nd normal form, and not a simple table. In previews, the upcoming end of reviews / calibrations are highlighted in yellow, and red are highlighted. Editing fields support automatic completion based on existing entries.

Initially, I was going to do it in Accesa - there you can design the GUI for the application.

Chanterelle, something beautiful. Exactly what I need. You guided me a lot with this program. Thanks a lot !!!