What You’ll Learn:
- Queries 101: Learning the basics
- Comparison operators: what they are and how to use them
- How to build a query on a query
- Using joins in queries
- User input parameters
- How to make the dreaded "Null ..." disappear
- How to use groupings to sum up and total
- Steps for using functions in queries
- Delete, update, append — Oh my!
- Formatting a query for printing
About Your Trainer: Craig Aulick
Craig Aulick has gained a well-deserved reputation among his students as the one teacher they want to learn MS Access tips, tricks, and techniques from. Craig has an almost-unheard-of ability to make
the most dry or complex material easy to understand. And, more importantly for you, he shows you exactly how to implement all these strategies immediately in your work.
Among his many clients are Citibank, IBM, State Farm, Proctor & Gamble, the FBI, the CIA, the IRS, and the White House, so you can be confident that Craig knows Access as well as anyone not working
at Microsoft! And, as a Technical Services specialist, he developed MS Access databases for customer call tracking and inventory control for one of his biggest clients.
But the one thing that makes Craig stand out from most of his computer-training colleagues is his sense of humor. Craig will disarm you with his training style, but what you'll come to find out is that
all the time you've been laughing and enjoying yourself, you've been learning how to make MS Access work for you — not against you!