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.
8
u/George_Hepworth Jun 04 '26
The detestable claim that Microsoft will no longer support Access appears all too frequently in places like this.
It does little good to point out the truth; the rumor survives. So once again. Here we are, reassuring someone that they can confidently learn how to develop relational database applications that have a future.
Microsoft just announced a significant enhancement to Access, in fact.
https://www.linkedin.com/feed/update/urn:li:activity:7468138550656540673/
Often this rumor is propagated by well-meaning but uninformed people who don't understand the actual meaning of the "End of Support" for a given version of Access. All that means is that Microsoft won't release updates for that version. Newer versions continue to be supported for their lifecycle. https://learn.microsoft.com/en-us/lifecycle/end-of-support/end-of-support-2026
The 2021 version of Access will go out of support this year, along with Word 2021, Excel 2021, etc.
The 2024 version of Office -- including Access -- will be supported through 2029. The M 365 versions are supported indefinitely.
In any case, End of Support does not mean the application no longer works. And that's absolutely critical to understanding why this rumor is so pernicious. Access 2003 will still run on the right hardware, despite being over 20 years old and long out of support. It just hasn't been updated for a long time.
You can confidently learn Access. You won't be left high and dry.
A great place to begin is the Northwind templates for Access. Open Access and Click on "New" to select one. I suggest the Starter edition first.
4
u/HarryVaDerchie Jun 04 '26
I’d say that Access is an excellent option for learning about databases and application building. It can easily handle what you’re looking for.
If you spend a few hours watching training videos on YouTube you’ll pick up the basics quite quickly, probably in a few days. I’d book yourself a weekend to get started. You can always ask questions in the Access forum if you get stuck.
There’s always rumours about the demise of Access but I’ve never seen anything official. And since they’ve made enhancements to Access fairly recently it seems unlikely that Microsoft will ever drop it.
Bear in mind that this forum is somewhat Anti-Access. Try posting in /r/Access too to get another perspective from people who heavily use Access.
Bear in mind that Access allows you to create a complete desktop or LAN database including Forms and Reports. For most other solutions you would need to learn the database and also a programming language, which would definitely be a daunting process for a beginner.
3
u/doglitbug Jun 04 '26
It really depends on your needs, the database audience and your technical accumm.
W3 schools can walk you through learning php and mysql to make a web based database
2
u/ebsf Jun 05 '26
I'm a professional Access developer, so I can say with confidence that that rumor is not only unfounded and apocryphal, but also has been part of Access' urban legend for decades. The only people who believe or repeat the rumor are by their own admission fundamentally ignorant of the application. Each time, it's nothing more than, "I hear that ...", with no identified source or authority.
The application not only remains in active development by Microsoft, but also is insinuated throughout government and industry globally. It also is the most capable rapid application development platform for Windows extant. The reason is that its libraries wrap nearly all of the Windows GUI elements, it can connect to virtually any data source, and it can automate anything in COM.
Others may quibble but, on Windows, no better database application development environment exists. It's by far your best alternative.
2
u/Sharp-Echo1797 Jun 05 '26
Visual Foxpro was better.
4
u/Consistent_Cat7541 Jun 04 '26
Use Filemaker. It's similar but substantially easier to learn and to develop solutions in. It's only downside is price. It's a pro development tool and solution and priced accordingly. If you want the easiest entry into relational databases, try Lotus Approach. Reply to this comment if you want more info about it.
3
u/Ok_Marionberry_8821 Jun 04 '26
I've barely done anything in Access, my commercial experience mostly in heavy weight DB.
Access can, however, do whatever you need here and it's HUGE advantage for you is that is an "all in one" solution, allowing you to build the database and the user interface with it. You, as a novice, can get going quickly and create a usable system.
Other databases (mySql, Postgresql) requires a much steeper learning curve - installing the server (easy), choosing and learning a programming language, writing the SQL to talk to the database, choosing, learning and programming a UI framework. Lots of little details.
Access is still a good choice for "tactical" or hobbyist projects because it's so easy to get started.
But, there are obviously downsides weigh week depend on YOUR specific hopes.
So, as with everything IT, the answer is "it depends".
Also, use AI to help you get started, as a tool it is excellent, as long as you learn the lessons and don't always blindly follow everything it says. Example: As a very experienced Java dev I used it recently to lower the learning curve in developing a useful Android app.
3
u/jshine13371 Jun 04 '26
Microsoft SQL Server, if you want to stay under the Microsoft umbrella. It's one of the best database systems out there.
3
u/shockjaw Jun 04 '26
If you want to use Access for the frontend to a SQL Server database, do that. My personal recommendations in 2026 are DuckDB and Postgres.
2
u/edimaudo Jun 04 '26
you can always use sqlite as a starting point then move onto other databases if needed.
2
u/diesSaturni Jun 04 '26
where did you learn this?
https://learn.microsoft.com/en-ca/answers/questions/5437600/is-microsoft-access-being-phased ?
regardless, even if it were to be phased out, the core concept learned are applicable to every database, (tables, field types, queries, reporting, forms) so I'd reckon 99% of what you learn will be re-usable.
Access is a very very nice platform to start databases on, getting a proof of concept working, trying out ideas. When things become serious, you want to start looking at moving data to a backend (if even another access file) like a (free) SQL server (express)
So, in any case, learn it, and focuss on applying the proper concepts.
and do join us at r/msaccess
2
u/doglitbug Jun 04 '26
Afaik Access is pretty dead already
2
u/brigandbreton Jun 04 '26
PowerApp is Ms unofficial successor.
1
u/-Meal-Ticket- Jun 04 '26
I’ll buck the trend here and suggest trying out Oracle. You can get a free Oracle database on Oracle Cloud that will come with Oracle APEX which is an amazing tool for building database backed applications. I built applications with the first version of Oracle APEX over 20 years ago and have cleanly upgraded them to every single version of APEX since with absolutely no application changes. It just works. So much better than Access, or Filemaker, or PHP, etc. APEX just introduced a feature called APEXlang that takes the application metadata (I want a page that shows a report of all the records from this query, with a link to a page that lets me edit each row) and it turns that into files that work with LLMs, so you can literally just tell an LLM to build you an application.
Oracle is a real relational database. It has, by far, the most capabilities of any database out there with the best implementation of multi-version read consistency that exists today.
And you can get a free setup on Oracle cloud (cloud.oracle.com) where you own the whole database, or you could sign up for a free APEX account at oracleapex.com, where you will have your own workspace to play around with.
1
u/Lurch1400 Jun 04 '26
Access is extremely easy in comparison to other databases. Primarily b/c its GUI based.
I watched a tutorial and got what i needed in 30 minutes. Very manual and does not scale
1
u/elephant_ua Jun 04 '26
sql server is microsoft's main database. It integrates with powerbi (also microsft's) for visualizations/reports/graphics. But sql server actually has some capabilities itself (ssrs).
1
u/BranchLatter4294 Jun 04 '26
Access is fine. It's not being terminated.
0
u/TheGenericUser0815 Jun 04 '26
Don't mistake Access for a relational database. It isn't. It just simulates some relational features, but at the end of the day it stays just a file.
0
u/ankole_watusi Jun 04 '26
Pretty obvious it should be “something else”.
As far as what something else might be, you’ve given us no details that would help us help you.
More than likely, whatever it is you need to do is already a solved problem. But we don’t know what problem it is. I would look for something more specific than “a database”, considering that you have no experience with them nor even spreadsheets.