If you are looking for a user friendly desktop database, Microsoft Access (part of the MS Office Pro package) is a suitable solution. It also have a Graphic interface for query creation. All free DBMS solutions (MySQL, Postgres, SQLite, etc.) are good and reliable, but you have to had some DB Administration skills to manage them correctly, because typically they have a client server architecture and SQL scripting for the queries.
Each of the database systems listed below will meet its objectives to achieve the stated goal:
InterBase Lite, InterBase ToGo, InterBase Desktop, Firbird, MySQL, SQL LIte, MS SQL Server Express, ORACLE 11 Express.
When choosing the environment, it is important to know the programming languages from which you want to access the data. If you want to have an integrated database + application environment you can think about MS Access but this one, unlike the ones I have mentioned outside of InterBase, is not free. All other versions except MySQL can also be used for free for commercial purposes. Access also allows you to create interfaces for the database on the MS SQL Server.
Still an important issue is how much data you want to store and process. These DBMS versions have their limitations, among others due to the amount of memory used, processor cores and the maximum size of the database. You did not write it. What order of data size will be stored and what will be the estimated size of a single record. Answers to these questions should additionally help in the selection. If it turns out that the size will significantly exceed the limitations of the DBMS version I have mentioned earlier, then unfortunately you should think about paid solutions of these SQL servers that do not have these limitations or maybe NoSQL database systems, eg MongoDB, Cassandra, BerkleyDB, Riak, Redis, Neo4J , Infinity Graph, OrientDB.
Dear Sebastian, thanks for the reply. What I'm looking for is a whole desctop application, not only the DB soluion. UI, validation, etc. I am developer myself and the question is if such program exists or I have to build it from scratch.
Independly on the chosen solution, even if it is MS Access, you will have to design the database structure, and then create a GUI using the forms, reports, macros and VBA code. He will not run away from it. The database is a a back-end for an application based on a database. The database is an integral part of the application. Is the core of this application. If these are simple data, there is not a huge number of them, then you can think about storing them in files such as xml, JSON or other files that are self-typed. Possibly, depending on the programming environment used, use appropriate DataSet components such as ClientDataSet in Delphi - but this data should be recorded somewhere - so either in files without using any DBMS (using the CDS component) or in one of the previously mentioned by me DBMS solution. Rather, you'll have to build such an application yourself. It will definitely have the advantage that she will be 100% tailored to your needs and will have the functionality you expect. I do not know if you will find a ready-made free or commercial solution that will be ready for use and will suit your needs.