Beginning Access 2002 VBA (Programmer to Programmer)
Beginning Access 2002 VBA (Programmer to Programmer)
ISBN: 0764544020
EAN: 2147483647
EAN: 2147483647
Year: 2003
Pages: 256
Pages: 256
- Table of Contents
- Back Cover
- Beginning Access 2002 VBA
- Introduction
- The Structure of this Book
- How is Access Changing?
- Who is this Book For?
- What Does this Book Cover?
- What You Need for this Book
- The Book s CD
- Exercise Solutions
- Conventions
- Customer Support
- Chapter 1: Designing Applications
- What Is an Access Application?
- The Development Process
- The Ice Cream Shop Application
- Macros Or VBA?
- Summary
- Exercise
- Chapter 2: Introduction to Event-Driven Programming
- The VBA IDE
- Adding Intelligent Navigation Buttons to the Company Contacts Form
- Adding to the User Interface
- Summary
- Exercises
- Chapter 3: Creating Code
- Procedures
- Modules
- Subroutines and Functions
- Naming Conventions
- Procedure Declaration
- Built-In Functions
- Variables
- Constants
- Intrinsic Constants
- Variable Scope and Lifetime
- Summary
- Chapter 4: Controlling the Program
- Programming Structures
- Repetition
- Arrays
- Summary
- Chapter 5: Using Access Objects
- Object Oriented Programming
- Object Models
- Access 2002 Objects
- The AccessObject Object
- Forms and Reports
- Referring to Objects
- Special Objects
- The Object Browser
- Summary
- Exercises
- Chapter 6: Using DAO
- The DAO Hierarchy
- Working with Recordsets
- Summary
- Exercises
- Chapter 7: Data Management Techniques
- The Challenge - Flexibility vs. Manageability
- The Requirement - Ad Hoc Query Functionality
- Creating and Modifying DAO QueryDefs
- Two Approaches to Displaying Results
- Summary
- Exercises
- Chapter 8: Working with Tables
- Working with Tables
- Sub Datasheets
- Summary
- Exercises
- Chapter 9: External Data
- Other Applications
- Text Files
- XML
- Electronic Mail
- Using External Data
- Summary
- Exercises
- Chapter 10: Reports
- Starting Off
- Page Numbers
- IIf
- Dates
- Summarizing
- Expressions
- Events
- Filters
- Summary
- Exercises
- Chapter 11: Advanced Programming Techniques
- Arrays
- Arguments
- Dynamic Link Libraries (DLLs)
- Custom DAO Properties
- Summary
- Exercises
- Chapter 12: Finding and Dealing with Errors
- Planning for Errors
- Compiling
- Testing
- Types of Errors
- Debugging
- Error Handling
- Debugging your Debugging Code
- Summary
- Exercises
- Chapter 13: Using Classes
- Class Modules and Custom Objects
- Forms as Class Modules
- Collections - Creating a Hierarchy
- Getting the Most from Class Modules
- Summary
- Exercises
- Chapter 14: WithEvents and RaiseEvent
- Event Review, Some Terms and Facts
- What is WithEvents?
- Why Use WithEvents?
- RaiseEvent
- Summary
- Exercises
- Chapter 15: Libraries and Add-Ins
- Library Databases
- Class Libraries
- Add-Ins
- Summary
- Exercises
- Chapter 16: Automation
- What Is Automation?
- Object References
- Creating Automation Objects
- Microsoft Outlook
- Microsoft Word
- Microsoft Excel
- Summary
- Chapter 17: Multi-User
- Multi-Developer Issues
- Record Locking in Access 2002
- Security
- Compiling
- Summary
- Exercises
- Chapter 18: The Internet
- The Internet
- Data Access Pages and Access XP
- XML
- Uploading Data
- Summary
- Exercises
- Chapter 19: Optimizing Your Application
- Efficiency
- Reducing Memory Overhead
- Increasing Execution Speed
- Increasing Apparent Speed
- Network Considerations
- Finishing Touches
- Summary
- Exercises
- Chapter 20: Moving to Client-Server
- What is Client-Server?
- Jet vs. SQL Server: Why Move?
- Access Data Projects
- Creating an Access Data Project
- Installing SQL Server Desktop Engine
- Running the Upsizing Wizard
- Results of Upsizing the IceCream Database
- SQL Server Objects
- Fixing the Queries
- Forms
- When you have No GUI
- Summary
- Chapter 21: ActiveX Data Objects - ADO
- What is ADO?
- Summary
- Exercises
- Appendix A: Access Object Model
- Method Calls
- Appendix B: Access Events
- Appendix C: ADO 2.7 Object Model
- Command Object
- Connection Object
- Error Object
- Errors Collection
- Field Object
- Fields Collection
- Parameter Object
- Parameters Collection
- Properties
- Property Object
- Recordset Object
- Constants
- Method Calls Quick Reference
- Appendix D: Microsoft DAO 3.6 Object Library Reference
- Connection
- Connections
- Container
- Containers
- Database
- Databases
- DBEngine
- Document
- Documents
- Error
- Errors
- Field
- Fields
- Group
- Groups
- Index
- Indexes
- Parameter
- Parameters
- Properties
- Property
- QueryDef
- QueryDefs
- Recordset
- Recordsets
- Relation
- Relations
- TableDef
- TableDefs
- User
- Users
- Workspace
- Workspaces
- Constants
- Method Calls
- Appendix E: ODBC and IIS
- Web Servers
- index__Numbers
- index__Symbols
- index_A
- index_B
- index_C
- index_D
- index_E
- index_F
- index_G
- index_H
- index_I
- index_J-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-Z
Beginning Access 2002 VBA (Programmer to Programmer)
ISBN: 0764544020
EAN: 2147483647
EAN: 2147483647
Year: 2003
Pages: 256
Pages: 256