Richard,

Since you are always encouraging us to send you ideas for future courses, here are a couple of ideas for your consideration. First, you might consider putting together a seminar on queries with particular emphasis on multiple table queries and all the things that can go wrong. We've used multiple table queries throughout the Expert series, but I think that it would be really good to take a deep dive into what is happening behind the scenes inside of Access - having this insight would make users much more confident I think. I would include an entire session on bad queries - for example, ambiguous outer joins and Cartesian products. I think there is just so much you can do with queries to make a solid class or seminar.

Along the same lines, I think you could make a class covering validation. It's one thing to build a database, but as you know, a database without good validation rules in place (for example, the ship date can't be before the order date; the invoice date can't be before the order date;) is just a recipe for disaster. You could easily use your order table for some of these things.

Food for thought. As always, thanks to you and Alex and the entire team working behind the scenes to bring us these great videos and fantastic instruction.

---

Reply from Alex Hedley:

Have you seen the Outline for the SQL Seminars?
I can't remember if all of those are covered but they would be a very addition if they aren't.

Validation Rules are covered in Expert 28.

Thanks for the kind words and suggestions, it's a pleasure being able to help out.