In this video I talk about the advantages and limitations of using Microsoft Access as a modern development environment for custom office tools in order to answer the question, "Is Access still useful?"
I take you through some of the features that make Access a very capable rapid application environment including it's table designer, relationship designer, query designer, form designer, and built-in programming language, Visual Basic for Applications (VBA).
I also talk about a very important caveat to using MS Access in the modern office environment and that is connecting it to data that resides on SQL Server or SharePoint.
If you would like to learn how to run SQL statements from within VBA code, or work with recordists in VBA, please checkout my videos below:
[ Ссылка ]
[ Ссылка ]
And if you would like to download any, or all, of the example files with source code that I use in my videos, please click the link below and become a member of my channel for less than the price of a cup of coffee. Thanks!
[ Ссылка ]
Ещё видео!