Chapter Summary

This chapter describes how to build an Access database and automatically generate a Word document, an Excel workbook, a PowerPoint presentation, and an Outlook message from the database information. You can use the procedure that iterates through the records in a table in the database as a basis for any program that needs to access data in an Access database. You can also use this procedure to access the database from any Office application. Therefore, you can, for example, develop add-ins for any Office application that can retrieve data from a database. With your solutions, you might want to provide a menu item that when clicked retrieves data from a database and uses it to insert or manipulate document content.