25 ms·
><You don’t need to learn any programming languages Yes you do. If you want to have buttons and tables and do something above of only showing the data you'll n
by unnouinceput 5y ago
><You don’t need to learn any programming languages
Yes you do. If you want to have buttons and tables and do something above of only showing the data you'll need to learn VBA. Also SQL implementation for MSAccess has some peculiar stuff in regards to LIKE or how datetime is handled. So you'll learn 2 programming languages actually - VBA % the variaton of SQL that MSAccess has. And you can't scale up from single user to multiple users as MSAccess is not a server like PostgreSQL.
- kube-system 5y agoIIRC (it's been a while), you can check all the boxes of C, R, U, and D, using forms. And Access is multi-user. You don't want a lot of users on it, but you can have more than one. This is extra credit though, the OP never asked for a multi-user solution.
- Rizz 5y agoMS Access works just as well on an SQL Server database as on its internal database, so your scaling works just as well as on any other established database server, and then the SQL dialect is T-SQL, which is reasonably standards compliant.
- jaxrtech 5y agoCan also say that the SQL implementation in Access is reprehensible in terms of silent errors and other weirdness.