What Does this Book Cover?

Beginning Access 2002 VBA Programming covers everything that you need to gain the confidence to go away and experiment on your own. Programming is an art and cannot simply be taught - like anything worth doing in life, it's a question of "practice makes perfect". This book will provide the necessary information to get you up and running, and will show you enough interesting and practical examples to whet your appetite and ensure that your experiences of VBA don't end with the last page of the book.

After looking at application design, we will examine event-driven programming and what it really means in terms of programming Access. We'll then introduce you to the coding environment and basic principles such as variables , controls structures, data types, and procedures. We'll also look at objects and classes within Access, which will help you to get the best from your code.

Once we have some solid foundations to build on, we'll start to look at how to use VBA in a more practical sense, looking at how to create recordsets and other objects at run time, how to import and export data, and how to work with reports . We'll also look at some issues that you must bear in mind when programming any application, for example, errors - including what they are, how to find them, how to correct them, and, most importantly, how to prevent them.

In the latter part of the book, we'll take a look at some more advanced topics, such as working in a multi- user environment, using libraries and add-ins, and using automation with other applications. Finally, we'll look at applying the finishing touches to add that final polish to your application.