Category Archives: Macros

Converting a Microsoft Access Database File to a MDE File or ACCDE File

Microsoft Access database applications are normally planned, designed and built using the standard single file format in either .MDB or the newer .ACCDB (Access 2007/2010) and then distributed with all the objects (Tables, Queries, Forms, Reports, Macros and Modules -VBA … Continue reading

Posted in Database Theory, Forms, Macros, Reports, Tables, Utilities, VBA | Tagged , , , , , , , , | 13 Comments

When to Use Microsoft Access, When to Use Microsoft Excel

Tea or coffee? Shoes or trainers? Access or Excel? Life is full of different options but most of the time the decision comes down to practical requirements. If you need a shot of energy to get you through the day … Continue reading

Posted in Database Theory, Macros, Utilities, VBA | Tagged , , , , , , , , , | Leave a comment

Microsoft Access 2007 Database Tutorial – Trust Center Locations

This quick two and half minute video tutorial won’t win any emmy awards for best production and script but it puts the point across clearly when users see the unwanted ‘security’ banner warning in Access 2007 (and Access 2010) and … Continue reading

Posted in Macros, MS Access, Utilities | Tagged , , , , , , , , | 2 Comments

Ready to consider upgrading to Access 2010 or Access 2007?

“Ready to consider upgrading to Microsoft Access 2010 or Microsoft Access 2007?…It may well be worth it!…” If you have been using Microsoft Access 2007 for a while now, moving to Access 2010 will be seamless and all you need … Continue reading

Posted in Forms, Macros, MS Access, Queries, Reports, Tables, Utilities, VBA | Tagged , , , , , , , | 11 Comments

What’s New with Microsoft Access 2010 Macros

The new macro interface tool is a welcome feature and well overdue! fitting nicely with the rest of Microsoft Access 2010 namely the Ribbon Bar & easy to use templates. The simple drag n drop actions and in line arguments … Continue reading

Posted in Macros, MS Access, VBA | Tagged , , , , , , , | 3 Comments

‪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 … Continue reading

Posted in Forms, Macros, MS Access | Tagged , , , , , , , , | 9 Comments

Microsoft Access Databases – Learning the Fundamentals

The Access database application provides a rich set of powerful tools ranging from a simple database design model to the multi-user network version using Access’s administrative tools at all levels which include the Relationship Window, Database Splitter, Linked Manager Tool … Continue reading

Posted in Database Theory, Forms, Macros, MS Access, Queries, Reports, Tables, Utilities | Tagged , , , , , , , , , | 23 Comments

Microsoft Access 2007 New Look Tutorial

When Microsoft Access first appeared in the early 1990′s it revolutionized the desktop database market. Most versions have been similar to each other. Now with Access 2007 we see the most radical changes yet introduced by Microsoft. When working your … Continue reading

Posted in Database Theory, Forms, Macros, MS Access, Queries, Reports, Tables, Utilities | Tagged , , , , , , , | Leave a comment