Access VBA Programming - Charles Brown,Ron Petrusha

Introduction

Examines how to expand the capabilities of Access by simple programming in VBA
Perfect for power users who want to maximize the capabilities and efficiency of Access
Sample codes guide reader through projects that are practical and useful
Caught up in the Web--Access? macro capability integrates well with the countless programmers working in web-based environments

About the book

Take a look at this great application of VBA and learn to expand the capabilities of Access with simple programming. Author Charles E. Brown shows you step-by-step how to create your own code, work with Object-Oriented Programming, and more. Plus, discover and utilize key programming concepts that can be applied beyond VBA.

Key features

Easy to understand guide to programming with VBA allows the reader to do basic programming right away

Sample codes guide reader through projects that are practical and useful

Examines fundamental programming principles using VBA, and demonstrates ways to expand the capabilities of Access

Addresses key programming concepts that can be applied beyond VBA

About the authors

Charles E. Brown (New Milford, NJ) has been a computer trainer and consultant for nearly 21 years. In the process he has developed and delivered training for many Fortune 500 companies including Exxon, Johnson & Johnson, RJR Reynolds/Nabisco, and the US Government. He has trained such diverse topics as Microsoft environment and the Microsoft .NET environment. In addition, he delivers programming training in Java for Learning Tree International. He has taught VBA and has done VBA programming for Swiss Bank Corporation, the US Government, NASA, and Price Waterhouse Accounting.

Table of contents

Part I: Understanding the MS Access Environment
1 Introduction to VBA for Applications
2 Designing an Access Application
3 Access Development Without VBA
4 Customizing the Access Environment
Part II: Understanding the Visual Basic for Applications Environment
5 Introducing the VBA Programming Environment
6 Programming Fundametals Using VBA
7 Understanding the Visual Basic Editor
8 VBA Language Components
9 Sub Procedures
10 Debugging VBA Code
11 Function Procedures
Part III: Interacting with VBA
12 Forms
13 Reports
14 Menus and Toolbars
15 Changing the Access Environment
Part IV: Advanced Access Programming Techniques
16 Database Security
17 Access and the Microsoft Office Environment
18 Access and the Web
19 Upgrading
Part V: Application Development
20 Multiuser Applications
21 Beyond Microsoft Access
Appendix The DoCmd Object