| Publisher | OReilly Media | ||
|---|---|---|---|
| Format | 539.6KB PDF | Date added | 20 Oct 2005 |
| Topics | Programming Languages, Application Development, Spreadsheets | ||
| Downloads | 122 | ||
VBA gives one the opportunity to take more control of the data; it performs queries that are not possible from the user interface, and one can now automate many operations. There are numerous situations when VBA is not only the preferred way to obtain data, but the only way. For example, one may run into situations in which one wants to control access to the data by the time of day or another variable. Giving the user the ability to pull the data straight from the user interface limits the ability to restrict access to that data. One does not want people running queries that join a table with several hundred thousand customer records and a couple million financial transactions during the middle of the day.
Did you find this white paper useful?
7 out of 22 users found this white paper useful
Related white papers
Market-Leading Data-Modeling Tools: Research Report from the Burton Group
The Burton Group provides an in-depth research report on Market-Leading Data-Modeling Tools. According to their research, basic data modeling tools have become commoditized - basic features are yesterday's...
The Converging Paths of SQL Server and SharePoint - Don't Wait Until It's Too Late!
SharePoint and SQL server have much in common, and understanding their similarities will help you streamline your day-to-day tasks and help you work more efficiently. Do you know what those...
Supporting Employees Anytime, Anywhere
New business demands require a new approach to end-user support. This is leading organizations to a remote service delivery model that leverages the Web and Saas technology
The Pursuit of a Standardized Solution for Secure Enterprise RBAC
Each RBAC implementation varies in its capabilities and method of management. In a multi-platform environment, these differences introduce higher administration hours and costs because the various RBAC models are not...
Combining the Power of Rhapsody Model-Driven Development, UML and Hitex Tools to Streamline the Development of 8, 16, and 32 Bit Applications
Studies have shown that software is now the main bottleneck for most embedded systems projects. According to Embedded Market Forecasters, 56% of all embedded designs are behind schedule, and software...
Massive But Agile: Best Practices for Scaling the Next-Generation Enterprise Data Warehouse - Forrester Report
Information and knowledge management (I&KM) professionals continue to expand the scale, scope, and deployment roles for their enterprise data warehouse (EDW) investments. Information managers are adopting EDW best practices that...
Intel Premier IT Magazine
Access bottom line best practices from Intel IT for your client fleet in the Intel Premier IT magazine
