If the application and data are not kept separate there is a huge chance of data loss which we explain through examples. We also explain how separating the application from data can be of help in keeping data safe.
Out of all the precious things that we fear losing one of the most precious is important data. This data can be the one you are using for personal reasons or company data which you are responsible for managing. So if you lose the important company data, you will not only be in for...
Read more »
When you are creating new database from scratch it is important to ask key stakeholders the right questions so that the Access database can meet the requested outcomes
An Access database is not the one that is used solely for just storing large amounts of data, and using queries to get the desired information from that data. There are a lot more reasons why one would opt for using MS Access, instead of just using it as a storage options. Now if you are into designing Access databases for...
Read more »
In this article, we look at why we need to document a database during a design phase. Next, we look at the 3 stages that one needs to follow while documenting during the design phase.
It is a proven fact that if you keep on taking notes and document all things that you learn and experience, you are bound to remember them for a lot longer. This holds true for the Access codes as well. You might feel that your code has been designed well and is working well as well, but if you choose to...
Read more »