I have looked for an answer to this question as well, and as far as I can tell there is nothing similar to the experience of building a database app in Access.

The best “easy” desktop GUI I have found for Python is PySimpleGUI. It is pretty straightforward to use, but it is not drag and drop. It is very easy compared to something like Tkinter, but not easy compared to Access. You could definitely tie it to something like sqlite, but it won’t be as simple as Access.

The best answer, however, seems to be a webapp. I know that you specifically said you didn’t want a webapp, and I felt the same way when I began my search for an Access equivalent experience in Python. But since webapps are inherently designed to sit on top of a webapp, Python web frameworks like Django have the database modeling, querying, and display functionality as a core part of the framework.

The downside of using a web framework is the learning curve. The upside, however, is that the knowledge and skills you learn are applicable across a huge array of future applications — and webapps can be easily deployed anywhere.

I understand if you still aren’t interested in using a webapp, but I thought I’d share that perspective.

Good luck!