Welcome to Microsoft Access Database Tutorial

Tuesday, Dec 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 Database 2013 Splash Screen Form

Microsoft Access Database 2013 Splash Screen Form

Back in 2012, I posted an article on how to create a splash screen form without VBA code too using a little trick to name your database with an .bmp extension to it – a hidden gem!

However, in this quick video tutorial, the alternative way is to create a navigation form in Microsoft Access (from version 2010) and take advantage of the Access options and a simple macro...take a look…

Excuse the music and text narratives but hopefully you should have been able to follow the prompts?

There are other Access form options and properties to set to help present a smoother and more polished form including modal, pop-up Continue reading

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

Microsoft Office JavaScript Library Will Be Complete Across Office 365, iOS and Mac Early Next Year

Microsoft Office JavaScript Library Will Be Complete Across Office 365, iOS and Mac Early Next Year

Microsoft will be having a consistent JavaScript API across the Windows, Mac and mobile version of Office.

Looking at Microsoft Office development is like looking at an old tree’s cross-section – you will find different layers from different eras. Each layer is carefully maintained for compatibility. Run the just-released Word 2016, enable the Developer ribbon, click VBA, and there is Visual Basic for Applications 7.1, using traditional VB as found in the long-deprecated VB 6.0 from 1998.

microsoft access 2016 vba

Since VBA is built on COM (Microsoft’s object technology) and has fast access to the COM interfaces exposed by Office applications, VBA is well suited to automating Office. The ability to record your actions as editable VBA macros is one great feature for the developers. Apart from that, you can also write COM add-ins for Office applications in any language that supports COM, still fully supported in Office 2016. Continue reading

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

Microsoft Access Database 2016 Is Not Included In Office 365

Microsoft Access Database 2016 Is Not Included In Office 365

Since its release, Microsoft Access database will not be available for all users of Office 365. Shocking isn’t it?

Users who have purchased an Office 365 Business Premium were surprised to discover that Access 2016 wasn’t included in their subscriptions.

Microsoft Access Database 2016 Is Not Included In Office 365

Access 2016 is not included with any of the Office 365 Business subscriptions, even in Office 365 E1 or Office 365 Pro Plus enterprise subscriptions. If you want Microsoft Access 2016 in your enterprise, you should be opting instead for the full Office 365 E3 subscription.

What is more perplexing is the fact that Microsoft Access 2016 is included in Continue reading

Posted in General | Leave a comment

Microsoft Office 2016 (Preview): First Look

Microsoft Office 2016 (Preview): First Look

This quick video tutorial doesn’t mention Microsoft Access 2016 but the general newer look and feel and functionality will follow suite and not much seems may have changed.

So in this video, the narrator must have recorded the audio on double speed or his just very enthusiastic and wants to cram in as much as possible in less than four minutes!

Microsoft Office 2016 (Preview): First Look

So what about Access 2016? There’s very little on the net to confirm what’s new (if anything).

We know VBA programming language will be retained and be known as VB7.1 which hasn’t really changed since 1998 when it was first introduced but the emphasis on web applications is realised with this release (or hopefully, that is!). Continue reading

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

Microsoft Access Database 2013 Tutorial On Forms

Microsoft Access Database 2013 Tutorial On Forms

Microsoft Access forms are ways of making your data entry convenient, safe without exposing its profound work to most database users and provide a smooth workflow reflecting business practices. The benefit of taking the time to build good and workable forms will pay dividends later.

Importing/Creating The Database

In creating an access form, the first thing you need to do is to either import or create the database. As a pre-step, follow the simple steps below:

  1. When you open your Microsoft Access 2013, select “Blank desktop database”.
  2. To import the database, go to “External Data” tab then select XML file or another file format.
  3. Browse the location where you either unzip the file or load the file and click the OK button.

Microsoft Access Database 2013 Tutorial On Forms

microsoft access database 2013 tutorial on forms

An Access Form is a customisable design object that allows users to have an accessible and easier database experience. A well-designed form supports Continue reading

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

Microsoft Access Table Relationships

Microsoft Access Table Relationships

An ideal database is free of redundant or duplicate data. To achieve that, you must split your data into many subject-based tables so each subject is presented only once. To do that in Microsoft Access, you place common fields in tables that are related. But before you do that, you must need to understand the relationships between your tables, then you can specify these relationships in your Access 2013 database.

microsoft access table relationships

In this article, I will elaborate to you the ten things you need to know about table relationships in Microsoft Access.

1. A one-to-many relationship is when one record in the parent table connects to many records in the child table.

To exemplify this, let’s take for example two tables: one for doctors and the other is for patients. A doctor can have several patients. In this case, you will Continue reading

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

Microsoft Access Database: Pass Through Queries

Microsoft Access Database:  Pass Through Queries

There are many Microsoft Access queries to choose from that will manage your database reporting requirements but there are a handful of lesser known types of queries that you may not be aware of.

One in particular is a query called ‘Pass Through Query‘ as the following short video tutorial quickly explains…

Putting aside for the heavy American accent, it clearly explains the use for this type of query and the power behind how Continue reading

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

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