It's a stupid question, I know.
I almost had no contact with MS Access. I know it's a database. Does he have anything special? Any feature worthy of note? How does it work? What demands does it meet?
What is Microsoft Access for?
5
asked by anonymous 13.04.2018 / 01:00
1 answer
6
MS-Access is more or less equivalent to Excel and Word, but to database.
It has its own database format (MDB) where data, screens, reports, programs, etc. stay together. But it can also be client of any database server via ODBC. Or you can separate the database into an MDB and apply it to another MDB.
It was a popular platform that promised a lot in the 1990s for development of entire systems because it is programmable using Visual Basic (which is also an Excel popularity factor). There was a bit of that illusion back then that small businesses could develop their own systems without the help of a professional developer.
It is a powerful tool but Excel has prevailed as a small business administration tool, since it is also scriptable and can also read databases, there is also a strong secondary market for Excel spreadsheets and plugins. Excel also has an intuitive interface (spreadsheet everyone knows, not much databases) and the learning curve is more linear - Access is easy to do basic things, but when it needs something a bit more complex, the curve is almost vertical.
Apart from this, the complexity of the systems has increased a lot since then - in the 90s a small business had a computer, at most a handful connected via local network, nowadays when speaking "system" already presupposes access via the Web, remote access, high availability, etc. etc. no matter how small the negeocio, then that illusion of "do-it-yourself" or hiring the nephew to do system on the weekend no longer exists.
13.04.2018 / 01:17