Professional Access 2013 Programming

887 Pages·2015·42.29 MB·English

www.allitebooks.com
www.allitebooks.com
PROFESSIONAL
Access® 2013 Programming
www.allitebooks.com
www.allitebooks.com
PROFESSIONAL
Access® 2013 Programming
Teresa Hennig
Ben Clothier
George Hepworth
Dagi (Doug) Yudovich
www.allitebooks.com
Professional Access® 2013 Programming
Published by
John Wiley & Sons, Inc.
10475 Crosspoint Boulevard
Indianapolis, IN 46256
www.wiley.com
Copyright © 2013 by John Wiley & Sons, Inc., Indianapolis, Indiana
Published simultaneously in Canada
ISBN: 978-1-118-53083-2
ISBN: 978-1-118-53082-5 (ebk)
ISBN: 978-1-118-78961-2 (ebk)
Manufactured in the United States of America
10 9 8 7 6 5 4 3 2 1
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 Sections 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, 222 Rosewood Drive, Danvers,
MA 01923, [phone], fax [phone]. Requests to the Publisher for permission should be addressed to the
Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, [phone], fax (201)
748-6008, or online at http://www.wiley.com/go/permissions.
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 specii cally disclaim all warranties, including
without limitation warranties of i tness 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 ser-
vices. If professional assistance is required, the services of a competent professional person should be sought. Neither the
publisher nor the author shall be liable for damages arising herefrom. The fact that an organization or Web site 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 pub-
lisher endorses the information the organization or Web site may provide or recommendations it may make. Further,
readers should be aware that Internet Web sites 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 [phone], outside the United States at [phone] or fax [phone].
Wiley publishes in a variety of print and electronic formats and by print-on-demand. Some material included with
standard print versions of this book may not be included in e-books or in print-on-demand. If this book refers to
media such as a CD or DVD that is not included in the version you purchased, you may download this material at
http://booksupport.wiley.com. For more information about Wiley products, visit www.wiley.com.
Library of Congress Control Number: 2013907974
Trademarks: Wiley, Wrox, the Wrox logo, Programmer to Programmer, and related trade dress are trademarks or regis-
tered trademarks of John Wiley & Sons, Inc. and/or its afi liates, in the United States and other countries, and may not be
used without written permission. Access is a registered trademark of Microsoft Corporation. All other trademarks are the
property of their respective owners. John Wiley & Sons, Inc., is not associated with any product or vendor mentioned in
this book.
www.allitebooks.com
To my family and my dearest friends — you are my inspirations, role models and
mentors. Whatever I am facing, I can i nd strength and guidance by thinking of
what my Mom, Papa, Dad, or brother might say or do. Every day I have reasons
to say thank you for teaching us to work, to accept responsibility for our actions,
to do the right thing, and to help others. You taught us to do what we enjoy and
to do our best. What a great formula to be happy, energized, and resilient, and to
appreciate all that we have! You set the foundation for me to embrace the thrills,
lessons, and adventures in life. And, throughout life, to be compassionate and to
give generously — especially laughter and smiles, a hug or a helping hand.
—Teresa Hennig
To Suzanne and Harry, for being just plain awesome. I couldn’t have done it
without you two!
—Ben Clothier
I want to dedicate my part in this book to my mother and father, who not only
brought me into the world, but showed me how to live properly once I got here.
Family comes i rst, but that is easy when you have a family like mine. To my
siblings, JoAnna, Tom, Sam, Jack, Nancy, and Jane: Your encouragement (and
unusually high tolerance for bad jokes, lies, and war stories) helps keep me going.
Thanks. I promise I’ll update the family website again soon. I also need to make
special mention of my daughter, Lyndsey; you give me reason to be proud every
day. Love ya, sweetie. We’ll make up for the missed weekend dinners soon.
—George Hepworth
To my wife, Lisa, who still patiently picks up the slack as I dive head-i rst into
new adventures. None of it would have been possible without you. I love you.
—Dagi Yudovich
www.allitebooks.com
CREDITS
EXECUTIVE EDITOR PRODUCTION MANAGER
Robert Elliott Tim Tate
PROJECT EDITOR VICE PRESIDENT AND EXECUTIVE GROUP
Christina Haviland PUBLISHER
Richard Swadley
TECHNICAL EDITORS
F. Scott Barker VICE PRESIDENT AND EXECUTIVE PUBLISHER
Jerry Dennison Neil Edde
Jerry Wood
ASSOCIATE PUBLISHER
PRODUCTION EDITOR Jim Minatel
Christine Mugnolo
PROJECT COORDINATOR, COVER
COPY EDITOR Katie Crocker
Nancy Rapoport
PROOFREADER
EDITORIAL MANAGER Sarah Kaikini, Word One New York
Mary Beth Wakefi eld
INDEXER
FREELANCER EDITORIAL MANAGER John Sleeva
Rosemarie Graham
COVER DESIGNER
ASSOCIATE DIRECTOR OF MARKETING Wiley
David Mayhew
COVER IMAGE
MARKETING MANAGER © iStockphoto.com/PhekThong Lee
Ashley Zurcher
BUSINESS MANAGER
Amy Knies
www.allitebooks.com
ABOUT THE AUTHORS
TERESA HENNIG has been an Access developer and business consultant since 1997,
when she decided to start her own business on the second day that she used Access.
Her company’s name, Data Dynamics Northwest, aptly rel ects her dynamic per-
sonality and her innate ability to quickly grasp a situation, formulate and implement
a solution, and motivate others. With a strong background in business and project
management, Teresa focuses on providing intuitive, cost-effective solutions that sup-
port all levels of an organization. One of her favorite aspects of being a consultant is working with
an endless variety of businesses across many industries and in numerous locations.
As a self-taught developer, Teresa quickly became involved with the Seattle Access Group and
has been the President since 1999. It wasn’t long before she was asked to help run, and then
became President of, the Pacii c Northwest Access Developer Group. Her i rst book Access 2003
Programmer’s Reference (Wiley, 2003) opened the door to new opportunities to help fellow develop-
ers share their passion and expertise with the community. Over the past 10 years, Teresa has helped
dozens of colleagues to become authors, editors and contributors. This is her sixth book, and she
already has requests to do more.
Teresa has been recognized as a Microsoft MVP continuously since 2006, and has twice earned
INETA’s National Community Champion award. Teresa thrives on challenges, project management,
and creating cost-effective solutions. Her skills for motivating and helping others are rel ected in
her contributions to the developer community and support of numerous non-proi t organizations.
She is expanding her reach by doing presentations and offering customized training, mentoring,
and consulting for database development as well as business and project management. You can
contact Teresa at [email protected] to learn more about any of these services. You
can also read about some of her adventures and charitable endeavors by visiting her website,
www.DataDynamicsNW.com.
BEN CLOTHIER is a Lead Developer with IT Impact, Inc., a premier Access and SQL
Server development shop based in Chicago, Illinois. He has worked as a freelance
consultant with notable shops including J Street Technology and Advisicon, and has
worked on Access projects from small, one-man solutions to company-wide line-
of-business applications. Notable projects include job tracking and inventory for a
cement company, a Medicare insurance plan generator for an insurance provider, and
order management for an international shipping company.
Ben is an administrator at UtterAccess and was a coauthor, with Tim Runcie and George Hepworth,
on Microsoft Access in a SharePoint World (Advisicon, 2011), and a contributing author for Access
2010 Programmer’s Reference (Wiley, 2010). He is a certii ed MySQL 5.0 Developer and a Microsoft
Certii ed Technology Specialist for SharePoint 2010 coni gurations. He has been a Microsoft MVP
since 2009.
Ben lives in San Antonio, Texas with his wife, Suzanne, and his son, Harry.
www.allitebooks.com
GEORGE HEPWORTH began his Access career by creating tools to track sales and
exam results for his business, which created and sold training and exam materials.
Realizing that Access databases were more interesting and rewarding than writing
training materials, he soon transitioned to full-time Access development and started
his company, Grover Park Consulting (www.GPCData.com), specializing in resuscitat-
ing “owner-built” Access databases for small- and medium-sized organizations. As a
self-taught developer, George believes that any day on which he doesn’t learn at least one new thing
is a day wasted.
George is a database developer for Data and Domains, a development organization near Bellevue,
Washington, creating Access and Access/SQL Server solutions for clients in the Puget Sound region.
George is part of the administrator team, and a regular contributor, at UtterAccess, the most popu-
lar Access support site on the Internet. He is the author or contributor to several books on Access,
and a presenter at the Pacii c Northwest Access Developer Group and Seattle Access Group.
George holds a BS in English and an MA in TESL from Utah State University. And now, George’s
daughter and his money go to Seattle University.
DAGI (DOUG) YUDOVICH is the Assistant Director of Departmental Computing for the
University of Washington School of Medicine. One of the department’s primary BI
responsibilities is developing database solutions using Access and SQL Server.
Doug is an Administrator on UtterAccess forums and the UtterAccess wiki. Doug
was a contributing author to Microsoft Access Small Business Solutions and the
Access 2010 Programmer’s Reference. Additionally, Doug is an active member of
the Pacii c Northwest Access Developers Group (PNWADG) and a presenter in the Seattle Access
Group (SAG). Doug has been awarded the Access MVP award since 2009.
www.allitebooks.com