Mail us
Home » Posts tagged "access normalisation"

Tag Archives: access normalisation

Microsoft Access Database Versus Excel – Which To Choose?

Microsoft Access

Microsoft Access Database Versus Excel Why Access? Why Excel? In the modern age, ‘the books’ are done digitally. Individuals and businesses alike use software like Microsoft Excel to do a bunch of database stuff… – but strangely, bizarrely, bafflingly, Microsoft Access database remains a highly underused product in the Microsoft Office package.  There seems to be a general misconception about Access and Excel, with many people believing Excel to be both easier and more applicable to their needs. Databases vs Spreadsheets So what’s the […]

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: , , , , , ,