Microsoft® Offic Excel® 2007 Visual Basic® for Applications Step by Step

Appendix A. A Complete Enterprise Information System

In Chapter 5, you learned how to retrieve external data into a PivotTable report; in Chapter 6, you learned how to work with graphical objects; in Chapter 7, you learned how to create loops; in Chapter 8, you learned how to create subroutines; and in Chapter 9, you learned how to use ActiveX controls and event handlers. In this appendix, you’ll see what can happen when you use Microsoft Office Excel 2007 and Microsoft Visual Basic for Applications (VBA) to put all these pieces together.

Included with the practice files for this book is a bonus application. This application is a simple enterprise information system (EIS). It uses one of Lucerne Publishing’s databases in an easy-to-use, visually ...