Beginning Access™ 2007 VBA

11.7. Summary

This chapter introduced several advanced topics, including declaring and using standard and external DLLs, using automation to control other applications, and adding ActiveX controls to forms. I also covered how to create custom code libraries, how to use add-ins, and how to implement transactions in your code. Each one of these topics could warrant an entire chapter. For more information on these topics, please consult Access 2007 VBA Programmer's Reference (Wiley, 2007). In this chapter, I just wanted to provide you with some ideas of the advanced features available to your Access applications without giving you a detailed tutorial on how to actually implement each of them.

At this point you're ready to move on to Chapter 12, which covers various steps you should take to finish up your Access application, including improving performance and multiuser considerations, adding security to the application, and distributing the application. I will then finish the book with two comprehensive case studies that will bring all the concepts discussed throughout the book together into two real-world applications.