Microsoft Excel & Access integration with Office 2007 - Alexander, Michael 1972-; Clark, Geoffrey 1970-. (Indianapolis, IN Wiley Pub., 2007)
Getting Excel data into Access -- Analyzing Excel data with Access queries -- Sprucing up Excel data with Access reports -- Using pivot tables and pivot charts 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 with office applications.
Includes index.
Keywords: Microsoft Excel (Computer file).; Microsoft Access; Microsoft Office; Business -- Computer programs; Database management