welcome to the new office access

If you're a newcomer to Microsoft Access, you'll be amazed to discover how powerful it is. Yet, you don't have to be an experienced database administrator to take full advantage of its many capabilities.

Providing you with a whole series of prebuilt applications, Access can get your database modeling off to a quick start and will allow you to rapidly modify your design to adapt to changing business requirements.

And if you're an experienced developer you're sure to be impressed by the new features in Access 2007. Things like automatic field creation, WYSIWYG forms design and multivalue fields are going to make your life a lot easier!

news flash!

access2010 We got caught in the now familiar conundrum - how to keep up with software version upgrades!

Before we've had time to complete the Access 2007 course tutorials, Microsoft has come out with Access 2010.

So, to keep up with the times, we've created a new course: Microsoft Office Access 2010 so that our tutorials can stay as relevant as they have been.

Fortunately for us, and for you, there do not seem to be major changes in the versions, especially at the beginner level where we are now. The interface is similar enough that there is no way you can get lost while editing your database.

Access 2010 still uses the Access 2007 format for the database structure. Therefore, even a database created with Access 2010 can be opened with Access 2007 and vice versa.

Here's what we strongly recommend:
to learn the basics of relational databases and Access tools, go through our older Access 2003 course.

Then, take a look at the Access 2007 course that you see here. Do the practice assignments, download the samples and create whatever new databases you need for your own use.

Once you've done all that, go over to the new Microsoft Office Access 2010 course where you'll find the continuing tutorials along with updated samples and db's.

Now, let's get back to our lessons and ENJOY LEARNING!

the access 2007 interface

Like the other members of Microsoft Office, Access makes full use of the new Ribbon interface that Microsoft introduces in Office 2007. The Ribbon is a region at the top of the screen that presents an easy-to-browse main set of commands for a particular program.


The new UI will take some getting used to. But it is so useful and well presented that even hardcore fans of the old ways will soon be won over.

The main window has a tabbed work area where all open objects reside, helping to keep the development area clean and tidy. Additionally, there are no windows hidden under other windows, so it's much easier to keep track of open documents and applications. To make things even simpler, from the nearly 1,000 available commands, the new UI displays only those relevant to the task you are performing at any given moment. And the new status bar, scroll bars, and title bar give applications built on Access 2007 a very modern look.

Microsoft Office Access 2007 helps knowledge workers start tracking information quickly, create meaningful reports with ease, and share data more securely using the Web. Its new library of pre-built solutions & new information-sharing capabilities let you track and report information with ease. The prebuilt database solutions allows you to modify and adapt them to your changing business needs.

Now, if you're ready to start learning:

go to Microsoft Access 2007 tutorials