Tag Archives: Access Help

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 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