Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Microsoft Access 2010 VBA Programming Inside Out

Buy

Microsoft Visual Basic for Applications (VBA) is an exceptional programming language and environment. The language has grown out of a need to have a programming language that would allow more business-focused individuals to write programs, but equally support the programming features that developers look for in a product. The environment is as important as the language because of its unique features, allowing code to be quickly modified while being debugged.

The Access Basic language in early product versions evolved into the VBA language, which provided a cross-product language for the Microsoft Office products. This all coincided with the revolution of an event-driven approach to programming, which was very important, because the emphasis on being a programmer shifted from writing thousands of lines of code to writing snippets of code in response to events. This also led to a change of emphasis from writing large libraries of code to understanding how to manipulate the object models in the environment—a focus which has progressed with .NET, albeit using namespaces instead of object models.

Even with the introduction of object-oriented programming, VBA has kept pace with the expectations of modern programming. The two products that have shaped VBA the most are Microsoft Excel and Microsoft Access; Excel introduced VBA and originally gained VBA programming features in advance of these becoming available within Access.

A significant strength of VBA is that it is universal to the Microsoft Office suite of programs; all the techniques we describe in this book can be applied to varying degrees within the other Office products. A major turning point for these products was the ability through OLE Automation to be able to drive one product from another, and to cut and paste code between the different environments with a minimum amount of change to the code. This was a revolutionary feature introduced with the programming language of Access Basic, conforming to the new VBA standard established in Excel. VBA suddenly provided the longawaited platform for the simple integration of the Office products and building solutions that could easily exploit the strengths of each component product in the Office suite. The combination of Access and VBA offers an extremely productive environment within which to construct applications.

VBA has often been criticized for its simplicity as a language when compared to languages such as C++ and C#. Quite to the contrary, the big advantage of VBA is that this simplicity leads to more easily maintainable and reliable code, particularly when developed by people with a more business-focused orientation to programming. Looking toward the future, the emphasis in modern programming has moved from the language syntax to the intricacies of understanding the objects that the language manipulates, so the emphasis on the specific syntax of languages is starting to blur.

(HTML tags aren't allowed.)

The Gordion Wooden Objects, Volume 1 The Furniture from Tumulus MM (2 vols) (Culture and History of the Ancient Near East)
The Gordion Wooden Objects, Volume 1 The Furniture from Tumulus MM (2 vols) (Culture and History of the Ancient Near East)

"The Furniture from Tumulus MM" is a study of the furniture from the largest tomb at Gordion, Turkey, excavated in 1957 by the University of Pennsylvania Museum. The tomb dates to the eighth century BC and is thought to be the burial of the great Phrygian king Midas or his father. The objects, initially misunderstood, are now...

Hiding in Plain Sight: Steganography and the Art of Covert Communication
Hiding in Plain Sight: Steganography and the Art of Covert Communication
Your hands-on guide to understanding, detecting, and using today’s most potent tool for secret communication–steganography

These days, encryption of confidential data and communications is an increasingly important part of doing business. But steganography can take data confidentiality to a whole new level, since it hides encrypted...

Applied Structural and Mechanical Vibrations
Applied Structural and Mechanical Vibrations
This book deals primarily with fundamental aspects of engineering vibrations within the framework of the linear theory. Although it is true that in practical cases it is sometimes not easy to distinguish between linear and nonlinear phenomena, the basic assumption throughout this text is that the principle of superposition holds.

Without
...

Essential ASP.NET with Examples in C#
Essential ASP.NET with Examples in C#

"This well-conceived and well-written book has extensive knowledge and priceless experience overflowing from its pages. It captures the true essence of ASP.NET and walks the reader to a high level of technical and architectural skill."-J. Fred Maples, Director of Software Engineering, NASDAQ.com

...
Teach Yourself VISUALLY Office 2010
Teach Yourself VISUALLY Office 2010

Master the new version of Microsoft Office with this easy, visual guide

The popular Microsoft Office suite has been revamped to provide new features, including Web applications that can be accessed from anywhere and a new, streamlined Ribbon. If you learn better with visual instructions, this full-color guide is just what...

The Center for Creative Leadership Handbook of Leadership Development, Third Edition
The Center for Creative Leadership Handbook of Leadership Development, Third Edition

In one comprehensive volume, The Center for Creative Leadership provides the accumulated expertise of its faculty cultivated over the past thirty years. This revised edition includes new chapters on leadership in teams, global leadership, and leading through transitions, as well as a  new ancillary website that contains chapters that...

©2019 LearnIT (support@pdfchm.net) - Privacy Policy