Welcome to Microsoft Access Database Tutorial

Saturday, May 23, 2015

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

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

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

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

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

Microsoft Access Database 2013: Building A Navigation Control Form

Microsoft Access Database 2013: Building A Navigation Control Form

This quick three and half minute video tutorial will demonstrate how easy it is to build Microsoft Access database navigation control forms keeping the controls and property settings to a minimum whilst also utilising the ribbon bar too…

There’s no voice over but some light melodic tones to easily follow the tips and techniques in building that navigation control form.

Microsoft Access Database 2013: Building A Navigation Control Form

Of course, one assumes you have also pre-prepared and built either the forms or reports that will be linked and associated to each tab added which Continue reading

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

Microsoft Access Queries and How Important They Are in Your Database

Microsoft Access Queries and How Important They Are in Your Database

The heart of any MS Access database system resides with the queries and I’m often asked to give new users a quick overview of this powerful application – here’s an example…

A Microsoft Access Database is a desktop application which stores large amounts of data and is able to recognize relationships between those data. It consists of data and tools that enable users to manipulate that data. 

Microsoft Access Queries eBook previiew

One of these tools are the queries. Microsoft Access Queries are used specifically to organize data on the Access database.

A database can hold multiple tables. Each of the tables can have hundreds of thousands of records. How the user extracts a specific section of Continue reading

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

Microsoft Access Database Versus Excel – Which To Choose?

Microsoft Access Database Versus Excel – Which To Choose?

Why Access? Why Excel?

In the modern age, ‘the books’ are done digitally. Individuals and businesses alike use software like Microsoft Excel to do a bunch of database stuff… – but strangely, bizarrely, bafflingly, Microsoft Access database remains a highly underused product in the Microsoft Office package.  There seems to be a general misconception about Access and Excel, with many people believing Excel to be both easier and more applicable to their needs.

microsoft access database versus excel image

Databases vs Spreadsheets

So what’s the difference between the two? Microsoft Access is a database, not just a large spreadsheet like Excel. Both have their uses and only the situation can dictate the need for one over the other. Excel is generally more convenient for crunching numbers and producing figures and graph that represent technical data. Access, however, is able to store a huge amount of data – far more than in any one spreadsheet. Additionally, Excel Continue reading

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

Microsoft Access Queries: Some Pointers To Building Those Reports

Microsoft Access Queries: Some Pointers To Building Those Reports

Database developers have admired Microsoft Access because it’s scalable and user friendly (for a development application that is) and provides a good ‘one-stop‘ shop balance for database management meeting small and medium sized company needs.

I have always harked on about the key to a good database is in the query and just in case you are not yet familiar with Microsoft Access queries, here is just a little bit of information.

What are Access Queries?
Well the simple answer is…

"Access, I have a question for you!"

…It then goes off and finds the answer.

In other words, a query is simply an instruction or request for a report or some other form of output of information.

The language it uses to communicate and ask that question of your data is known as SQL (Structured Query Language) and it uses this SQL query syntax to provide answers very quickly indeed.

microsoft access queries some pointers

The advantage with Microsoft Access database queries however, is that there is no requirement to learn the language at all as it Continue reading

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

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

Posted in General | Tagged , , , , | 2 Comments

Microsoft Access Database Tutorial – Selecting Unique And Distinct Values In A Query

Microsoft Access Database Tutorial – Selecting Unique And Distinct Values In A Query

There are many different types and ways to run queries that your Microsoft Access database application provides and one useful ms access query is where you can create a distinct or unique value list from duplicate or repeating values from other records.

Check out this 4 minute video tutorial which clearly explains two ways to create a unique value query report.

As the video shows, you can use either the property sheet to select unique value or the SQL statement approach using the keyword Distinct. In fact, an extension to Continue reading

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

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