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: 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.microsoft-access-2016-runtime-now-available-for-download

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.

Make sure you also check out our other Access free stuff.

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 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.

microsoft access 2016 database specifications

Any database can exceed they limits which can cause performance issues and become corrupt overtime which is why Continue reading “Microsoft Access 2016 Database Specifications”

Microsoft Access Database 2016 Is Not Included In Office 365

Microsoft Access Database 2016 Is Not Included In Office 365

Since its release, Microsoft Access database will not be available for all users of Office 365. Shocking isn’t it?

Users who have purchased an Office 365 Business Premium were surprised to discover that Access 2016 wasn’t included in their subscriptions.

Microsoft Access Database 2016 Is Not Included In Office 365

Access 2016 is not included with any of the Office 365 Business subscriptions, even in Office 365 E1 or Office 365 Pro Plus enterprise subscriptions. If you want Microsoft Access 2016 in your enterprise, you should be opting instead for the full Office 365 E3 subscription.

What is more perplexing is the fact that Microsoft Access 2016 is included in Continue reading “Microsoft Access Database 2016 Is Not Included In Office 365”

Microsoft Access Database: Next Generation of Spreadsheets

Microsoft Access Database: Next Generation of Spreadsheets

Bringing your Microsoft Access database application into the current online digital age started with the need for this integral tool for small and medium sized businesses way back in the 1990’s.

WordPerfect, Lotus 1–2–3, and dBase are the three software products that dominated the software market for a long period in the history of personal computing. WordPerfect is used for word processing; Lotus 1–2–3 is a spreadsheet program from Lotus Software; and dBase is a database management system for microcomputers.

During the early days of personal computing, spreadsheets and databases coexisted because there was a clear designation of responsibility between the two models.  During those times, the use of spreadsheets were mainly for financial modelling. While databases were intended for everything organization-related.

Spreadsheets and word processors offered the benefits of simplicity and direct manipulability. Databases were never as manageable as word processors and spreadsheets. The main drawback in using databases was in the technical implementation complexity of the software.

Microsoft Access Database Next Generation of Spreadsheets

As a result, average users began using spreadsheets as provisional databases.
After many consultations with dozens of Excel clients, it became clear that almost all of them were using the product not for the purpose of financial modelling but as a conventional tool for making tables instead.

At this point in time, the office productivity perspective had also shifted from a multiplayer market to one subjugated by Microsoft, which put down Lotus 1–2–3 and dBase with its own Excel and Access database products. The growing grey area between spreadsheets and databases gave Continue reading “Microsoft Access Database: Next Generation of Spreadsheets”

Microsoft Access Database Functions

Microsoft Access Database Functions

This is something I have touched on briefly in the past with an article called Microsoft Access Functions which introduced you to the popular functions and the tool to generally browse for other not so popular function calls.

So as a revisit to this topic, there’s no point describing each and everyone that’s at your disposal – that would be silly as we all have different uses for our Access databases but instead you can find a full list (by category) by going to Microsoft’s Office Access Functions (by category) page instead.

microsoft access database functions office

Microsoft Access Database Functions

It clearly states that this page contains links to articles that provide details about common functions used in expressions in Microsoft Access.

They are arranged first by Continue reading “Microsoft Access Database Functions”

Microsoft Access Tutorial: Creating A Many-To-Many Relationship

Microsoft Access Tutorial: Creating A Many-To-Many Relationship

Let’s revisit a popular aspect to your Microsoft Access database design; Creating a many-to-many relationship.

Firstly, watch this quick video which explain the key components and the starting steps to getting to the many-to-many state for your Access database.

In order to create this type of relationship, it’s now clear we need an interceding or junction table to handle the two-way joins of the outer tables with Continue reading “Microsoft Access Tutorial: Creating A Many-To-Many Relationship”

Microsoft Access Database Tutorial: Creating a Menu Form

Microsoft Access Database Tutorial: Creating a Menu Form

In this tutorial you will learn how to create a main menu form in your Microsoft Access Database.

Take a quick look at the video tutorial below which will step you through the very basics as I’m often asked how easy is it to build your own MS Access menu forms.

Ignore the general look and feel of the forms demonstrated but more importantly, notice how easy it really is to create command buttons Continue reading “Microsoft Access Database Tutorial: Creating a Menu Form”

Microsoft Access Database: Creating Database Field Type Templates

Microsoft Access Database: Creating Database Field Type Templates

Microsoft Access database applications just gets richer and richer as time goes by and from version 2010, you can now create field types or in effect user defined fields stored via the ‘Save Selection as New Data Type‘ command which is located from the context sensitive fluent ribbon bar Fields tab (Table Tools).

Take a look at a demonstration of this is set up and used in the video tutorial below (less than 4 minutes).

Microsoft Access Database (version 2010 onwards) has a new feature which allows you to preserve existing columns that you can use Continue reading “Microsoft Access Database: Creating Database Field Type Templates”

Password Protect The Back End Of Your Microsoft Access Database

Password Protect The Back End Of Your Microsoft Access Database

There are two parts to the following video tutorial explaining how to password protect the back end of your Microsoft Access database where your first need to split the database and then exclusively open the back end database to apply an encrypted password.

Take a quick look how… 

You can also manually link and re-link tables from other databases which will in turn need to be individually password protected should you Continue reading “Password Protect The Back End Of Your Microsoft Access Database”

Microsoft Access Database Tutorial VBA Code Task Tool To Outlook

Microsoft Access Database Tutorial VBA Code Task Tool To Outlook

It’s very strange how Microsoft Access database systems and processes constantly repeat themselves and once again I’m working on some VBA code to communicate with Microsoft Outlook (Email and contact management system).

Here you can see a quick video of such a simple but effective utility I offer (for only the cost of a couple of pints of beer!) – check it out…

Microsoft Access Database Tutorial VBA Code Task Tool To Outlook

The Task Tool utility was built to demonstrate the ease of use and how MS Access VBA code can communicate with Continue reading “Microsoft Access Database Tutorial VBA Code Task Tool To Outlook”