Welcome to Microsoft Access Database Tutorial

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.

As a Thank You for Visiting…

Claim Your Free eBook NOW!

Enjoy and thank you for visiting!

How To Design An Access Database: Take The First Step And Plan It

How To Design An Access Database: Take The First Step And Plan It

It’s that time of year again where new students need ‘real world’ induction and training and that sometimes includes Microsoft Access.

But the very first step in learning how to use MS Access is to have a database application in mind and in order to know how to design an Access database.

Here’s a quick (four and half minutes) video tutorial to help explain the concepts. Take a look…

httpvh://www.youtube.com/watch?v=aBhK61KMqYs

How To Design An Access Database: Take The First Step And Plan It

You will find most database systems are typically based Continue reading “How To Design An Access Database: Take The First Step And Plan It”

Building An Access Database: The Planning Stages

Building An Access Database: The Planning Stages

The quickest way the building an Access database application is to use the wizard and template tools available which are a breeze! But you need to have some idea of what type of database you are going to end up with a bit of planning first.

To help you along, I have written seven articles (courtesy of EzineArticles) to help explain the database methodologies further.

building an access database

Building An Access Database: The Planning Stages

Take a look at the Continue reading “Building An Access Database: The Planning Stages”

Microsoft Access Tutorial: Hiding Access Tables As 'USYS' System Tables

Microsoft Access Tutorial: Hiding Access Tables As ‘USYS’ System Tables

Hiding tables (or any object) in your Access database is a simple enough process. You only need to set the objects hidden property (to True) and reveal the ‘Hidden Objects’ setting from the navigation pane options screen.

But in this quick Microsoft Access tutorial here, there is another method of stopping your tables appearing in Navigation pane (or Database window) by renaming the table(s) with the prefix USYS. This will convert your table into a system object, which cannot be viewed in the normal environment.

microsoft access tutorial usys tables

In the Navigation pane’s options screen (Access 2007 & 2010), you have two display options the called Continue reading “Microsoft Access Tutorial: Hiding Access Tables As 'USYS' System Tables”

Access 2007: Get up to speed

microsoft access screeshot video

Watch video here

A great overview for new users to Access as wells as for users migrating from the earlier versions of Microsoft Access (2003, XP, 2000, 97!).

This video tutorial makes it look easy to create and manage an Access database because it really is easy to do so!

This quick guide can also apply to the later version of Microsoft Access (2010) though the ‘Office‘ button has now been replaced with a ‘File‘ tab taking you to the ‘Backstage‘ environment.

You will need to get up to speed on how to build more in depth tables, queries, forms and reports as well as understand database terminology and methodologies including how relational databases work (rdbms).

Take a look at my eBook offers.

Here’s a brief history of Microsoft Access

Here’s a brief history of Microsoft Access just in case you wish to step back and reminisce

A brief history of Microsoft Access

Late 1992, Microsoft released the first version of Access (version 1.0) desktop database application for the Windows operating system and was shortly replaced with version 1.1 in mid 1993 to incorporate better compatibility with other Microsoft Office products of that time and more importantly introduce the ability for programmers to code this application using Access BASIC.

Version 1.1 was buggy! and had performance issues and in the same year Microsoft released Windows 3.1 operating system along with Microsoft Office 4.3 Pro (suite of applications including Excel, Word, PowerPoint with Access – version 2.0) as it required the improved hardware, software memory and the power supported by Windows 3.1.

This was an ideal desktop database application tailored to the small to medium sized business that required a low cost database. At that time, the capacity of a disk hardrive was less than 100 MB (mega bytes) and typical document file sizes were in the 100’s of bytes. Continue reading “Here’s a brief history of Microsoft Access”

‪Microsoft Access 2010 – How to Create a Navigation Form‬

This video is a good advert that shows some of the new features – adding a navigation form with tabs that allows you to move between other forms replacing the conventional menu manager tool from previous versions.

It also gives you a quick overview of how sleek looking this version is compared to earlier versions (not so much Access 2007 but earlier) and how interactive the Ribbon Bar is to the selected item (object) with dynamic previews when formatting the components.

New users to Microsoft Access will find this a pleasing application to work with but be warned the learning curve is a little steep at first but with determination and persistence, you will be able to master this application much quicker than perhaps its predecessors.

By the way! You can always engage in a training session (or two) with me to learn Microsoft Access in quick time.

Planning an Access Database – Video

This video from YouTube takes you from the very beginning even before working with the actual database application which is often overlooked when designing and planning an Access database.

It’s a good guide to help relate how you actually would use and benefit from any database in the ‘real world’ making this a very human and user friendlier approach and best of all it’s ‘geek’ speak and jargon free!