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 »
While it is quite easy to Link tables in Access, Managing them is entirely a different ballgame. Here we look at critical steps which are needed to manage them effectively
Managing Access databases and managing split Access databases is different yet similar to a great extent. Irrespective of whether the database you are using is split or not, you need to make sure that it is working effectively at all times. This will require you to manage your databases well. Now you might feel that after...
Read more »
