The most revolutionary version in the desktop databases models is the Access 2007. It is the world’s most popular desktop database and you will probably notice it has similar features to the previous Access versions. The major change in the new version is the changed menus and toolbars. You will either love it or hate it. It might take some time to get used to it though. The new system consists of tab series and every tab has a number of commands related to the particular task. For example, if you want to create a new form, report or table you would go to the “Create” tab. Commands are grouped together and there are different icons for creating split form, sub forms or using a form wizard and so on.

It has become much easier to create forms. All you do is highlight the table and click on a particular icon which will create a basic form instantly. The same thing could be done with reports.

There one additional view to the form except for the design view and the datasheet view. It is called the layout view. This option will let you design your report or form while seeing the actual data in it.

One more useful feature of the new Access version is the calendar. In the previous version you had to set a reference to a calendar to use it. Then you had to write a code which is not easy for everybody. Now all you have to do is to create a table field with the date data and then drag the table field to the form and whenever you click in the field a calendar icon will show up. Then you just select a date from the calendar and it is added to the field.

If you had a habit of securing your database with user and workgroups permissions you don’t have to lose that opportunity. Now you can set up a password on the database for security. But, if you want to provide better security then you should transfer the back end tables to SQL server. Unfortunately, the Access security wasn’t ever perfect and there were problems with losing or corrupting the workgroup files. But there are also some other nice features in the new version of the program such as the ability to send Access form via Microsoft Outlook. When you receive the reply, Microsoft Outlook will add the results right into the Access automatically. This is a great option for getting survey results in bulk.

With all the new features and touches in the new version of Microsoft Access, it will be a great tool for any individual or business that will help increase productivity levels.

Everything about microsoft access database: great training info, all sorts of business products (customized for your needs), special microsoft access database blog with hints, tips and tricks about MA databases.

All this and more from a reputable UK based company which majors at microsoft access database and is helping clients all over the world.