Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Integrating Excel and Access

Buy
Integrating Excel and Access, 9780596009731 (0596009739), O'Reilly, 2005

The Microsoft Office Suite is, in my opinion, the most useful set of applications in a corporate setting. Besides being easy to use and practically perfecting the "What-You-See-Is-What-You-Get" (WYSIWYG) display, the applications in Microsoft Office can work together to share information, produce reports, etc. The problem is that while there are many references available to help users develop their skills in any of the applications, there are few references available to show how to use the applications together. I did quite a bit of integration work as both a consultant and employee at various companies, and I quickly found those skills in demand in many departments—from Human Resources to Operations to Finance. As people asked me to do things that I had never done before and I figured out how to do them, I began building a base of code and knowledge that I could use to solve problems. I kept thinking, "I wish there were a book that could show me how to..." and then, when I had figured out how to do those things, I thought, "I could write that book."

Based on my experience, Microsoft Access and Microsoft Excel allow for the most benefit from integration, so this book focuses mainly on these applications. In addition to Access and Excel, I have included a chapter on SQL Server and a chapter on integrating with other Microsoft Office applications. In each topic, I show how integrating features in different applications can solve problems. Although the examples use rather generic data, you will be able to apply the same concepts to your own data.

The difficulty in writing a book like this lies in tailoring the skill level to fit a wide audience. For example, many of the Excel GUI features might seem very basic to some readers, while they are new to others. In addition, some readers might be very comfortable with Visual Basic for Applications (VBA), and others may have anywhere from no experience with VBA to experience only using the macro recorder. As much as possible, I have tried to build from the basics to the complex when covering each topic. I hope that you will be neither bored nor overwhelmed as you go through the topics.

(HTML tags aren't allowed.)

Troubles of Journalism: A Critical Look at What's Right and Wrong With the Press
Troubles of Journalism: A Critical Look at What's Right and Wrong With the Press
This book looks at criticisms of the journalism profession and evaluates many of the changes in journalism--both positive and negative. In addition, it suggests what the many changes mean for this nation and indeed for the world at large, as American journalism--its methods and standards--has markedly influenced the way many millions overseas...
Buying a Home: The Missing Manual
Buying a Home: The Missing Manual

Home ownership is a cornerstone of the American dream, but it's a complex process that, without the right guidance, can seem like a nightmare. This Missing Manual takes you through the process of buying a home, from start to finish. Along the way, you'll use the book's expert advice and fill-in forms to identify the house...

Financial Cryptography and Data Security: 15th International Conference, FC 2011
Financial Cryptography and Data Security: 15th International Conference, FC 2011

This volume contains the proceedings of the 15th International conference on Financial Cryptography and Data Security, held at the Bay Gardens Beach Resort, St. Lucia, February 28–March 4, 2011.

Financial cryptography and data security (FC) is a well-established international forum for research, advanced development,...


Object-Oriented Design with UML and Java
Object-Oriented Design with UML and Java
Provides a fully road tested integrated introduction to object-oriented design and implementation issues using UML and Java

Unified Modeling Language (UML) is a general-purpose programming language for specifying and visualizing complex software, especially large, object-oriented projects. Object-oriented programming is when
...
New Computational Paradigms: Changing Conceptions of What is Computable
New Computational Paradigms: Changing Conceptions of What is Computable
In recent years, classical computability has expanded beyond its original scope to address issues related to computability and complexity in algebra, analysis, and physics. The deep interconnection between "computation" and "proof" has originated much of the most significant work in constructive mathematics and mathematical...
High Performance Browser Networking: What every web developer should know about networking and web performance
High Performance Browser Networking: What every web developer should know about networking and web performance
How prepared are you to build fast and efficient web applications? This eloquent book provides what every web developer should know about the network, from fundamental limitations that affect performance to major innovations for building even more powerful browser applications--including HTTP 2.0 and XHR improvements, Server-Sent Events...
©2020 LearnIT (support@pdfchm.net) - Privacy Policy