Welcome to Microsoft Access Database Tutorial

Friday, Jul 31, 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: Next Generation of Spreadsheets

Microsoft Access Database: Next Generation of Spreadsheets

Bringing your Microsoft Access database application into the current online digital age started with the need for this integral tool for small and medium sized businesses way back in the 1990’s.

WordPerfect, Lotus 1–2–3, and dBase are the three software products that dominated the software market for a long period in the history of personal computing. WordPerfect is used for word processing; Lotus 1–2–3 is a spreadsheet program from Lotus Software; and dBase is a database management system for microcomputers.

During the early days of personal computing, spreadsheets and databases coexisted because there was a clear designation of responsibility between the two models.  During those times, the use of spreadsheets were mainly for financial modelling. While databases were intended for everything organization-related.

Spreadsheets and word processors offered the benefits of simplicity and direct manipulability. Databases were never as manageable as word processors and spreadsheets. The main drawback in using databases was in the technical implementation complexity of the software.

Microsoft Access Database Next Generation of Spreadsheets

As a result, average users began using spreadsheets as provisional databases.
After many consultations with dozens of Excel clients, it became clear that almost all of them were using the product not for the purpose of financial modelling but as a conventional tool for making tables instead.

At this point in time, the office productivity perspective had also shifted from a multiplayer market to one subjugated by Microsoft, which put down Lotus 1–2–3 and dBase with its own Excel and Access database products. The growing grey area between spreadsheets and databases gave Continue reading

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

Microsoft Access Database Functions

Microsoft Access Database Functions

This is something I have touched on briefly in the past with an article called Microsoft Access Functions which introduced you to the popular functions and the tool to generally browse for other not so popular function calls.

So as a revisit to this topic, there’s no point describing each and everyone that’s at your disposal – that would be silly as we all have different uses for our Access databases but instead you can find a full list (by category) by going to Microsoft’s Office Access Functions (by category) page instead.

microsoft access database functions office

Microsoft Access Database Functions

It clearly states that this page contains links to articles that provide details about common functions used in expressions in Microsoft Access.

They are arranged first by Continue reading

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

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 , , , , | 2 Comments

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