Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
 
Home > Courses > Access > Expert > X17 > < X16 | X18 >
Back to Access Expert 17    Comments List
Course Ideas Upload Images   Link   Email  
Michael      
9 years ago
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.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Expert 17.
 

 
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 7/19/2024 7:22:55 AM. PLT: 0s