Integrating Excel and Access
Michael Schmalz
O'Reilly Media
To help database users take advantage of the Excel spreadsheet program in the popular Microsoft Office suite and spreadsheet users become comfortable with its Access database, a Microsoft products consultant explains how to integrate the applications for customized work solutions. A sample integration project offers tips for creating business forms. The guide concludes with information on using the Visual Basic for Applications (VBA) object model to automate Excel, and a short tutorial on some basic VBA programming structures.