Welcome to Microsoft Access Database Tutorial

Wednesday, Jul 01, 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 Validation Rules In Tables

Microsoft Access Validation Rules In Tables

A validation rule restricts or controls what a user can input in a table field. You can think of it as a set of layers which ensures that your users input data properly.

Here’s a quick video tutorial to get you going and very easy to apply.

Microsoft Access provides several ways to validate data: data types, field sizes, table properties, and input masks. Among these, table properties provide specific types of data validation.

One example is setting the required property to YES which results to forcing the users to enter a value in that specific field.

Another technique is by using the Validation Rule property to require specific values, and the Validation Text property to alert your users to any errors. For example, putting a rule such as Continue reading

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

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.

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

Posted in Database Theory, MS Access, Tables, Utilities | Tagged , , , , | 2 Comments

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