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


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.)

Formulas and Functions with Microsoft Office Excel 2007 (Business Solutions)
Formulas and Functions with Microsoft Office Excel 2007 (Business Solutions)
“If you’ve never quite grasped formulas and functions, Paul McFedries will radically expand your understanding and use of Excel. And if you’re already an expert and you’re moving up to Excel 2007, this book will quickly show you features you’ve only dreamed of until now...”


PostgreSQL High Performance Cookbook
PostgreSQL High Performance Cookbook

Get to know effective ways to improve PostgreSQL's performance and master query optimization, and database monitoring.

About This Book

  • Perform essential database tasks such as benchmarking the database and optimizing the server's memory usage
  • Learn ways to improve query...
Python Recipes Handbook: A Problem-Solution Approach
Python Recipes Handbook: A Problem-Solution Approach

Learn the code to write algorithms, numerical computations, data analysis and much more using the Python language: look up and re-use the recipes for your own Python coding. This book is your handy code cookbook reference. Whether you're a maker, game developer, cloud computing programmer and more, this is a must-have reference for your...

Beginning Data Science in R: Data Analysis, Visualization, and Modelling for the Data Scientist
Beginning Data Science in R: Data Analysis, Visualization, and Modelling for the Data Scientist
Discover best practices for data analysis and software development in R and start on the path to becoming a fully-fledged data scientist. This book teaches you techniques for both data manipulation and visualization and shows you the best way for developing new software packages for R.

Beginning Data Science in R...
Microsoft ®  Office 2007 Business Intelligence
Microsoft ® Office 2007 Business Intelligence
Microsoft Office has been the standard against which all other integrated office products have been measured since 1995. Throughout the years, we’ve watched Office, as everyone now knows it, go from being a somewhat simplistic word processor and spreadsheet to include capabilities such as desktop publishing, sophisticated e-mail and schedule...
Daniel Arbuckle's Mastering Python
Daniel Arbuckle's Mastering Python

Key Features

  • Covers the latest and advanced concepts of Python such as parallel processing with Python 3.6
  • Explore the Python language from its basic installation and setup to concepts such as reactive programming and microservices
  • Get introduced to the mechanism for rewriting code in a...
©2018 LearnIT (support@pdfchm.net) - Privacy Policy