If you are developing databases for your own use, the process need not be complicated. But when you build databases for clients, many of whom may not be familiar with Access or comfortable with databases in general, you have a lot more work to do. Expert One-on-One Microsoft Access Application Development makes that process easier.

In these pages,聽you discover聽how to set up tables and relationships to ensure that the database is properly normalized. Then you write VBA code to create the connective tissue that turns a bunch of tables, queries, forms, and reports into a complete and coherent application. You also find out about the important but often inadequately documented area of Automation code, which is used to communicate with other Office applications.

Over years of working with Access,聽the author聽has created some add-ins to save time when developing applications. She shows you how to use them to create a main menu for an application, automatically apply a naming convention to database objects, and ensure a consistent and professional appearance of the application’s forms.

This book helps you write VBA code that unites database components into an application that works.

What does this book cover?

Here's what you'll discover in this book:

• How to build integrated Access-based applications that support multiple clients and databases
• Tips for streamlining application creation
• Maintenance required throughout an application’s life cycle, including migrating data from legacy systems and upgrading Office
• How to use Automation code to exchange data among Office components and even some non-Office programs
• Ways to avoid glitches when building Access applications that work with Excel, Word, and Outlook

Who is this book for?

This book is for experienced Access users who are familiar with creating Access objects and writing VBA code, but who need help transitioning from competent users/programmers to full-fledged Access developers.What is this book about?

Expert One-on-One Microsoft Access Application Development teaches Access developers best practices for building effective Access-based applications. Written by Helen Feddema — a well-known expert on Microsoft Access — this book provides a wealth of hidden tips and tricks for mastering Access development.

What does this book cover?

The book is divided into three parts, each centered around a separate case application. The first shows best methods for building a relatively simple Access application using the developer's own data. The next section shows how to build a distributed application serving multiple clients and types of data. The chapters in this section cover each step in the application lifecycle — from gathering application requirements from clients to migrating data from legacy systems to the new Access database system.

The last section of the book shows how to build Access applications that work with other Office applications, inlcuding Word, Excel, and Outlook, as well as non-Office applications. These integration issues cover some of the thorniest problems an Access developer will face. Feddema's years of experience as an author, consultant, and trainer ensure that she can provide highly original solutions and workarounds.