This old chestnut, probably the most common scenario of all for students to undertake as a project within databases and yet in the vast majority of schools it will simply be taught incorrectly with just 3 tables. You need 5 tables at the core of it to make it actually "work" and this series of screencasts and footage of my and my family badly acting out how a DVD hiring shop works endeavors to explain how to do this project properly.

Note the videos for this project were made a fair few years ago and I use Access 2003 to build the database, however I have not re-done them as there is not really any difference expect the interface design in Access 2007/10. The techniques are basically the same.

film 1 - what data to store?   vid 1 - simple DVD table  film 2 - don't type it in twice  vid 2 - genre & certificates  film 3 - unique identifier  vid 3 - DVD copy table  vid 4 - customer table  film 4 - break up order table  vid 5 - orders and items  vid 6 - forms part 1

vid 7 - forms part 2  vid 8 - combobox  film 5 - someone forgot something  vid 9 - combobox again  vid 10 - query  vid 11 - compound key  vid 12 - conditional formatting  vid 13 - receipt  vid 14 - adding to the receipt

canada-generic.com