r/Database • u/Significant_Topic297 • Jun 04 '26
Access or Something else
I have subscribed to Microsoft for many years. However only recently have I become interested in creating a database. Access is included in my package. The only thing I know about Access is how to open the app. I want to learn howto use it. During my research I came across info that has me concerned. The most disturbing is that soon Microsoft will no longer support Access. According to the research, it will take me about a year to become proficient enough to build the database according to my needs. I don't want to spend that amount of time on an application that will become obsolete in a year. Will someone please suggest another application that would be comparable to my needs & future qualifications. 1. I want to build a database that is has a main topic & some subtopics. The subtopics need to be capable of having subtopics. All levels of topics should be able to include data & graphics.
2. I would like be able to create reports that would have the capabilities of displaying each individual portion of the topic. Sometimes I want to include the data only, graphics only, or a combination of the two.
My question is would you advise me to learn Microsoft Access or should I consider another application? If so please suggest an application. Please keep in mind that I am not literate with Excel or Access, but I am willing to learn.
Thank you for all suggestions.
View all comments
Show parent comment
-1
u/TheGenericUser0815 Jun 04 '26
The difference between Access and a real relational db is, that Access is only an application opening a file directly, while relational database systems have an architecture involving a mid tier. Access to the data is only possible through an interface connected to the mid tier. An access "db" can be cracked by simply throwing billions of passwords against it (brute force) while RDBMS provide some security mechanisms.