Developer

Murray Brown

<div>
Thanks Daniel. That is very good to hear. I have just moved back to London where Access is used heavily, so it is good to know that there is something of a shelf life
</div>


<div>
Thanks dpearson for "Power BI does a nice job at that for us. " - that is great to know. Perhaps I should start with that
</div>


<div>
Again this is really interesting to know "The interesting thing is we're not a Microsoft shop. &nbsp;We're all about Java apps and MySQL on Linux servers. &nbsp;But we use PowerBI for the analytics. &nbsp;So that opens a really big opportunity for an analytics developer as there's vastly more MySQL instances running on Linux servers waiting to be analyzed than folks running pure Microsoft stacks. "
</div>


<div>
For developing robust business solutions nothing beats Access. In the world of small to medium size businesses, I have always found Access to be a great tool. Used properly, it provides a platform that is very efficient and easy to maintain.<br>Of course the developer has to have a thorough understanding of the application. Also, work with your users. Amazing how they can give you insight in how to make their jobs more efficient through system enhancements.&nbsp;
</div>


<div>
You may always say this independently on the language/tool used for the development. If you are developing long time in one language then you are becoming expert even when you don't push for it...<br><br>OTOH, I would be very cautious when MS Access application(s) should become business critical in my company. Access is good for single computer, for prototyping, for very small teams etc. But several vendors delivering Access applications which are intended for use across the midsize company means no go for me. And this is valid even when the data are stored on a SQL backend.<br><br>I can imagine how several vendors are upgrading to the given version, how users cannot test Access application when their computer is occupied by a different Access engine version or bit depth etc.<br><br>Even the medium sized business should focus on platform independent solutions.
</div>


<div>
<div class="content wysiwyg-content">
Hi<br />
I am an Access VBA and Excel VBA developer. I have also spent ten years working on ASP.net sites using vb.net. I am a little confused by all the the products Miccrosoft has released for analytics. I know that Power BI is used heavily but to me it isn't as good as raw SQL. Based on what organisation's are using where is Microsoft going? What should someone with my skill set focus on to keep up with Microsoft analytics? Is Access being dropped?
</div>
</div>


Hi
I am an Access VBA and Excel VBA developer. I have also spent ten years working on ASP.net sites using vb.net. I am a little confused by all the the products Miccrosoft has released for analytics. I know that Power BI is used heavily but to me it isn't as good as raw SQL. Based on what organisation's are using where is Microsoft going? What should someone with my skill set focus on to keep up with Microsoft analytics? Is Access being dropped?

Microsoft Analytics. Where to focus as an Access developer

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.