Integrating Excel and Access

Combining Applications to Solve Business Problems

Nonfiction, Computers, Application Software, Spreadsheets, Financial Applications, General Computing
Cover of the book Integrating Excel and Access by Michael Schmalz, O'Reilly Media
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart
Author: Michael Schmalz ISBN: 9780596553319
Publisher: O'Reilly Media Publication: November 1, 2005
Imprint: O'Reilly Media Language: English
Author: Michael Schmalz
ISBN: 9780596553319
Publisher: O'Reilly Media
Publication: November 1, 2005
Imprint: O'Reilly Media
Language: English

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.

View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart

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:

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.

More books from O'Reilly Media

Cover of the book Head First Web Design by Michael Schmalz
Cover of the book UX for Lean Startups by Michael Schmalz
Cover of the book Perl Pocket Reference by Michael Schmalz
Cover of the book Search Patterns by Michael Schmalz
Cover of the book Flash CS5.5: The Missing Manual by Michael Schmalz
Cover of the book Office 2011 for Macintosh: The Missing Manual by Michael Schmalz
Cover of the book Word 2007 for Starters: The Missing Manual by Michael Schmalz
Cover of the book Head First jQuery by Michael Schmalz
Cover of the book Das Buch zu Raspberry Pi mit Linux by Michael Schmalz
Cover of the book Python Pocket Reference by Michael Schmalz
Cover of the book Designing for Behavior Change by Michael Schmalz
Cover of the book Tastenkürzel für Mac kurz & gut by Michael Schmalz
Cover of the book Learning ASP.NET 2.0 with AJAX by Michael Schmalz
Cover of the book Web Development with Node and Express by Michael Schmalz
Cover of the book RaphaelJS by Michael Schmalz
We use our own "cookies" and third party cookies to improve services and to see statistical information. By using this website, you agree to our Privacy Policy