Microsoft Office

PUBLISHED BY
Microsoft Press
A Division of Microsoft Corporation
One Microsoft Way
Redmond, Washington 98052-6399
Copyright © 2004 by Online Training Solutions, Inc.
All rights reserved. No part of the contents of this book may be reproduced or transmitted in any form
or by any means without the written permission of the publisher.
Library of Congress Cataloging-in-PublicationData
Microsoft Office Access 2003 Step by Step / Online Training Solutions, Inc.
p. cm. Includes index. ISBN 0-7356-1517-9 1. Microsoft Access. 2. Database management. I. Online Training Solutions (Firm) QA76.9.D3M5733 005.75'65--dc21 2003
2003052694


Printed and bound in the United States of America. 1 2 3 4 5 6 7 8 9 QWE 8 7 6 5 4 3

Distributed in Canada by H.B. Fenn and Company Ltd.A CIP catalogue record for this book is available from the British Library. Microsoft Press books are available through booksellers and distributors worldwide. For further informa­ tion about international editions, contact your local Microsoft Corporation office or contact Microsoft Press International directly at fax (425) 936-7329. Visit our Web site at www.microsoft.com/mspress. Send commentsto mspinput@microsoft.com. FrontPage, Links, Microsoft, Microsoft Press, the Office logo, Outlook, PivotChart, PivotTable, SharePoint, Visual Basic, Visual Studio, Windows, and Windows NT are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. Other product and company names mentioned herein may be the trademarks of their respectiveowners. The example companies, organizations, products, domain names, e-mail addresses, logos, people, places, and events depicted herein are fictitious. No association with any real company, organization, product, domain name, e-mail address, logo, person, place, or event is intended or should be inferred. Acquisitions Editor: Alex Blanton Project Editor: Aileen Wrothwell

Body Part No. X09-71428Contents
What’s New in Microsoft Office Access 2003 Getting Help Getting Help with This Book and Its CD-ROM Getting Help with Microsoft Office Access 2003 More Information Using the Book’s CD-ROM What’s On the CD-ROM? Minimum System Requirements Installing the Practice Files Using the Practice Files Uninstalling the Practice Files Conventions and Features
Taking a Microsoft Office SpecialistCertification Exam
About the Microsoft Office Specialist Program
What Does This Logo Mean?
Selecting a Microsoft Office Specialist Certification Level
Microsoft Office Specialist Skill Standards
The Exam Experience
For More Information
Microsoft Office Specialist Skill Standards
About the Authors
Quick Reference
Chapter 1: Chapter 2: Chapter 3: Chapter 4: Chapter 5: Chapter 6:Chapter 7: Chapter 8: Chapter 9: Getting to Know Microsoft Access 2003
Creating a New Database
Getting Information Into and Out of a Database
Simplifying Data Entry with Forms
Locating Specific Information
Keeping Your Information Accurate
Working with Reports
Making It Easy for Others to Use Your Database Keeping Your Information Secure vii ix ix ix xii xiii xiii xiii xiv xv xviixix xxi xxi xxi xxi xxii xxii xxiv xxv xxvii xxix xxix xxx xxxi xxxiii xxxv xxxvii xxxix xlii xliii xlv

Chapter 10: Working with Pages and Modules

iii

Contents

1

Getting to Know Microsoft Access 2003
Understanding Databases
Discovering What’s Special About Access
Opening an Existing Database
Exploring Tables
Exploring Queries
Exploring Forms
Exploring ReportsExploring Other Access Objects
Previewing and Printing Access Objects


1

2 3 4 6 10 14 18 21 22

2

Creating a New Database
Creating a Database Structure the Simple Way Checking the Work of a Wizard Creating Tables the Simple Way Refining How Data Is Displayed Manipulating Table Columns and Rows

31

32
36
41
44
51


3

Getting Information Into and Out of a Database...