Access Database Forms: Should We Use Unbound Forms?
I’ve always been a big fan of Microsoft Access databases, why? Because I like the way a rich application like this can be customised and designed from the floor up with little IT programming and development knowledge. Plus, I like building things 🙂
Microsoft Access Database File Format: What is an ACCDR File?
You may have come across the ACCDR extension file format option for a Microsoft Access database instead of the standard and more commonly used file extension ACCDB. So what is this file extension format?
Simply put, the letter ‘R‘ could best be denoted as the ‘run-time’ mode of your MS Access application which will lock the database as a ‘read-only’ instance from the design and general application.
The method is very straight forward! Just simply rename the file extension (once the database file is closed) to ‘.ACCDR’ via the O/S Windows Explorer. Make sure you can see the file extension view (search the web on how to switch this view on).
To open the newly renamed file extension will need to be carried out from either Windows Explorer view or an icon shortcut and not via the Microsoft Access database application’s ‘Open‘ command.
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?
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 meantime, most Access developers will continue to lean towards Access VBA but the majority of power users, self-taught Access designers will still embrace the ease of g using macros to automate their databases.
Note: Please make sure you have checked out the licence agreement and understood the terms before deploying the above run-times. Search on Microsoft’s website for further information.
There are two versions of the currient Access 2016 application. Make sure you have idenrtified which operating system you have installed (including the correct Windows o/s too) as you can choose between the 32 bit and 64 bit versions.
All versions can only run from Windows 7 or higher and that may need some updates added first.
Microsoft Access 2016 Runtime Now Available For Download
Microsoft Access 2016 provides a rich platform for developing database management solutions with easy-to-use customisation tools. If no end user customisation is required (including report modifications), you can choose to distribute those Access 2016 solutions so that they run without requiring a full installation of Access 2016. To do so, you must package and distribute your application with Access 2016 Runtime.
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.”
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 recap (as with earlier versions of the past), we may as well start with Access 2016 specifications and get to know your limits (if any)!
This information about the limits of Microsoft Access database files and objects can be found from the official Microsoft support website.
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.