Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.

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.

Charles E. Brown (New Milford, NJ) has been a computer trainer and consultant for 21 years. In the process he has developed and delivered training for many of the 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 new Microsoft .NET environment. In addition he delivers programming training in Java for Learning Tree International. Brown has taught VBA to many beginner programmers as well has having done VBA programming for Swiss Bank Corporation, the US Government, NASA and Price Waterhouse Accounting. Brown is the author of Fireworks MX From Zero to Hero and Beginning Dreamweaver MX. He was also a contributor to the Macromedia Studio MX Environment.

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