Tag Archives: access relational database

Access 2007 Tutorial 1.2. Tables and Relationships

Be patient with this video, it’s longer than normal (over 7 minutes) but it covers the essentials when designing and creating a relational (one-to-many) database using two tables. Keep the rules simple and I have three which I want to … Continue reading

Posted in Database Theory, MS Access, Utilities | Tagged , , , , | 3 Comments

When to Use Microsoft Access, When to Use Microsoft Excel

Tea or coffee? Shoes or trainers? Access or Excel? Life is full of different options but most of the time the decision comes down to practical requirements. If you need a shot of energy to get you through the day … Continue reading

Posted in Database Theory, Macros, Utilities, VBA | Tagged , , , , , , , , , | Leave a comment