Microsoft Access Database Design Concept – Step 2 of 7

This is the most important step and is the process I refer to as Reverse Engineering!

The best way to build the Access database architecture correctly is start with the end result The Reports! by sketching out what reports you want to end up with. After all, database systems are there to serve and we want information please!

As an exercise, if you were migrating from a paper based system or an older database system Continue reading “Microsoft Access Database Design Concept – Step 2 of 7”

Microsoft Access Database Design Concept – Step 1 of 7

Working with Microsoft Access designing a new database, the question here is what is the core process of the database that you are trying to define? Access Database design is more of an art than a science and common sense will prevail.

By taking the time to identify the core process correctly, you will find that additional processes will plug in easily keeping the structure of the system stable and solid enough as time goes by and data volume increases. If you apply some of Microsoft Access techniques Continue reading “Microsoft Access Database Design Concept – Step 1 of 7”

How to Utilise and Apply Access Database Normalisation Techniques

Access Database Normalisation levels 1, 2, 3; getting normal about it!

The process of Database Normalisation was developed by E.F.Codd who is widely considered the father of relational database theory.

There are several rules which provide theoretical structures and disciplines which are not always practical to follow but help provide the main goals which are:

  1. Eliminate redundant information
  2. Increase data integrity
  3. Make systems more efficient

Modern databases should be in BCNF Boyce-Codd Normal Form which is deemed to be at third normal form of which there are considered to be five in all. This article focuses on what I believe is considered a good balance to applying some of these rules and covers up to the third norm of database normalisation.

Continue reading “How to Utilise and Apply Access Database Normalisation Techniques”