Integrating Excel and Access /
Michael Schmalz.
- Sebastopol, CA : O'Reilly, c2006.
- xiii, 216 p. : ill. ; 24 cm.
Includes index. "Combining applications to solve business problems"--Cover.
Introduction to Access/Excel integration -- Using the Excel user interface -- Data access from Excel VBA -- Integration from the access interface -- Using access VBA to automate Excel -- Using Excel charts and pivot tables with access data -- Leveraging SQL server data with Microsoft Office -- Advanced Excel reporting techniques -- Using Access and Excel data in other applications -- Creating form functionality in Excel -- Building graphical user interfaces -- Tackling an integration project.