fbpx
Logo
Mail us
ben@accessdatabasetutorial.com
Home » Posts tagged "access database normalisation"

Tag Archives: access database normalisation

Microsoft Access Database Design Concept – Step 2 of 7


MS Access Macro

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 , you may want to lay […]

Tags: , , , ,

Microsoft Access Database Design Concept – Step 1 of 7


MS Access Macro

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. […]

Tags: , , , ,

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: Eliminate redundant information Increase data integrity Make systems more efficient Modern databases should be in BCNF Boyce-Codd Normal Form which is deemed to be at […]

Tags: , , , , , ,