Microsoft Access VBA Programming for the Absolute Beginner - page 1
- BackCover
- BackCover
- BackCover
- Access VBAProgramming
- Introduction
- Who Should Read This Book?
- Part I: Understanding the MS Access Environment
- Chapter 1: Introduction toVBA for Applications
- History of Microsoft Access
- Developing in Access
- The Future of Microsoft Access
- Summary
- Chapter 2: Designing anAccess Application
- Steps in the Development Process
- Definition and Analysis of Requirements
- Evaluation of Requirements
- Development of the Design
- Implementation and Testing
- Documentation
- Maintenance
- Summary
- Chapter 3: Access DevelopmentWithout VBA
- System Architecture
- Understanding a Database Application
- Working Without VBA
- Events
- Naming Conventions
- Predefined Templates
- Switchboard Manager
- Summary
- Chapter 4: Customizing theAccess Environment
- Customizing Shortcut Menus
- Creating Menus
- Attaching Code to a Custom Menu Item
- Summary
- Part II: Understanding the Visual Basic forApplications Environment
- Chapter 5: Introducing the VBAProgramming Environment
- Introduction to VBA
- The VBA Model
- The Concept of Objects
- The VBA Editor
- Summary
- Chapter 6: Programming Fundamentals Using VBA
- Control Structures
- Arrays
- Summary
- Chapter 7: Understanding theVisual Basic Editor
- Highlights of the Menu System
- The Debug, Edit, and UserForm Toolbars
- The Project Explorer
- Managing Modules
- Properties Window
- The Object Browser
- References
- Using VBA Editor Options
- Getting Help
- Starting a New Procedure in the VBA Editor
- Summary
- Chapter 8: VBA LanguageComponents
- Objects in VBA
- Intrinsic Constants
- Basic VBA Programs Using Forms
- Connecting with Microsoft Access
- SQL (Structured Query Language)
- SQL and VBA
- Output
- Summary
- Chapter 9: Sub Procedures
- Declaring a Procedure
- Functions
- Parameters
- Design and Scope
- Global and Static Variables
- Using Procedures to Change a Database Structure
- Summary
- Chapter 10: Debugging VBACode
- The Err Object
- The Errors Collection
- Tools for Debugging Code
- Summary
