Linux Application Development For The Enterprise (Charles River Media Programming)
Linux Application Development For The Enterprise (Charles River Media Programming)
ISBN: 1584502533
EAN: 2147483647
EAN: 2147483647
Year: 2002
Pages: 134
Pages: 134
Authors: Satya Sai Kolachina
- BackCover
- BackCover
- Definitive Guide to Excel VBA, Second Edition
- Preface
- Excel and .NET
- Why This Book?
- Enjoy
- The Idea Behind This Book
- The Example Files
- Excel XP or Excel 2002? Office XP or Office 2002?
- Part One: An Intuitive Approach
- Chapter 1: Writing Your First Macro
- 1.2 What Is Visual Basic for Applications?
- 1.3 Linking a Custom Style with a Tool
- 1.4 A Macro for Simplifying Input
- 1.5 A Simple Literature Database
- 1.6 A Form for Computing Interest in a Savings Account
- 1.7 User-Defined Functions
- 1.8 Analysis of Complex Tables
- 1.9 A Vocabulary Tutor
- 1.10 Example Programs for You to Try
- Chapter 2: What s New in Excel 2000
- 2.2 New in Excel 2000
- 2.4 New in Excel 7
- 2.5 Problems and Incompatibilities
- Part Two: Fundamentals
- Chapter 3: The Development Environment
- 3.2 The Components of the Development Environment
- 3.3 Code Input in Modules
- 3.4 Executing Macros
- 3.5 Recording Macros
- 3.6 Keyboard Shortcuts
- Chapter 4: VBA Concepts
- 4.2 Procedural Programming
- 4.3 Objects
- 4.4 Events
- 4.5 Programming Your Own Classes
- 4.6 Operators in VBA
- 4.7 Virus Protection
- Chapter 5: Techniques of Programming
- 5.2 Workbooks, Windows, and Worksheets
- 5.3 Data Transfer via the Clipboard
- 5.4 Working with Numbers and Character Strings
- 5.5 Working with Dates and Times
- 5.6 Working with Files
- 5.7 User-Defined Worksheet Functions
- 5.8 Protection Mechanisms
- 5.9 Configuration Files, Custom Configuration
- 5.10 Excel Meets the Euro
- 5.11 Tips and Tricks
- Chapter 6: Debugging, Protection When Errors Arise
- 6.2 Error-Tolerant Behavior of Programs
- 6.3 Response to Program Interrupts
- 6.4 Syntax Summary
- Chapter 7: Forms (Microsoft Forms Library)
- 7.2 User-Defined Forms
- 7.3 The Form Editor
- 7.4 The MS Forms Controls
- 7.5 Placing Controls Directly into Worksheets
- 7.6 Programming Techniques
- Chapter 8: Menus and Toolbars
- 8.2 Formatting the Interface for Freestanding Excel Applications
- Part Three: Application
- Chapter 9: Templates, Smart Forms
- 9.1 Fundamentals
- 9.2 Example: The Speedy Invoice Form
- 9.3 Example: Balance Sheet for a Car-Sharing Club
- 9.4 The Limits of Smart Forms
- Chapter 10: Charts and Drawing Objects (Shapes)
- 10.2 Programming Charts
- 10.3 Example: Automatic Data Reporting
- 10.4 Syntax Summary for Charts
- 10.5 Drawing Objects (Shapes)
- 10.6 Diagrams
- Chapter 11: Data Management in Excel
- 11.1 Fundamentals
- 11.2 Data Management Within Excel
- 11.3 Data Processing in VBA Code
- 11.4 Database Worksheet Functions
- 11.5 Consolidating Tables
- 11.6 Example: Balance Sheet for a Car-Sharing Club
- Chapter 12: Access to External Data
- 12.2 Importing External Data
- 12.3 Database Access with the ADO Library
- 12.4 Example: Evaluating a Questionnaire
- Chapter 13: Data Analysis in Excel
- 13.2 Pivot Tables
- 13.3 Programming Techniques
- Chapter 14: VBA Programming for Pros
- 14.2 Excel and the Internet
- 14.3 Smart Tags
- 14.4 Using Web Services
- 14.5 Using Dynamic Link Libraries (DLLs)
- 14.6 ActiveX Automation
- Part Four: Reference
- Chapter 15: Object Reference
- 15.2 Alphabetical Reference
- Appendix: Excel 2003 Beta 2
- What s New in Excel 2003
- Office 2003 and .NET
- List Processing
- Excel 2003 and XML (Extensible Markup Language)
- XML Programming
- Object Reference
- References
- Index
- Index_Numbers
- Index_A
- Index_B
- Index_C
- Index_D
- Index_E
- Index_F
- Index_G
- Index_H
- Index_I
- Index_J
- Index_K
- Index_L
- Index_M
- Index_N
- Index_O
- Index_P
- Index_Q
- Index_R
- Index_S
- Index_T
- Index_U
- Index_V
- Index_W
- Index_X
- Index_Y
- Index_Z
- List of Figures
Linux Application Development For The Enterprise (Charles River Media Programming)
ISBN: 1584502533
EAN: 2147483647
EAN: 2147483647
Year: 2002
Pages: 134
Pages: 134
Authors: Satya Sai Kolachina
- Using SQL Data Manipulation Language (DML) to Insert and Manipulate Data Within SQL Tables
- Performing Multiple-table Queries and Creating SQL Data Views
- Working with SQL JOIN Statements and Other Multiple-table Queries
- Understanding Transaction Isolation Levels and Concurrent Processing
- Retrieving and Manipulating Data Through Cursors