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

Pro SharePoint 2007 Development Techniques
Pro SharePoint 2007 Development Techniques
The landscape of doing SharePoint development has changed considerably in the last year, with the release of SharePoint Server 2007 and its related technologies. You need a contemporary reference to stay on top of the latest ways to combine .NET development techniques with your SharePoint development techniques, and SharePoint 2007 Development...
Jump Start CSS: Get Up to Speed With CSS in a Weekend
Jump Start CSS: Get Up to Speed With CSS in a Weekend

This short SitePoint book provides readers with a fun and yet practical introduction to Cascading Style Sheets (CSS), the language used to style and lay out all web pages. This book will quickly get you up to speed with the fundamentals of CSS and give you the confidence to start experimenting on your own.

It covers:

...
Survivability and Traffic Grooming in WDM Optical Networks
Survivability and Traffic Grooming in WDM Optical Networks
Technological advances in semiconductor products have essentially been the primary
driver for the growth of networking that led to improvements and simplification
in the long-distance communication infrastructure in the twentieth century.Two
major networks of networks, the public switched telephone network (PSTN) and the...

Getting Started with SQL Server 2014 Administration
Getting Started with SQL Server 2014 Administration

Optimize your database server to be fast, efficient, and highly secure using the brand new features of SQL Server 2014

About This Book

  • Design your SQL Server 2014 infrastructure by combining both onpremise and WindowsAzurebased technology
  • Implement the new InMemory OLTP database engine...
Proceedings of the 20th Congress of the International Ergonomics Association (IEA 2018): Volume IV: Organizational Design and Management (ODAM), ... in Intelligent Systems and Computing)
Proceedings of the 20th Congress of the International Ergonomics Association (IEA 2018): Volume IV: Organizational Design and Management (ODAM), ... in Intelligent Systems and Computing)

This book presents the proceedings of the 20th Congress of the International Ergonomics Association (IEA 2018), held on August 26-30, 2018, in Florence, Italy. By highlighting the latest theories and models, as well as cutting-edge technologies and applications, and by combining findings from a range of disciplines including...

Domain-Driven Design Using Naked Objects
Domain-Driven Design Using Naked Objects

Domain-driven design (DDD) focuses on what matters in enterprise applications: the core business domain. Using object-oriented principles, you can develop a domain model that all team members-including business experts and technical specialists-can understand. Even better, this model is directly related to the underlying...

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