Help get this topic noticed by sharing it on Twitter, Facebook, or email.
Thanks for writing us. Yes, Access 2007: The Missing Manual does cover advanced topics. I think Part V: Programming Access would be useful to you. It contains these three chapters:
Chapter 15: Automating Tasks with Macros
Chapter 16: Automating Tasks with Visual Basic
Chapter 17: Writing Smarter Code
Chapter 17 discusses using conditional statements and loops, debugging and error handling.
You can check out the table of contents and search the book itself in the book's Google Preview.
Let us know if you have more questions.
Have a great day!
O'Reilly Media, Inc.