Microsoft Access 2013

165 Pages·2013·24.93 MB·English

by  Lisa Friedrichsen

This is an electronic version of the print textbook. Due to electronic rights restrictions,
some third party content may be suppressed. Editorial review has deemed that any suppressed
content does not materially affect the overall learning experience. The publisher reserves the right
to remove content from this title at any time if subsequent rights restrictions require it. For
valuable information on pricing, previous editions, changes to current editions, and alternate
formats, please visit www.cengage.com/highered to search by ISBN#, author, title, or keyword for
materials in your areas of interest.
Copyright 2013 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.
C8438_fm_ptg01_hr_i-.indd 2 3/6/13 4:06 PM
New! Learning Outcomes
Every 2-page lesson in this book now contains a green Learning Outcomes box that states the learning goals for
that lesson.
• What is a learning outcome? A learning outcome states what a student is expected to
Learning
know or be able to do after completing a lesson. Each learning outcome is skill-based or
Outcomes
knowledge-based and is measurable. Learning outcomes map to learning activities and
• Scroll the Start
screen assessments.
• Display the
Charms bar • How do students benefit from learning outcomes? Learning outcomes tell students
• Switch between exactly what skills and knowledge they are accountable for learning in that lesson. This helps
Start screen and
students study more efficiently and effectively and makes them more active learners.
desktop
• How do instructors benefit from learning outcomes? Learning outcomes provide
clear, measurable, skills-based learning goals that map to various high-quality learning
activities and assessments. A Learning Outcomes Map, available for each unit in this
book, maps every learning outcome to the learning activities and assessments.
See inside for more information!
Copyright 2013 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.
93291_ifc_ptg01.indd 1 2/21/13 2:05 PM
Copyright 2013 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.
C8438_fm_ptg01_hr_i-.indd 2 3/6/13 4:06 PM
Microsoft®
Access® 2013
ILLUSTRATED Brief Introductory Complete
Copyright 2013 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.
C8438_FM_50732.indd 1 3/7/13 2:45 PM
Copyright 2013 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.
C8438_fm_ptg01_hr_i-.indd 2 3/6/13 4:06 PM
Microsoft®
Access® 2013
ILLUSTRATED Brief Introductory Complete
Lisa Friedrichsen
Australia • Brazil • Japan • Korea • Mexico • Singapore • Spain • United Kingdom • United States
Copyright 2013 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.
C8438_FM_50732.indd 3 3/7/13 3:22 PM
Microsoft® Access® 2013—Illustrated Brief © 2014 Course Technology, Cengage Learning
Lisa Friedrichsen
ALL RIGHTS RESERVED. No part of this work covered by the copyright herein may be
Executive Editor: Marjorie Hunt reproduced, transmitted, stored or used in any form or by any means graphic, electronic,
Associate Acquisitions Editor: Amanda Lyons or mechanical, including but not limited to photocopying, recording, scanning, digitiz-
ing, taping, Web distribution, information networks, or information storage and retrieval
Senior Product Manager: Christina Kling-Garrett
systems, except as permitted under Section 107 or 108 of the 1976 United States
Product Manager: Kim Klasner
Copyright Act, without the prior written permission of the publisher.
Editorial Assistant: Brandelynn Perry
Brand Manager: Elinor Gregory For product information and technology assistance, contact us at
Developmental Editor: Lisa Ruffolo Cengage Learning Customer & Sales Support, 1-800-354-9706
For permission to use material from this text or product, submit all
Full-Service Project Management: GEX Publishing
requests online at www.cengage.com/permissions
Services
Further  permissions  questions can be emailed to
Copyeditor: Karen Annett [email protected]
Proofreader: Vicki Zimmer
Indexer: Alexandra Nickerson Library of Congress Control Number:  2013934317
QA Manuscript Reviewers: John Freitas, Susan
Pedicini, Susan Whalen, Jeff Schwartz ISBN-13: 978-1-285-09329-1
ISBN-10: 1-285-09329-1
Cover Designer: GEX Publishing Services
Cover Artist: GEX Publishing Services Course Technology
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
Trademarks:
Some of the product names and company names used in this book have been used for
identification purposes only and may be trademarks or registered trademarks of their
respective manufacturers and sellers.
Microsoft and the Windows logo are registered trademarks of Microsoft Corporation in
the United States and/or other countries. Cengage Learning, Course Technology is an
independent entity from Microsoft Corporation, and not affiliated with Microsoft in any
manner.
Printed in the United States of America
1 2 3 4 5 6 7 19 18 17 16 15 14 13
Copyright 2013 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.
C8438_fm_ptg01_hr_i-.indd 4 3/6/13 4:06 PM
Brief Contents
Preface ..................................................................................................................................................x
Office 2013
Unit A: Getting Started with Microsoft Office 2013 ......................................................................Office 1
Access 2013
Unit A: Getting Started with Access 2013 ....................................................................................Access 1
Unit B: Building and Using Queries ...........................................................................................Access 27
Unit C: Using Forms ..................................................................................................................Access 53
Unit D: Using Reports ................................................................................................................Access 79
Cloud
Appendix: Working in the Cloud .................................................................................................Cloud 1
Glossary ...................................................................................................................................Glossary 1
Index ............................................................................................................................................Index 5
brief Contents v
Copyright 2013 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.
C8438_FM_50732.indd 5 3/7/13 2:43 PM
Contents
Preface ................................................................................................................................x
Office 2013
Unit A: Getting Started with Microsoft Office 2013 ..................................................................Office 1
Understand the Office 2013 Suite ...........................................................................Office 2
What is Office 365?
Start an Office App ..................................................................................................Office 4
Starting an app using Windows 7
Using shortcut keys to move between Office programs
Using the Office Clipboard
Identify Office 2013 Screen Elements .....................................................................Office 6
Using Backstage view
Create and Save a File ..............................................................................................Office 8
Saving files to SkyDrive
Open a File and Save It with a New Name ...........................................................Office 10
Exploring File Open options
Working in Compatibility Mode
View and Print Your Work .....................................................................................Office 12
Customizing the Quick Access toolbar
Creating a screen capture
Get Help, Close a File, and Exit an App ................................................................Office 14
Enabling touch mode
Recovering a document
Practice ...................................................................................................................Office 16
vi Contents
Copyright 2013 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.
C8438_fm_ptg01_hr_i-.indd 6 3/6/13 4:06 PM