The Unofficial Guide to Microsoft Office Access 2007 (Unofficial Guide)

676 Pages·2007·6.79 MB·English

by  Jim Keogh

01_045978 ffirs.qxp 2/28/07 11:08 PM Page i
the
Unofficial
®
Guide to
®
Microsoft Office
™
Access
2007
Jim Keogh
01_045978 ffirs.qxp 2/28/07 11:08 PM Page iii
01_045978 ffirs.qxp 2/28/07 11:08 PM Page i
the
Unofficial
®
Guide to
®
Microsoft Office
™
Access
2007
Jim Keogh
01_045978 ffirs.qxp 2/28/07 11:08 PM Page ii
The Unofficial Guide® to Microsoft® Office Access™ 2007
Published by
Wiley Publishing, Inc.
111 River Street
Hoboken, NJ 07030-5774
www.wiley.com
Copyright © 2007 by Wiley Publishing, Inc., Indianapolis, Indiana
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 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 (978)
646-8600, or on the web at www.copyright.com. Requests to the Publisher for permission should be
addressed to the Legal Department, Wiley Publishing, Inc., 10475 Crosspoint Blvd., Indianapolis, IN
46256, [phone], fax [phone], or online at http://www.wiley.com/go/permissions.
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 render-
ing legal, accounting, or other professional services. 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 here from. 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.
Wiley, the Wiley Publishing logo, Unofficial Guide and all related trademarks, logos, and trade dress are
trademarks or registered trademarks of John Wiley & Sons, Inc. and/or its affiliates, in the United
States and other countries, and may not be used without written permission. Microsoft and Access are
trademarks or registered trademarks of Microsoft Corporation in the United States and/or other coun-
tries. 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.
For general information on our other products and services or to obtain technical support please con-
tact our Customer Care Department within the U.S. at [phone], outside the U.S. at (317)
572-3993 or fax [phone].
Wiley also publishes its books in a variety of electronic formats. Some content that appears in print
may not be available in electronic books. For more information about Wiley products, please visit our
web site at www.wiley.com.
Library of Congress Control Number: 2006939465
ISBN: 978-0-470-04597-8
Manufactured in the United States of America
10 9 8 7 6 5 4 3 2 1
Page creation by Wiley Publishing, Inc. Composition Services
01_045978 ffirs.qxp 2/28/07 11:08 PM Page iii
This book is dedicated to Anne, Sandy, Joanne, and Amber-Leigh Christine, without
whose help and support this book couldn’t have been written.
01_045978 ffirs.qxp 2/28/07 11:08 PM Page iv
Acknowledgements
especially want to acknowledge the fine contributions of Beth Taylor,
Jody Lefevere, and Ken Davidson to this book. Their efforts are
Imuch appreciated.
01_045978 ffirs.qxp 2/28/07 11:08 PM Page v
Credits
Acquisitions Editor Project Coordinator
Jody Lefevere Adrienne Martinez
Project Editor Graphics & Production Specialists
Beth Taylor Carrie A. Foster
Brooke Graczyk
Technical Editor
Jennifer Mayberry
Ken Davidson
Quality Control Technicians
Copy Editor
Cynthia Fields
Beth Taylor
John Greenough
Editorial Manager Charles Spencer
Robyn Siesky
Proofreading
Vice President & Group Executive Melissa Buddendeck
Publisher
Indexing
Richard Swadley
Potomac Indexing, LLC
Vice President & Publisher
Book Interior Design
Barry Pruett
Lissa Auciello-Brogan
Elizabeth Brooks
01_045978 ffirs.qxp 2/28/07 11:08 PM Page vi
About the Author
Jim Keogh is on the faculty of New York University and Saint Peter’s
College in Jersey City, New Jersey where he teaches Microsoft Access and
other computer courses. He was a member of the faculty at Columbia
University where he developed the e-commerce tract. Keogh has spent
decades developing applications for major Wall Street corporations and
is the author of more than 70 books including Java Database Programming
for Dummies, Unix Programming For Dummies, and Linux Programming For
Dummies.
02_045978 ftoc.qxp 2/28/07 11:06 PM Page vii
Acknowledgements..............................................................vi
Introduction ..................................................................xxvii
I Getting Started..............................................1
1 Getting In and Out...................................................3
Starting Access 2007 .................................................3
Start from the desktop............................................4
Start from the Quick Launch toolbar ..........................4
The Access 2007 environment .....................................5
The Ribbon ...........................................................5
Galleries...............................................................6
Quick Access toolbar ...............................................6
Customizing the Quick Access toolbar.........................7
The Office Button...................................................8
Getting Started with Access ........................................9
Using templates ......................................................10
Template Categories..............................................11
From Microsoft Office Online...................................11
Building a database from a template ..........................11
Building a database from scratch ...............................14
Opening the Northwind 2007 database........................16
Working with form views...........................................16
Form view...........................................................18
Design view.........................................................19
Layout view ........................................................20
Working with data views ...........................................22
Datasheet view ....................................................23
Design view.........................................................23
PivotTable view and PivotChart view ........................24
Working with report views.........................................25
Report view.........................................................26
Layout view and Design view ..................................26
Print view ...........................................................27
Navigating the Ribbon .............................................27
Just the facts..........................................................29
vii
Contents