Excel literally has internal support for treating other excel workbooks as SQL databases, encouraging end-users to do that instead of using MS Access properly, and *it doesn't even work*.

MS Access and properly in one sentence. You're really brave...

We had to learn access in school. It's a huge pile of garbage. Literally everything you do requires you to close two other tabs. I used postgresql before and hoped for the best when the teacher announced we would learn relational database programming with m$ access, top of the art db software. But this stuff is worse than I thought.

@b3b3 libreoffice has a better version actually

@Techno-Wizard yes. My teacher told us how much the libreoffice equivalent sucks etc. So I tried it at home. It worked to much better actually. It was pretty much the same as access but without most parts you'd get mad on. I told him that the libreoffice version actually works better and we should use it at school (since we, as the students, actually have to use this piece of garbage called access). He didnt believe me. He tried it. He understood i was right. But he doesnt want to use libreoffice on school pcs. Luckily I'm done with school now.

@b3b3 it's not perfect, no, but I can actually use it as a dbms and not get angry. Plus, actual sql instead of ms somethingquery, whatever it is.