Schmalz, Michael.

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.

9780596009731 (pbk.) 0596009739 (pbk.)


Microsoft Excel (Computer file)
Microsoft Access.


Business--Data processing.
Business--Computer programs.
Database management.

005.7565 / SCH 2006