Microsoft Excel & Access integration with Office 2007:
Saved in:
Bibliographic Details
Main Author: Alexander, Michael (Author)
Format: Electronic eBook
Language:English
Published: Indianapolis Wiley Pub. c2007
Subjects:
Online Access:Volltext
Item Description:Includes index
Getting Excel data into Access -- Analyzing Excel data with Access queries -- Sprucing up Excel data with Access reports -- Using PivotTables and PivotCharts in Access -- Getting Access data into Excel -- Leveraging macros in Excel and Access -- VBA fundamentals -- Using VBA to move data between Excel and Access -- Exploring Excel and Access automation -- Integrating Excel and Access with XML -- Integrating Excel and other Office applications
Offering step-by-step instruction, this invaluable book shows readers how to save time and enhance data analysis and reporting capabilities by combining the abilities of Excel and Access.; While both Excel and Access are powerful tools on their own, combining the functionality of these two applications opens up a whole new world of possibilities.; In addition to demonstrating a wide range of integration techniques, the book also provides practical, real-world scenarios that illustrate ways to avoid common pitfalls when moving and analyzing data across applications.; Shows readers how integrati
Physical Description:1 Online-Ressource (xx, 388 p.)
ISBN:9780470171394
0470171391
9780470104880

There is no print copy available.

Interlibrary loan Place Request Caution: Not in THWS collection! Get full text