Welcome to Microsoft Access Database Tutorial

Thursday, Dec 18, 2014

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

Access Database Tutorial is 4 Years Old

Access Database Tutorial is 4 Years Old – This Week!

I can’t believe it, Microsoft Access Database Tutorial is 4 years old this week!

Spending the time to create a website offering various tools, resources and free tips and tricks was really down to my students which I’m very grateful to them for inspiring me to create a successful online service and it’s been an amazing journey so far but where has the time flown? 4 Years on!

microsoft access database tutorial 4 years old

With all the newer applications and online web processes of today, Microsoft Access has kept up at a reasonable level too with SharePoint and better collaboration but ultimately it’s the power of the desktop version with the power of Access VBA that really can’t be Continue reading

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

Microsoft Access Tutorial – How to use Input Masks

Microsoft Access Tutorial: How to use Input Masks

Microsoft Access databases provide a wealth of tools and utilities to help control design layouts and data integrity. Working with the latter, you can reduce and even dismiss any programming at all to control data entry to a field in a table or via a form using the Access Input Mask feature.

Take a quick look at this useful Microsoft Access tutorial (using version 2010) on how to set up an input mask.

Very easy to create indeed and the video covers the pre-set options which to be honest is based on the US style conventions for Continue reading

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

Microsoft Access Queries: Difference Between The Where Clause And the Having Clause

Microsoft Access Queries: Difference Between The Where Clause And the Having Clause

Within the framework of using Microsoft Access queries, the HAVING clause can only be used with the GROUP BY type SQL statement which is also referred as the Groups and Totals query. The HAVING keyword when not used with the GROUP BY statement acts as a standard WHERE clause.

The HAVING clause specifies a condition that is similar to the purpose of a WHERE clause when  applying criteria but the two clauses are not interchangeable.

microsoft access queries difference between the where clause and the having clause

The key difference between these two keywords is Continue reading

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

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

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

Microsoft Access Database – My Very Own Custom Built Utilities

Microsoft Access Database – My Very Own Custom Built Utilities

This time of year and over the last few weeks, we get new users or students entering the Microsoft Access database arena from people of various walks of life whether that is a student learning about IT and computer based systems or starting a new job or career wanting to brush up on their skills that I like to remind all of my custom built utilities which serves more than one objective.

microsoft access database custom built utilities

The tools I offer are not free but they do come with a money back guarantee and 30 day email support so you can at least try and ask questions. The main point to Continue reading

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

Microsoft Access Update Queries: An Action Query

Microsoft Access Queries: An Action Query

I witnessed a cardinal sin of one person manually editing the same value across multiple records instead of using one of Microsoft Access queries well known action query; the update query.

Take a quick look at this preview video which is seven minutes long and covers the essentials (and ignore the title with reference to programming in 2013 – not applicable here).

In this video, the author mentions the exact match (in double quotations marks) when setting the criteria as well as Continue reading

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

Microsoft Access Database: Working With A Database You Didn’t Create

Microsoft Access Database: Working With A Database You Didn’t Create

Working with Microsoft Access database is a skill to have and makes you stand out from the crowd of advanced Excel spreadsheet users and those wishing to step up and move into the world of MS Access will probably start by inheriting other people’s databases.

So what’s the first thing you need to do if you are given someone else’s Access database?

microsoft access database working with a database you didnt create

I wrote another post about a couple of years ago which addressed the challenges of inheriting other people’s Microsoft Access databases and Continue reading

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

Microsoft Access Database: 5 Settings To Avoid With Microsoft Access Options Causing You Headaches

Microsoft Access Database: 5 Settings To Avoid With Microsoft Access Options Causing You Headaches

Here’s an article I wrote some time ago but is worth a revisit since the newer generation of users tend not to be always aware of the background tasks Access sometimes insists on performing…

When I first started to use Microsoft Access (back in 1993) which was then version 1.1 and quickly moved to the newer version of 2.0, you had various options available that could be set to change the behaviour of how you viewed and ran the basic objects. It probably took you no more than 15 minutes to discover, read (in the help files) and apply all settings that Microsoft Access databases had to offer – job done, never having to return to this area again!

Microsoft Access Database: 5 Settings To Avoid With Microsoft Access Options Causing You Headaches

Move forward 20 plus years and working with Access version 2013 you now have to either employ an individual to study and constantly refine the permutations of how Microsoft Access will work, behave and look. Okay, I may have exaggerated a little about employing and individual but your get the point! You need to Continue reading

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

Microsoft Access Database Forms: Highlight Current Record For A Continuous Form

Microsoft Access Database Forms: Highlight Current Record For A Continuous Form

As you migrate from version to version, working with Microsoft Access database forms becomes more intuitive and easier to design and implement using the pre-built templates, wizards and improving richer set of formatting tools.

Conditional formatting (once it was introduced) started life as a setting for up to three conditional formats which satisfied most requirements but now the with the later versions, it’s layered and can exceed this number for true flexibility and complex conditioning.

microsoft access database forms highlight current record

The point here is what level of setting conditional criteria for this format do you know?

In this simple example, mixing some Access VBA code into the mix and using just one condition, you get Continue reading

Posted in Forms, MS Access, VBA | Tagged , , , , | 12 Comments

Sending Email Using Microsoft Access VBA

Sending Email Using Microsoft Access VBA

If you use the later versions of Microsoft Access, you will have probably come across the tool to set and manage emails to normally Microsoft Outlook from a selected table or query and select individual valid records but this can be problematic with connection, server and services if not correctly configured.

There is a custom built solution which talks about sending email using Microsoft Access though it is not a free utility, it does have a free locked demo to evaluate and the following video (5 mins) explains a bit more about it…

If you are feeling brave enough, you can build your own version and in fact the author Continue reading

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