Integrating Excel and Access

BANGALORE, INDIA: This unique reference shows you how to combine the powerful analysis tools of Excel with the structured storage and more powerful querying of Access. It covers everything you need to know, including interfaces, object models, and code. Learn how to crunch and visualize data like never before. Perfect for all Microsoft Office users.

There's also a chapter on SQL Server, as well as one dedicated to integrating with other Microsoft Office applications. In no time, you'll discover how to:

    * Utilize the built in features of Access and Excel to access data

    * Use VBA within Access or Excel to access data

    * Build connection strings using ADO and DAO

    * Automate Excel reports including formatting, functions, and page setup

    * Write complex functions and queries with VBA

    * Write simple and advanced queries with the Access GUI

    * Produce pivot tables and charts with your data

Click here to know more...!