Tag Archives: primary key

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 … Continue reading

Posted in Database Theory, Queries, Tables | Tagged , , , , , , , | 2 Comments

How to Utilise and Apply Access Database Normalisation Techniques

Access Database Normalisation levels 1, 2, 3; geting 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 … Continue reading

Posted in Database Theory, MS Access, Tables | Tagged , , , , , , | 8 Comments

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 … Continue reading

Posted in Database Theory, MS Access, Tables, Utilities | Tagged , , , , , , | 1 Comment