In this blog post we provide an analogy to help conceptualise objects, properties and methods and the way in which they interact. Most people tend to understand that if you want to change the text in a command button you…
So, what is MS Access? MS Access is a tool designed for effective data management. It is used by millions the world over and is an effective substitute for Excel when the quantity of data gets too large to control effectively. MS…
Normalization is the process of rearranging the fields and tables of a relational database to reduce data redundancy and dependency. Normalization typically consists of splitting up big tables into smaller sized (and fewer redundant) tables along with characterizing relationships between them. The objective would be to separate data to ensure that additions, deletions and alterations to a field can be made in only one table and then propagated throughout the remainder of the database through defined…
