
Author(s) : Helen Feddema
Publisher : Wrox
Year : May 2004
ISBN 10 : 0764559044
ISBN 13 : 9780764559044
Language : English
Pages : 624
File type : CHM
Size : 94 MB (book + source code)
If you are developing databases for your own use, you may not mind opening forms or printing reports directly from the database window, and you know what query to run before printing which report or exporting data to Word. However, if you are planning to create applications for the use of others, particularly for clients who aren�t familiar with Access, and don�t understand databases in general, you have to do a lot more work, mostly in the form of writing VBA code to automate the application�s processes.
As a rule of thumb, it�s generally true that the easier the application is for the end user, the harder (and more time-consuming) it is to develop. In this book I concentrate on teaching you how to set up your tables and relationships to ensure that the database is properly normalized, and write VBA code to create the connective tissue that turns a bunch of tables, queries, forms and reports into a complete and coherent application.
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.
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.