In this article, we are going to discuss in detail how effective relationship tables can be designed in MS Access and discuss 3 best practices for building them.
One of the key skills you need to learn to make sure that your Access databases perform well is the art of building effective relationships. These relationships not only make your Access databases more comprehensive but also easier to manage. As a user of the application, you might feel that it is easy to create relationships and it...
Read more »
As an Access developer, it is imperative that you re-use code. In this article, we give you 7 solid reasons to use the Access database library
As a developer, you would know that it is not uncommon for the same code to be repeated in multiple forms and procedures. This is what makes re-using a same code inevitable. For a professional programmer, making use of the same code is not only time saving, but also safe. As you already know how it would perform when applied, thus reducing the risk...
Read more »
In this article, we discuss the how switchboards work and come handy for users in MS Access. We also discuss 3 ways to overcome inherent limitations.
An Access database consists of lots of objects, manually going over each of those objects is not just time-consuming, but also confusing. For navigating across Access objects like forms and reports you can make use of the Switchboard provided to you in the application. This is one of the greatly useful and reliable navigation tools for...
Read more »
