fbpx
Logo
Mail us
ben@accessdatabasetutorial.com

Category Archives: Utilities

Microsoft Access Database Templates – Some Are Even Free!


ms access

With the latest version of MS Access database (2016) and following on with tradition, Microsoft provides a selection of free Access Database 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, […]

Tags: , , , ,

Microsoft Access Database 2016: Printing Reports


Microsoft Access database

A report is only as good as the data stored and retrieved (typically via a query) in your Microsoft Access database but this simple video tutorial (less than 3 minutes) demonstrates what the feature you can run from your report print preview… While you can print reports using commands via the Backstage view, you can also use Print Preview. Print Preview shows you how your report will appear on the printed page. It also allows you to modify the way your report […]

Tags: , , , ,

Microsoft Access Database File Format: What is an ACCDR File?


Microsoft Access

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 […]

Tags: , , , ,

Microsoft Access 2016 Macros: Show All Macro Commands


Ms Access Query

The great debate of whether to use Microsoft Access 2016 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. With the later versions of MS Access (post 2010), macros have become more powerful […]

Tags: , , , ,

Microsoft Access 2016 Runtime Now Available For Download


Ms Access Query

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: Download Microsoft Access 2016 Runtime 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 […]

Tags: , , , ,

Microsoft Access 2016 Database Specifications


Microsoft Access 2016

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 […]

Tags: , , , ,