Integrating Excel and Access
Publisher: O'Reilly Media
Final Release Date: November 2005
Pages: 236

In a corporate setting, the Microsoft Office Suite is an invaluable set of applications. One of Offices' biggest advantages is that its applications can work together to share information, produce reports, and so on. The problem is, there isn't much documentation on their cross-usage. Until now.

Introducing Integrating Excel and Access, the unique reference that shows you how to combine the strengths of Microsoft Excel with those of Microsoft Access. In particular, the book explains how the powerful analysis tools of Excel can work in concert with the structured storage and more powerful querying of Access. The results that these two applications can produce together are virtually impossible to achieve with one program separately.

But the book isn't just limited to Excel and Access. 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

With Integrating Excel and Access, you can crunch and visualize data like never before. It's the ideal guide for anyone who uses Microsoft Office to handle data.

Table of Contents
Product Details
About the Author
Colophon
Recommended for You
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
oreillyIntegrating Excel and Access
 
4.0

(based on 6 reviews)

Ratings Distribution

  • 5 Stars

     

    (1)

  • 4 Stars

     

    (4)

  • 3 Stars

     

    (1)

  • 2 Stars

     

    (0)

  • 1 Stars

     

    (0)

Reviewed by 6 customers

Sort by

Displaying reviews 1-6

Back to top

 
4.0

Molto utile

By lsprea

from Italy

Comments about oreilly Integrating Excel and Access:

Per chi é in cerca di un libro di livello medio che non perda pagine e tempo a rispiegare le basi ma vada dritto al punto. Vengono forniti tutti gli elementi base dell'integrazione access-excel.

(1 of 1 customers found this review helpful)

 
4.0

Just what I needed!

By RonJ

from Undisclosed

Comments about oreilly Integrating Excel and Access:

Great book that really helps with pulling in Access data from Excel (or the other way). After a few hours of working with the examples and trying the methods using my own data, I have developed a macro that greatly speeds up a monthly chore, and it has opened my eyes to other analyses and time saving opportunities also.

The book delivers as promised.

 
4.0

Emphasis of this book

By Anonyme

from Undisclosed

Comments about oreilly Integrating Excel and Access:

Clearly the author approaches his subject from the Excel side in the first few chapters at least, and I concur with the opinion expressed that the title is therefore misleading. That the book should be awarded fewer stars on that basis alone is another matter.

(3 of 3 customers found this review helpful)

 
5.0

You NEED this book if....

By oracle database goddess

from Undisclosed

Comments about oreilly Integrating Excel and Access:

After seeing one reviewer give the book one star because of his opinion that it had more excel than access emphasis, I had to write a review. I find this book outstanding in showing how to integrate the two. I am a very seasoned IT person but not so much with access and excel though I have written some VBA and Access apps lately. This book was just what I needed to develop an application using Access/Excel and Word.

As an Oracle/Unix person, I appreciate being able to read this book cover-to-cover and know how to write a relatively complex application I've been tasked with as one of my "other-related duties". Thanks for this lifesaver!

(0 of 1 customers found this review helpful)

 
3.0

Nice book, terrible index

By cassiodorus

from Undisclosed

Comments about oreilly Integrating Excel and Access:

Nice book but the index is terrible! It doesn't cover the topics. Good grief ... 'link, 'span' and how many others are just not in the index. Time to get a good editor or just use a program that at least looks at the topics that are part of the book markup (now there's an idea ...).

 
4.0

Nice book to get good analysis

By Aamir

from Undisclosed

Comments about oreilly Integrating Excel and Access:

Very nice effort. I much recommend others to use it if you want to analyze your data with little effort.

Thanks

Aamir

Displaying reviews 1-6

Back to top

 
Buy 2 Get 1 Free Free Shipping Guarantee
Buying Options
Immediate Access - Go Digital what's this?
Ebook: $31.99
Formats:  DAISY, ePub, Mobi, PDF
Print & Ebook: $43.95
Print: $39.95