Welcome to Microsoft Access Database Tutorial

Friday, Aug 22, 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

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 , , , , | 5 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

Microsoft Access Database Names and Reserved Word Problems

Microsoft Access Database Names and Reserved Word Problems

Designing your Microsoft Access database requires a plan, some dedicated time and vision, and without some scope for your new database, you can easily fall at the first hurdle when building and implementing a system with the lack of attention to detail of using key names and reserved words.

Some of the reserved names and words can be used depending where it’s being utilised but some will prompt you with a warning as being ambiguous because they are properties of forms, reports, sections, tables, or global names and constants from the Application object and the DAO, ADODB and VBA libraries.microsoft access database reserved names and words

Because it would not be practical to provide a full list of all reserved names and words, like built-in function names, VBA constant keywords or Continue reading

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

How To Run Microsoft Access On A Mac PC Using CrossOver Software

How To Run Microsoft Access On A Mac PC Using CrossOver Software

You might find this a little strange but I generally prefer Mac to Windows as not all my work is purely Microsoft Access. However, working on Access requires a Windows instance and though I have several computers set up, my Mac Pro also has Access installed using CrossOver Software Installer.

Here’s a quick two minute video tutorial on How To Run Microsoft Access On A Mac which I found to explain the installation process…

This is just one way to get Continue reading

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

Concatenating Multiple Rows Into Single Line In MS Access

Microsoft Access Database: Concatenating Multiple Rows Into Single Line In MS Access

Now I’m not going to take credit for this next piece of Microsoft Access database VBA code as it was originally created by a well-known Allen Browne – many thanks!

Instead, I’m going to borrow his code for you (my regular readers) just in case you haven’t seen this before and add an element of quickly adding criteria to a query as a workaround to avoid expanding the VBA code itself.

concatenating multiple rows into single line in ms access

There are potential problems and errors this code will throw at you if you try to add criteria in the normal manner or embed any SQL directly into the calling custom function which means using some common sense and logic to deal with the challenge here.

Microsoft Access Database: Concatenating Multiple Rows Into Single Line In MS Access

First of all, let’s get the function to work and the query understood. In a new module, you will need Continue reading

Posted in Functions, Modules, Queries, VBA | Tagged , , , , | Leave a comment

Microsoft Access Database – Working With Two Digit Hour Time Formats

Microsoft Access Tutorial – Working With Two Digit Hour Time Formats

Here’s a quick Microsoft Access tutorial video I found about applying formatting to the date/time data type control concentrating on the two digit hour time format that doesn’t always show up in two digit form.

Even if you create a custom date/time format within Microsoft Access, the two-digit hour which is supported using the convention of “hh” via the format property doesn’t always work. It will show a single digit hour even though you’ve specified the right code. Take a look at the video below.

Microsoft Access Tutorial – Working With Two Digit Hour Time Formats

In the video tutorial, it mentioned one of three ways to Continue reading

Posted in Forms, Microsoft Training, MS Access, Tables | Tagged , , , , | 1 Comment

How To Create A Running Totals Query In Microsoft Access

How To Create A Running Totals Query In Microsoft Access

If you wanted to calculate a running sum (or a cumulative total) for a report; this is simply set by using the correct ‘Running Sum‘ property for a selected control like a numeric bound field (text box) and all you need to do is decide whether this will be over a group or the whole report.

However, this doesn’t exist in a query and to mimic the report feature to recreate running totals query in Microsoft Access, you will need to be a little creative!

running totals query in microsoft accessEven though MS Access queries you do have a ‘group by’ and ‘where clause’ features where you can choose one of the aggregate functions, there is Continue reading

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

Microsoft Access Form Designs: Using VBA With On Timer Event

Microsoft Access Form Designs: Using VBA With On Timer Event

This Access form will self-destruct in 10, 9, 8, 7….

Using the unknown or unused Timer Event for your Microsoft Access form designs can be quite effective and really automate your background processes.

I was recently asked if this application has a timer control which one could illustrate as a count down or trigger code on a set time.

microsoft access form design on timer

You can show a real time count down by using basic controls like a text box or launch another form (or report) or even Continue reading

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

How To Add A Flash Movie SWF File To A Microsoft Access Form

How To Add A Flash Movie SWF File To A Microsoft Access Form

Working with Microsoft Access form designs requires patience and a plan especially when wanting to work with other form controls over and above the standard tools made available by default.

One particular ActiveX control is the ‘Shockwave Flash Object‘ which will allow you to play flash video (or SWF file formats) in an Access form.

Adding A Flash Movie To A Microsoft Access Form

You will need to first load the library file if not added or enabled in order to render this control ready for use. That means Continue reading

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