This Microsoft Access tutorial follows a step-by-step approach to the creation and development of a commercial database application.

We'll start with database modeling. That means that you have to design the database before you actually start to write it. There are several basic techniques that must be learned to ensure that the database structure will be solid. Design is an absolutely essential part of creating a database.

If you're already past the rookie stage and you want to delve deeper into the database modeling aspect, even before you start with Access, you might want to take a look at our Database design and SQL language tutorial. In a normal sequence of courses, SQL would be the next database subject you would learn after Access. Whereas Access is meant for the smaller user, SQL lets you into the domain of the power-user.

Once we're done with the design we'll develop the objects one by one and learn how to use them.

As we go along we'll use a simple application to illustrate the power of Microsoft Access in business. The application is a Video Rental Store and it's well suited to showing how a small businees could put into practice all these notions of management with databases.




After this Microsoft Access tutorial, you may want to go on to bigger and better databases such as Oracle, SQL Server or MySQL. The training you get from this tutorial will qualify you for the more advanced stuff.

You may also want to look at connecting your Microsoft Access database to a Visual Basic application.

We have a very popular tutorial on Visual Basic 6 which has a module on database connectivity.
You'll find it at: Visual Basic 6 and ADO Database programming tutorial.
We hope that by seeing all the different applications in context, you will begin to appreciate the usefulness of these tools.

By the end of this Microsoft Access tutorial, you will have made a good start towards becoming a full-fledged business applications programmer.

Welcome to the club!

This is fantastic! Don't miss it!
Visual Basic 6 is a great complement to Access.
Study VB 6 to master the techniques of writing VBA code in your database applications.
Take a look at Free VB 6 tutorials and samples.

The new Microsoft Office Access 2007 is here!
You just have to take a look at this.
New crisp, clear Ribbon interface. Lots of new templates.
It's now easier than ever to get your database application off and running.
This is just a start. There's a lot more coming in the next few weeks and months.
Check out this new tutorials site.
Microsoft Access 2007 Database tutorials