Author Archives: Ben

Accountants Should Dump Microsoft Excel for Microsoft Access Database

Accountants Should Dump Microsoft Excel for Microsoft Access Database I’ve been saying this for years, Microsoft Access databases is simply far better than Excel. In fact Access is just Excel on steroids! As the following link to this article says “…we … Continue reading

Posted in Database Theory, Microsoft Training, MS Access | Tagged , , , , | 1 Comment

Microsoft Access Database: What is… Some Popular Questions

Microsoft Access Database: What is… Some Popular Questions Here are some questions I’ve been asked over the years regarding Microsoft Access databases which I thought you may want to review.  Q: What features make Microsoft Access a valuable tool over … Continue reading

Posted in Database Theory, Microsoft Training, MS Access | Tagged , , , , | Leave a comment

How to Create an Autokeys Closing Macro in Microsoft Access

How to Create an Autokeys Closing Macro in Microsoft Access As a follow on from my last post about Microsoft Access Macros, here’s a good working example clearly explained using the ‘unsafe’ CloseWindow command… It walked you through creating a custom hotkey … Continue reading

Posted in Forms, Macros, MS Access | Tagged , , , , | Leave a comment

Microsoft Access 2016 Macros: Show All Macro Commands

Microsoft Access 2016 Macros: Show All Macro Commands The great debate of whether to use Microsoft Access macros or the higher level of VBA code will linger on until the end of time (or realistically, Access is discontinued)! In the … Continue reading

Posted in Macros, MS Access, Utilities | Tagged , , , , | Leave a comment

Microsoft Access 2016 Runtime Now Available For Download

Microsoft Access 2016 Runtime Now Available For Download If you are going to distribute your Microsoft Access 2016 database to other users who do not have a licenced copy of Access 2016, you can give them a free run-time version. Click here: … Continue reading

Posted in Database Theory, MS Access, Utilities | Tagged , , , , | Leave a comment

Comparing Microsoft Access App and MS Access Desktop Database

Comparing Microsoft Access 2016 App and MS Access Desktop Database Here’s an overview of the comparisons between using Microsoft Access 2016 App and the desktop version. An Access app is a database that you design and modify in Microsoft Access … Continue reading

Posted in Forms, Microsoft Training, MS Access | Tagged , , , , | Leave a comment

Microsoft Access 2016 Database Specifications

Microsoft Access 2016 Database Specifications Welcome to a brand new year – 2016 which continues with regular blog posts – all about Microsoft Access databases. So, with the recent release of Microsoft Access 2016, we now have parity and I thought as a … Continue reading

Posted in Database Theory, MS Access, Utilities | Tagged , , , , | 1 Comment

Microsoft Access Databases: Pros & Cons of Access Macros

Microsoft Access Databases: Pros & Cons of Access Macros Here’s an snippet from my popular Microsoft Access database eBook on How To Use Microsoft Access Macros & Automate Your Application  In this section I’m going to list the advantages and disadvantages … Continue reading

Posted in Macros, Microsoft Training, MS Access | Tagged , , , , | Leave a comment

Microsoft Access Database 2013 Splash Screen Form

Microsoft Access Database 2013 Splash Screen Form Back in 2012, I posted an article on how to create a splash screen form without VBA code too using a little trick to name your database with an .bmp extension to it – … Continue reading

Posted in Forms, Macros, MS Access | Tagged , , , | Leave a comment

Microsoft Office JavaScript Library Will Be Complete Across Office 365, iOS and Mac Early Next Year

Microsoft Office JavaScript Library Will Be Complete Across Office 365, iOS and Mac Early Next Year Microsoft will be having a consistent JavaScript API across the Windows, Mac and mobile version of Office. Looking at Microsoft Office development is like looking … Continue reading

Posted in MS Access, VBA | Tagged , , , , | Leave a comment