Expert One-on-One Microsoft Access Application Development (PDF)

What is this book about?If you are developing databases for your own use, the processneed not be complicated. But when you build databases for clients,many of whom may not be familiar with Access or comfortable withdatabases in general, you have a lot more work to do. ExpertOne-on-One Microsoft Access Application Development makes thatprocess easier.In these pages, you discover how to set up tables andrelationships to ensure that the database is properly normalized.Then you write VBA code to create the connective tissue that turnsa bunch of tables, queries, forms, and reports into a complete andcoherent application. You also find out about the important butoften inadequately documented area of Automation code, which isused to communicate with other Office applications.Over years of working with Access, the author hascreated some add-ins to save time when developing applications. Sheshows you 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 does this book cover?Here's what you'll discover in this book:* How to build integrated Access-based applications that supportmultiple clients and databases* Tips for streamlining application creation* Maintenance required throughout an application's lifecycle, including migrating data from legacy systems and upgradingOffice* How to use Automation code to exchange data among Officecomponents and even some non-Office programs* Ways to avoid glitches when building Access applications thatwork with Excel, Word, and OutlookWho is this book 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.