Illustrated Course Guide: Microsoft Access 2010 Basic (Illustrated Course Guides)

195 Pages·2010·42.6 MB·English

by  Lisa Friedrichsen

Copyright 2011 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. Due to electronic rights, some third party content may be suppressed from the eBook and/or eChapter(s).
Editorial review has deemed that any suppressed content does not materially affect the overall learning experience. Cengage Learning reserves the right to remove additional content at any time if subsequent rights restrictions require it.
AA__CC77776633__FFMM..44cc..iinndddd iiii 99//1133//1100 88::1122 AAMM
Microsof t Access 2010
® ®
Basic
Copyright 2011 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. Due to electronic rights, some third party content may be suppressed from the eBook and/or eChapter(s).
Editorial review has deemed that any suppressed content does not materially affect the overall learning experience. Cengage Learning reserves the right to remove additional content at any time if subsequent rights restrictions require it.
AA__CC77776633__FFMM..44cc..iinndddd ii 99//1133//1100 88::1122 AAMM
Copyright 2011 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. Due to electronic rights, some third party content may be suppressed from the eBook and/or eChapter(s).
Editorial review has deemed that any suppressed content does not materially affect the overall learning experience. Cengage Learning reserves the right to remove additional content at any time if subsequent rights restrictions require it.
AA__CC77776633__FFMM..44cc..iinndddd iiii 99//1133//1100 88::1122 AAMM
Microsof t Access 2010
® ®
Basic
Lisa Friedrichsen
Australia • Brazil • Japan • Korea • Mexico • Singapore • Spain • United Kingdom • United States
Copyright 2011 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. Due to electronic rights, some third party content may be suppressed from the eBook and/or eChapter(s).
Editorial review has deemed that any suppressed content does not materially affect the overall learning experience. Cengage Learning reserves the right to remove additional content at any time if subsequent rights restrictions require it.
AA__CC77776633__FFMM..44cc..iinndddd iiiiii 99//1133//1100 88::1122 AAMM
Illustrated Course Guide: Microsoft® Access® 2010 © 2011 Course Technology, Cengage Learning
Basic
ALL RIGHTS RESERVED. No part of this work covered by the copyright herein may be
Lisa Friedrichsen reproduced, transmitted, stored or used in any form or by any means graphic, electronic,
or mechanical, including but not limited to photocopying, recording, scanning, digitiz-
Vice President, Publisher: Nicole Jones Pinard
ing, taping, Web distribution, information networks, or information storage and retrieval
Executive Editor: Marjorie Hunt systems, except as permitted under Section 107 or 108 of the 1976 United States
Associate Acquisitions Editor: Brandi Shailer Copyright Act, without the prior written permission of the publisher.
Senior Product Manager: Christina Kling Garrett
Associate Product Manager: Michelle Camisa For product information and technology assistance, contact us at
Cengage Learning Customer & Sales Support, 1-800-354-9706
Editorial Assistant: Kim Klasner
For permission to use material from this text or product, submit all
Director of Marketing: Cheryl Costantini requests online at www.cengage.com/permissions
Senior Marketing Manager: Ryan DeGrote Further permissions questions can be emailed to
[email protected]
Marketing Coordinator: Kristen Panciocco
Contributing Authors: Carol Cram, Elizabeth
Eisner Reding Trademarks:
Developmental Editors: Lisa Ruffolo, Pamela Conrad, Some of the product names and company names used in this book have been used for
Jeanne Herring identification purposes only and may be trademarks or registered trademarks of their
respective manufacturers and sellers.
Content Project Manager: Melissa Panagos
Microsoft and the Office logo are either registered trademarks or trademarks of
Copy Editor: Mark Goodin
Microsoft Corporation in the United States and/or other countries. Course Technology,
Proofreader: Harold Johnson Cengage Learning is an independent entity from Microsoft Corporation, and not
Indexer: BIM Indexing and Proofreading Services affiliated with Microsoft in any manner.
QA Manuscript Reviewers: John Frietas,
Library of Congress Control Number: 2010936044
Serge Palladino, Susan Pedicini, Jeff Schwartz,
Danielle Shaw, Marianne Snow
ISBN-13: 978-0-538-74839-1
Print Buyer: Fola Orekoya ISBN-10: 0-538-74839-7
Cover Designer: GEX Publishing Services
Course Technology
Cover Artist: Mark Hunt 20 Channel Center Street
Composition: GEX Publishing Services Boston, MA 02210
USA
Cengage Learning is a leading provider of customized learning solutions with office
locations around the globe, including Singapore, the United Kingdom, Australia,
Mexico, Brazil, and Japan. Locate your local office at:
international.cengage.com/region
Cengage Learning products are represented in Canada by Nelson Education, Ltd.
To learn more about Course Technology, visit www.cengage.com/coursetechnology
To learn more about Cengage Learning, visit www.cengage.com
Purchase any of our products at your local college store or at our preferred online store
www.cengagebrain.com

Printed in the United States of America
1 2 3 4 5 6 7 8 9 18 17 16 15 14 13 12 11 10
Copyright 2011 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. Due to electronic rights, some third party content may be suppressed from the eBook and/or eChapter(s).
Editorial review has deemed that any suppressed content does not materially affect the overall learning experience. Cengage Learning reserves the right to remove additional content at any time if subsequent rights restrictions require it.
AA__CC77776633__FFMM..44cc..iinndddd iivv 99//1133//1100 88::1122 AAMM
Brief Contents
Preface ...................................................................................................................................................x
Office 2010
Unit A: Getting Started with Microsoft Office 2010 .......................................................................Office 1
Access 2010
Unit A: Getting Started with Access 2010 ......................................................................................Access 1
Unit B: Building and Using Queries ............................................................................................Access 25
Unit C: Using Forms ...................................................................................................................Access 49
Unit D: Using Reports .................................................................................................................Access 73
Unit E: Modifying the Database Structure ...................................................................................Access 97
Web Apps
Appendix Web Apps: Working with Windows Live and Of fice Web Apps .............................Web Apps 1
Glossary ....................................................................................................................................Glossary 1
Index .............................................................................................................................................Index 6
BRIEF CONTENTS v
Copyright 2011 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. Due to electronic rights, some third party content may be suppressed from the eBook and/or eChapter(s).
Editorial review has deemed that any suppressed content does not materially affect the overall learning experience. Cengage Learning reserves the right to remove additional content at any time if subsequent rights restrictions require it.
AA__CC77776633__FFMM..44cc..iinndddd vv 99//1133//1100 88::1122 AAMM
Copyright 2011 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. Due to electronic rights, some third party content may be suppressed from the eBook and/or eChapter(s).
Editorial review has deemed that any suppressed content does not materially affect the overall learning experience. Cengage Learning reserves the right to remove additional content at any time if subsequent rights restrictions require it.
AA__CC77776633__FFMM..44cc..iinndddd iixx 99//1133//1100 88::1122 AAMM
Contents
Preface ...............................................................................................................................................................x
Office 2010
Unit A: Getting Started with Microsoft Office 2010 ...................................................................Office 1
Understanding the Office 2010 Suite ....................................................................................................Office 2
Deciding which program to use
Starting and Exiting an Office Program.................................................................................................Office 4
Using shortcut keys to move between Office programs
Windows Live and Microsoft Office Web Apps
Viewing the Office 2010 User Interface .................................................................................................Office 6
Using Backstage view
Creating and Saving a File .....................................................................................................................Office 8
Using the Office Clipboard
Opening a File and Saving It with a New Name .................................................................................Office 10
Working in Compatibility Mode
Exploring File Open options
Viewing and Printing Your Work .........................................................................................................Office 12
Customizing the Quick Access toolbar
Creating a screen capture
Getting Help and Closing a File ..........................................................................................................Office 14
Recovering a document
Practice .................................................................................................................................................Office 16
Access 2010
Unit A: Get ting S t a r t ed wi t h Access 2 0 10 ................................................................................Access 1
Under s t anding Rela t ional Da t abases ...................................................................................................Access 2
Exploring a Database ............................................................................................................................Access 4
Creating a Database ..............................................................................................................................Access 6
C r ea t ing a Table ...................................................................................................................................Access 8
Creating a table in Datasheet View
C r ea t ing Pr imar y Ke y s .......................................................................................................................Access 10
Learning about field properties
Rela t ing T wo Tables ...........................................................................................................................Access 12
Enforcing referential integrity
E n t e r ing Da t a .....................................................................................................................................Access 14
Changing from Navigation mode to Edit mode
Windows Live
Edi t ing Da t a ........................................................................................................................................Access 16
Resizing and moving datasheet columns
Practice ................................................................................................................................................Access 18
vi CONTENTS
Copyright 2011 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. Due to electronic rights, some third party content may be suppressed from the eBook and/or eChapter(s).
Editorial review has deemed that any suppressed content does not materially affect the overall learning experience. Cengage Learning reserves the right to remove additional content at any time if subsequent rights restrictions require it.
AA__CC77776633__FFMM..44cc..iinndddd vvii 99//1133//1100 88::1122 AAMM
Unit B: Building and Using Queries ..........................................................................................Access 25
Using the Query Wizard .....................................................................................................................Access 26
Working with Data in a Query ...........................................................................................................Access 28
Using Query Design View ...................................................................................................................Access 30
Adding or deleting a table in a query
Sorting and Finding Data ....................................................................................................................Access 32
Filtering Data ......................................................................................................................................Access 34
Using wildcard characters
Applying AND Criteria........................................................................................................................Access 36
Searching for blank fields
Applying OR Criteria ..........................................................................................................................Access 38
Format ting a Datasheet ......................................................................................................................Access 40
Practice ................................................................................................................................................Access 42
Unit C: Using Forms ..................................................................................................................Access 49
Using the Form Wizard .......................................................................................................................Access 50
Creating a Split Form ..........................................................................................................................Access 52
Using Form Layout View ....................................................................................................................Access 54
Adding Fields to a Form ......................................................................................................................Access 56
Bound versus unbound controls
Modif ying Form Controls ...................................................................................................................Access 58
Creating Calculations .........................................................................................................................Access 60
Modif ying Tab Order ..........................................................................................................................Access 62
Inser ting an Image ..............................................................................................................................Access 64
Practice ................................................................................................................................................Access 66
Unit D: Using Repor ts ...............................................................................................................Access 73
Using the Repor t Wizard ....................................................................................................................Access 74
Using Repor t Layout View ..................................................................................................................Access 76
Reviewing Repor t Sections ..................................................................................................................Access 78
Applying Group and Sor t Orders ........................................................................................................Access 80
Adding Subtotals and Counts .............................................................................................................Access 82
Resizing and Aligning Controls ..........................................................................................................Access 84
Precisely moving and resizing controls
Format ting a Repor t ............................................................................................................................Access 86
Creating Mailing Labels ......................................................................................................................Access 88
Practice ................................................................................................................................................Access 90
Unit E: Modifying the Database Structure ...............................................................................Access 97
Examining Relational Databases ........................................................................................................Access 98
Using many-to-many relationships
Designing Related Tables ..................................................................................................................Access 100
Specifying the foreign key field data type
Creating One-to-Many Relationships ...............................................................................................Access 102
More on enforcing referential integrity
Creating Lookup Fields .....................................................................................................................Access 104
Creating multivalued fields
CONTENTS vii
Copyright 2011 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. Due to electronic rights, some third party content may be suppressed from the eBook and/or eChapter(s).
Editorial review has deemed that any suppressed content does not materially affect the overall learning experience. Cengage Learning reserves the right to remove additional content at any time if subsequent rights restrictions require it.
AA__CC77776633__FFMM..44cc..iinndddd vviiii 99//1133//1100 88::1122 AAMM