Taylor's Library

Normal view MARC view ISBD view

Integrating Excel and Access / Michael Schmalz.

By: Schmalz, Michael.
Publisher: Sebastopol, CA : O'Reilly, c2006Description: xiii, 216 p. : ill. ; 24 cm.ISBN: 9780596009731 (pbk.); 0596009739 (pbk.).Subject(s): Microsoft Excel (Computer file) | Microsoft Access | Business -- Data processing | Business -- Computer programs | Database managementDDC classification: 005.7565
Contents:
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.
Item type Current location Shelf location Call number Copy number Status Notes Date due Barcode
Main Collection Taylor's Library-TU

Floor 3, Shelf 1 , Side 1, TierNo 5, BayNo 6

 005.7565 SCH 2006 (Browse shelf) 1 Available GENLS,GENLS,03,GR 5000126868

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.