In these pages, I will teach you how to set up tables andrelationships to ensure that the database is properly normalized.Then I’ll help you write VBA code to create the connectivetissue that turns a bunch of tables, queries, forms, and reportsinto a complete and coherent application. We’ll pay specialattention to the important but often inadequately documented areaof Automation code, which is used to communicate with other Officeapplications.
Over years of working with Access, I’ve created someadd-ins to save time when developing applications. I’ll showyou how to use them to create a main menu for an application,automatically apply a naming convention to database objects, andensure a consistent and professional appearance of theapplication’s forms.
This book helps you write VBA code that unites databasecomponents into an application that works.
What you will learn from this book
Who this book is for
This book is for experienced Access users who are familiar withcreating Access objects and writing VBA code, but who need helptransitioning from competent users/programmers to full-fledgedAccess developers.
Wrox Expert One-On-One books present the wisdomaccumulated by an experienced author who is recognized as an expertby the programming community. These experts challenge professionaldevelopers to examine their current practices in pursuit of betterresults.