Microsoft Access: Office 365 Business Subscription Plans To Be included

Microsoft Access: Office 365 Business Subscription Plans To Be included

Microsoft plans to add Microsoft Access database to its Office 365 Business and Office 365 Business Premium subscription plans.

The above plans currently do not provide this all powerful Access application but from the 1st of December until the end of January 2017 will get this automatically updated to their accounts.

microsoft-access-office-365-business-subscription-plans-to-be-included

Microsoft Access: Office 365 Business Subscription Plans To Be included

Be aware, if an organisation subscribing to either of those two plans has elected to get Office 365 updates via the “deferred channel” update process, then Microsoft Access will start to arrive in June 2017. The Office 365 updates so-called “channels,” arrive every four months are called the “deferred channel.” Therefore, “first release for deferred channel” update release arrives every four months and is designed for testing purposes. Continue reading “Microsoft Access: Office 365 Business Subscription Plans To Be included”

Microsoft Access Databases – Using Data Analysis Tools

Microsoft Access Databases – Using Data Analysis Tools

Here’s a quick one minute video demonstration on the main Microsoft Access database tools available for your reference.

This video tutorial is based on Access 2013 but it applies to all versions (albeit maybe found in other parts of the application).

As you can see, these tools look a little tired and old style Windows which Continue reading “Microsoft Access Databases – Using Data Analysis Tools”

Microsoft Access Database Templates – Some Are Even Free!

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.

microsoft-access-2016-task-template-database

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.

Other database templates can also been found like Continue reading “Microsoft Access Database Templates – Some Are Even Free!”

Microsoft Access Database 2016: Printing Reports

Microsoft Access Database 2016: Printing Reports

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 is displayed, print it, and even save it as a different file type like the popular PDF format .

Continue reading “Microsoft Access Database 2016: Printing Reports”

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

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.

microsoft-access-database-file-format-what-is-an-accdr-file

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.

When you do this, you will note the interface will Continue reading “Microsoft Access Database File Format: What is an ACCDR File?”

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

Microsoft Access 2016 Macros Show All Macro Commands

With the later versions of MS Access (post 2010), macros have become more powerful and flexible and with the added introduction of better web integration and the fact VBA Continue reading “Microsoft Access 2016 Macros: Show All Macro Commands”

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

httpvh://www.youtube.com/watch?v=7XstSSyG8fw

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”