Welcome to Microsoft Access Database Tutorial

Wednesday, May 04, 2016

Welcome to the Access Database Tutorial website that will show you how to use Microsoft Access Database by learning and managing this powerful application using the most effective techniques and tools available for visitors with very little or no knowledge to get you up and running without the need to learn all the ‘geek’ speak keeping it Jargon free that most trainers and consultants like to impress you with!

If you are new to Access or wish to know what is MS Access, please take a look at

An Introduction To Microsoft Access

Also, this website contains a blog, products on offer and free general tips to help users find out all about  latest news and articles I feel worth mentioning along with my recommendations of videos and books.

microsoft access courses onlineOnline Coaching? As a Thank You for Visiting…

Claim Your Free eBook NOW!

Enjoy and thank you for visiting!

Posted in MS Access | Tagged , , | Comments Off on Welcome to Microsoft Access Database Tutorial

Accountants Should Dump Microsoft Excel for Microsoft Access Database

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

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.

There’s also a compromise where both could be used and this maybe a fair outcome to get the best of both using their strengths and dismissing the weaknesses at the same time.

Want to learn more? Take a look at my eBook bundle covering the key objects of Microsoft Access database.

Posted in Database Theory, Microsoft Training, MS Access | Tagged , , , , | Leave a comment

Microsoft Access Database: What is… Some Popular Questions

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.

microsoft-access-database-what-is-some-popular-questions

Q: What’s the best way to start learning Microsoft Access?

A: It all depends on how you best absorb information and learn new technologies. Some people prefer a book but that can be quite time consuming and hard to follow as most books tend to be Continue reading

Posted in Database Theory, Microsoft Training, MS Access | Tagged , , , , | Leave a comment

How to Create an Autokeys Closing Macro in Microsoft Access

How to Create an Autokeys Closing Macro in Microsoft Access

As a follow on from my last post about Microsoft Access Macros, here’s a good working example clearly explained using the ‘unsafe’ CloseWindow command…

It walked you through creating a custom hotkey for Microsoft Access (using version 2010 though it will also apply through to the current version, 2016) which used the ‘Autokeys’ macro.

This macro shows you how to avoid a problem during a design and run-time for a form where incorrectly closing this object can save filters and sorts into their properties and alter their behaviour when re-visiting the form.
Continue reading

Posted in Forms, Macros, MS Access | Tagged , , , , | Leave a comment

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

Posted in Macros, MS Access, Utilities | Tagged , , , , | Leave a comment

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.

Posted in Database Theory, MS Access, Utilities | Tagged , , , , | Leave a comment

Comparing Microsoft Access App and MS Access Desktop Database

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

microsoft acces-app-icon microsoft access-desktop-icon

Access app and Access desktop database serve different purposes. You may want to check the table below to see which one works best for you. Continue reading

Posted in Forms, Microsoft Training, MS Access | Tagged , , , , | Leave a comment

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

Posted in Database Theory, MS Access, Utilities | Tagged , , , , | Leave a comment

Microsoft Access Databases: Pros & Cons of Access Macros

Microsoft Access Databases: Pros & Cons of Access Macros

Here’s an snippet from my popular Microsoft Access database eBook on How To Use Microsoft Access Macros & Automate Your Application 

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.

access macros ebook cover

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.

3. Access Services – With the introduction of SharePoint server where you can now publish your Access database on the web in a secured environment, VBA code is Continue reading

Posted in Macros, Microsoft Training, MS Access | Tagged , , , , | Leave a comment

Microsoft Access Database 2013 Splash Screen Form

Microsoft Access Database 2013 Splash Screen Form

Back in 2012, I posted an article on how to create a splash screen form without VBA code too using a little trick to name your database with an .bmp extension to it – a hidden gem!

However, in this quick video tutorial, the alternative way is to create a navigation form in Microsoft Access (from version 2010) and take advantage of the Access options and a simple macro...take a look…

Excuse the music and text narratives but hopefully you should have been able to follow the prompts?

There are other Access form options and properties to set to help present a smoother and more polished form including modal, pop-up Continue reading

Posted in Forms, Macros, MS Access | Tagged , , , | Leave a comment

Microsoft Office JavaScript Library Will Be Complete Across Office 365, iOS and Mac Early Next Year

Microsoft Office JavaScript Library Will Be Complete Across Office 365, iOS and Mac Early Next Year

Microsoft will be having a consistent JavaScript API across the Windows, Mac and mobile version of Office.

Looking at Microsoft Office development is like looking at an old tree’s cross-section – you will find different layers from different eras. Each layer is carefully maintained for compatibility. Run the just-released Word 2016, enable the Developer ribbon, click VBA, and there is Visual Basic for Applications 7.1, using traditional VB as found in the long-deprecated VB 6.0 from 1998.

microsoft access 2016 vba

Since VBA is built on COM (Microsoft’s object technology) and has fast access to the COM interfaces exposed by Office applications, VBA is well suited to automating Office. The ability to record your actions as editable VBA macros is one great feature for the developers. Apart from that, you can also write COM add-ins for Office applications in any language that supports COM, still fully supported in Office 2016. Continue reading

Posted in MS Access, VBA | Tagged , , , , | Leave a comment