Using Microsoft Access To Organise Your Life

A useful introduction video showing the ‘back-end’ tools namely Tables and Queries being designed and used. It’s only the start though and you will need to do some more research.

I like this video because it’s not been scripted or rehearsed showing how we all think when creating a table and a query with the author making decisions on the go applying changes during his presentation – great!

If you want help, please contact me for advice and how you and I can work together getting you up to speed quickly.

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”

How to set a Relationship in Access 2007

This video from YouTube shows the basic way to set and join two tables together in the relationship window viewer tool.

This gives you a clear and simple step by step instructions on how to join two tables creating a global/permanent relationship. Access then recongnises this setting and releases more functionality including the ability to expand and collapse related records in a table.