Table of Contents


expert one-on-one: microsoft access application development
Expert One-on-One: Microsoft Access Application Development
byHelen Feddema ISBN:0764559044
Wrox Press 2004

This book teaches developers best practices for building effective applications using Microsoft Access. It provides hundreds of tips, tricks, and techniques for mastering Access development, and covers all versions from Access 2000 to the 2003 release.

Table of Contents
Expert One-on-One—Microsoft Access Application Development
Introduction
Part 1 - Creating an Access Application
Chapter 1 - Creating a Database for an Application
Chapter 2 - Using Forms to Work with Data
Chapter 3 - Selecting the Right Controls for Forms
Chapter 4 - Sorting and Filtering Data with Queries
Chapter 5 - Using PivotTables and PivotCharts to Interact with Data
Chapter 6 - Printing Data with Reports
Chapter 7 - Writing VBA Code in Modules
Part II - Modifying, Updating, and Maintaining Access Applications
Chapter 8 - Managing the Application Life Cycle
Chapter 9 - Reworking an Existing Application
Chapter 10 - Moving Old Data into a New Database
Part III - Working with Other Office Components (and More)
Chapter 11 - Working with Word
Chapter 12 - Working with Outlook
Chapter 13 - Working with Excel
Chapter 14 - Working Outside of Office
Index
List of Figures


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

  • 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

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

Helen Feddema

Published by
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: permcoordinator@wiley.com.

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:

ISBN: 0-7645-5904-4

Feddema, Helen Bell.
Expert one-on-one Microsoft access application development / Helen Feddema.
p. cm.
Includes index.
ISBN 0-7645-5904-4 (paper/website)
1. Microsoft Access. 2. Database management. 3. Computer software—Development. I. Title.
QA76.9.D3F4365 2004
005.75’65—dc22
2004001551

Printed in the United States of America

10 9 8 7 6 5 4 3 2 1

1B/RU/QU/QU/IN

Credits

Vice President and Executive Group Publisher
Richard Swadley

Vice President and Executive Publisher
Robert Ipsen

Vice President and Publisher
Joseph B. Wikert

Executive Editorial Director
Mary Bednarek

Executive Editor
Robert M. Elliott

Editorial Manager
Kathryn A. Malm

Technical Editor
Mary Hardy

Senior Production Editor
Fred Bernardi

Development Editor
Emilie Herman

Production Editor
Pamela Hanley

Project Coordinator
Erin Smith

Text Design & Composition
Wiley Composition Services

Proofreading and Indexing
TECHBOOKS Production Services

Dedication

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!

Acknowledgments

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.