Wow! It’s been nearly six years of providing you with Microsoft Access database blogs and I wanted to say a big thank you to all you, the subscribers and of course those who entrusted me by purchasing one of my e-products and e-books.
If this is your first visit to my blog then welcome 🙂 Take a look at this blog site and browse the history by selecting the Archive ‘drop-down’ box by month.
There are over 300 posts and several ways to navigate through the archives by clicking a category, selecting a month or using the recent posts feature.
Microsoft Access Database Blog – Six Years On
Remember, to sign up for your free weekly tips and e-book.
If you want to know more detail or like some of my e-product utilities, why not take a chance and purchase them? In fact, there’s no risk at all as I provide a full money back guarantee plus a 30-day email support to help you through the learning curve (which is not really too steep!).
Once again, a big thank you to all for visiting my Microsoft Access database blog 🙂
Microsoft Access Database: Should We Be Using Calculated Table Fields
With the introduction of Microsoft Access 2010, a new data type field appeared in your table design view which provided a basic way to take fields in the same table and create new expressions as a new dedicated field sitting at the ‘top of hierarchy’ database!
However, should we really be using this new data type and practice at all?
Purists will frown upon this technique and say you should stick with Excel to store real values and expressions together. By doing so, you are breaking the rules of database normalisation and also cause a maintenance headache once your database has been deployed.
Microsoft Access 2016 Database – New eBook Arriving Soon
Since the release of Microsoft Access 2016 late last year, everyone has been busy re-writing and documenting the changes to MS Access and in essence, there’s little difference when comparing it to the previous version (2013).
However, to help freshen up and bring any newer features into the fold, I too have been busy re-writing my current eBooks which were originally written and supported for most versions ranging as far back as version 2000 (through to 2010).
Microsoft Access Database Templates – Some Are Even Free!
With the latest version of Microsoft Access database (2016) and following on with tradition, Microsoft provides a selection of free Access templates and these can be found via a new database file action where thumbnails are available to get you started.
Quite a few of the standard templates are reasonable and they do require more custom design time to at least make them more user friendly.
However, take the above ‘Tasks’ database example which created several different objects including tables, queries, forms and reports – In fact, 30 objects were generated which also included macros and a little VBA code.
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 are all Excel-aholics who can’t get through the day without busting out a spreadsheet…“.
Here’s the article link: http://goingconcern.com/post/accountants-should-dump-microsoft-excel-database-software
Accountants Should Dump Microsoft Excel for Microsoft Access Database
The default reaction is to lean towards Excel and that’s understandable but that’s because it’s how we are all first taught to use this application and the ease of how a spreadsheet can be to manipulate data and analyse out.
But where data integrity and security protection is key to the maintenance and workflows of a system, you simple have to consider Microsoft Access databases.
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 say the more popular Excel spreadsheet or any other desktop software?
A: The key feature is the ability to “ask questions” and perform actions with large amounts of the data via Queries which is its real strength. For the common MS Office user who doesn’t know anything about MS Access databases, this application can seem fairly user-friendly and most users tend to lean to a more comfortable environment, namely Excel.
Q: What’s the best way to start learning Microsoft Access?
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 2016 and use in a standard web browser. The data and database objects are stored in SQL Server or Microsoft Azure SQL Database, so you can share the data within your organisation using on-premises SharePoint or Office 365 for business. An Access App is created either from a template or from scratch.
Generally, a desktop database is a database system created to run on a single computer. Desktop databases are much more limited and constrained than larger data centre or data warehouse systems, where primitive database software is replaced by sophisticated hardware and networking setups.
An MS Access desktop database helps you store and track any kind of information such as inventory, contacts, or business processes. Like the Access app, you can also create an Access desktop database by using a template or creating it from scratch.
How to identify the two types of Access templates? An Access app template has a globe icon in its picture and the title of the app does not contain “desktop.” For example, “Asset tracking” or “Custom web app.” While an Access desktop database template has no globe in the picture and its title has “desktop” in it. For example, “Desktop asset tracking,” or “Blank desktop database.”
In this section I’m going to list the advantages and disadvantages of using Access macros that is an exercise developers need to carry out to determine how they will programme their application going forward and avoid the dreaded result of having a ‘pear shaped’ and inflexible database.
Benefits of using Access Macros
Here’s the list:
1. Easier to write! You do not have to have a university degree in computer programming to understand and utilise macros. The command reference is intuitive and easy to apply. It just requires some investment of your time.
2. Disabled Mode – From version 2007 by default, any database opened that contained VBA code would not run as part of the security changes made to Microsoft Office applications and prevent unwanted macro virus threats that the VBA code could contain some malicious routines which some programmers seem to get a kick out of! Macros used within templates in Access are safe and run in normal mode.