Until now. Introducing Integrating Excel and Access, a unique reference that shows you how to combine the strengths of Microsoft Excel with those of Microsoft Access. In particular, this book explains how the powerful analysis tools that Excel can work in concert with the structured storage and more powerful query from Access. But this book is not only limited to the Excel and Access. In a short time, you'll discover how to: Utilizing built in features of Access and Excel to access data Use VBA in Access or Excel to access the data connection strings using ADO and DAO Build automated Excel reports including formatting, functions, and setup page Write complex functions and queries with VBA Write simple and advanced query with Access GUI Produce pivot tables and charts with your data With Integrating Excel and Access, you can crunch and visualize data like never before.