|Table of Contents|
|Part 1 -
|Part II -
|Part III -
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.
In this book, the author will teach you how to set up tables and relationships to ensure that the database is properly normalized. Then she’ll help 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. We’ll pay special attention to the important but often inadequately documented area of Automation code, which is used to communicate with other Office applications.
What you will learn from this book
About the Author
Helen Feddema is an internationally known expert on Microsoft Access, and a regular contributor to Pinnacle’s Smart Access and Office Developer journals. She edits the Woody’s Access Watch e-zine and writes its “Access Archon” column. Helen’s writings and seminars have been helping Access developers since the beta of Access 1.0, one of many she has tested.
Expert One-on-One—Microsoft Access Application Development
Wiley Publishing, Inc.
10475 Crosspoint Boulevard
Indianapolis, IN 46256
Copyright © 2004 by Helen Feddema.
Published by Wiley Publishing, Inc. All rights reserved.
Published simultaneously in Canada
No part of this publication may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning, or otherwise, except as permitted under Section 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, Inc., 222 Rosewood Drive, Danvers, MA 01923, (978) 750-8400, fax (978) 646-8600. Requests to the Publisher for permission should be addressed to the Legal Department, Wiley Publishing, Inc., 10475 Crosspoint Blvd., Indianapolis, IN 46256, (317) 572-3447, fax (317) 572-4447, E-mail: firstname.lastname@example.org.
LIMIT OF LIABILITY/DISCLAIMER OF WARRANTY: THE PUBLISHER AND THE AUTHOR MAKE NO REPRESENTATIONS OR WARRANTIES WITH RESPECT TO THE ACCURACY OR COMPLETENESS OF THE CONTENTS OF THIS WORK AND SPECIFICALLY DISCLAIM ALL WARRANTIES, INCLUDING WITHOUT LIMITATION WARRANTIES OF FITNESS FOR A PARTICULAR PURPOSE. NO WARRANTY MAY BE CREATED OR EXTENDED BY SALES OR PROMOTIONAL MATERIALS. THE ADVICE AND STRATEGIES CONTAINED HEREIN MAY NOT BE SUITABLE FOR EVERY SITUATION. THIS WORK IS SOLD WITH THE UNDERSTANDING THAT THE PUBLISHER IS NOT ENGAGED IN RENDERING LEGAL, ACCOUNTING, OR OTHER PROFESSIONAL SERVICES. IF PROFESSIONAL ASSISTANCE IS REQUIRED, THE SERVICES OF A COMPETENT PROFESSIONAL PERSON SHOULD BE SOUGHT. NEITHER THE PUBLISHER NOT THE AUTHOR SHALL BE LIABLE FOR DAMAGES ARISING HEREFROM. THE FACT THAT AN ORGANIZATION OR WEBSITE IS REFERRED TO IN THIS WORK AS A CITATION AND/OR A POTENTIAL SOURCE OF FURTHER INFORMATION DOES NOT MEAN THAT THE AUTHOR OR THE PUBLISHER ENDORSES THE INFORMATION THE ORGANIZATION OR WEBSITE MAY PROVIDE OR RECOMMENDATIONS IT MAY MAKE. FURTHER, READERS SHOULD BE AWARE THAT INTERNET WEBSITES LISTED IN THIS WORK MAY HAVE CHANGED OR DISAPPEARED BETWEEN WHEN THIS WORK WAS WRITTEN AND WHEN IT IS READ.
For general information on our other products and services please contact our Customer Care Department within the United States at (800) 762-2974, outside the United States at (317) 572-3993 or fax (317) 572-4002.
Trademarks: Wiley, the Wiley Publishing logo, Wrox, the Wrox logo, and Programmer to Programmer are trademarks or registered trademarks of John Wiley & Sons, Inc. and/or its affiliates. Microsoft is a registered trademark of Microsoft Corporation. All other trademarks are the property of their respective owners. Wiley Publishing, Inc., is not associated with any product or vendor mentioned in this book.
Wiley also publishes its books in a variety of electronic formats. Some content that appears in print may not be available in electronic books.
Library of Congress Cataloging-in-Publication Data:
Feddema, Helen Bell.
Expert one-on-one Microsoft access application development / Helen Feddema.
ISBN 0-7645-5904-4 (paper/website)
1. Microsoft Access. 2. Database management. 3. Computer software—Development. I. Title.
Printed in the United States of America
10 9 8 7 6 5 4 3 2 1
Vice President and Executive Group Publisher
Vice President and Executive Publisher
Vice President and Publisher
Joseph B. Wikert
Executive Editorial Director
Robert M. Elliott
Kathryn A. Malm
Senior Production Editor
Text Design & Composition
Wiley Composition Services
Proofreading and Indexing
TECHBOOKS Production Services
To all the developers who have posted their code on the Internet (and its predecessors) for others to use—you may not have been paid, but your work is appreciated!
As always, thanks to my agent, Claudette Moore, for her work on this book project. Much thanks to my editors at Wiley, Bob Elliott and Emilie Herman, and to production editor Pamela Hanley and all the production staff who worked on this book. I am very grateful to my tech editor, Mary Hardy, who has greatly improved the quality of the sample databases by reviewing them in many versions, spotting problems and suggesting improvements.
About the Author
Helen Feddema grew up in New York City. She was ready for computers when she was 12, but personal computers were still in the future, so she got a B.S. in Philosophy from Columbia and an M.T.S. in Theological Studies from Harvard Divinity School, while working at various office jobs. It was at HDS that she got her first computer, an Osborne, and soon computers were her primary interest. She started with word processing and spreadsheets, went on to learn dBASE, and did dBASE development for six years, part of this time as a corporate developer. After being laid off in a flurry of corporate downsizing in the 1980’s, she started doing independent consulting and development, using dBASE, ObjectVision, WordPerfect and Paradox.
Always looking for something new and better, Helen beta tested Access 1.0, and soon recognized that this was the database she had been looking for ever since Windows 3.0 was introduced and she saw the gap waiting to be filled by a great Windows database. Since then she has worked as a developer of Microsoft Office applications, concentrating on Access, Word and Outlook.
Helen co-authored Inside Microsoft Access 1.0 (New Riders, 1992), and wrote two books for Pinnacle’s “The Pros Talk Access” series, Power Forms and Power Reports (1994). She also co-authored Access How-Tos for the Waite Group Press (1995), and contributed to The Microsoft Outlook Handbook (Osborne-McGraw-Hill), Que’s Special Edition: Using Microsoft Outlook 97 (1997), Office Annoyances (O’Reilly, 1997), and Outlook Annoyances (O’Reilly, 1998). She also contributed chapters to Que’s Special Edition: Using Microsoft Project 98 (1997) and Sams’ Teach Yourself Project (1998).
Helen co-authored Sybex’ MCSD: Access 95 Study Guide (1998), and contributed chapters on Outlook programming to Que’s Special Edition: Using Microsoft Outlook 2000 (1999), and wrote DAO Object Model: The Definitive Reference for O’Reilly (2000), and Access 2002 Inside-Out for Microsoft Press.
Helen has been a regular contributor to Pinnacle’s Smart Access and Office Developer journals, Woody’s Underground Office newsletter, PC Magazine’s Undocumented Office and the MS Office and VBA Journal (now OfficePro). She is the editor of the Woody’s Access Watch ezine, and writes its Access Archon column.
Helen is a big-time beta tester, sometimes having 7 or 8 betas running at once, mostly Microsoft, but with some from other vendors as well. She has participated in every Access beta from 1.0 to 2003, and is a member of the Access Insiders group.
She lives in the mid-Hudson valley area of New York state, with varying numbers of cats and computers.
Helen maintains a Web page (www.helenfeddema.com) with a large selection of code samples concentrating on connecting Access, Outlook, Word and Excel (including several Access add-ins), and all her Access Archon articles.