Microsoft Access 2010 : advanced

147 Pages·2011·18.44 MB·English

by  Lisa L 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.
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.
Microsof t Access 2010
® ®
Advanced
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.
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 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.
Illustrated Course Guide: Microsoft® Access® 2010 © 2011 Course Technology, Cengage Learning
Advanced
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 Author: Carol Cram
Trademarks:
Developmental Editors: Lisa Ruffolo, Pamela Conrad
Some of the product names and company names used in this book have been used for
Content Project Managers: Melissa Panagos,
identification purposes only and may be trademarks or registered trademarks of their
Danielle Chouhan
respective manufacturers and sellers.
Copy Editor: Mark Goodin
Microsoft and the Office logo are either registered trademarks or trademarks of
Proofreader: Harold Johnson Microsoft Corporation in the United States and/or other countries. Course Technology,
Indexer: BIM Indexing and Proofreading Services Cengage Learning is an independent entity from Microsoft Corporation, and not
affiliated with Microsoft in any manner.
QA Manuscript Reviewers: John Frietas,
Serge Palladino, Susan Pedicini, Jeff Schwartz,
Library of Congress Control Number: 2010938669
Danielle Shaw, Marianne Snow
Print Buyer: Fola Orekoya ISBN-13: 978-0-538-74841-4
Cover Designer: GEX Publishing Services ISBN-10: 0-538-74841-9
Cover Artist: Mark Hunt Course Technology
Composition: GEX Publishing Services 20 Channel Center Street
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.
Brief Contents
Preface ...................................................................................................................................................x
Access 2010
Unit L: Creating Advanced Repor ts ...........................................................................................Access 289
Unit M: Creating Macros ..........................................................................................................Access 313
Unit N: Creating Modules and VBA ...........................................................................................Access 337
Unit O: Building a Dat abase Inter face .......................................................................................Access 361
Unit P: Administering the Database ..........................................................................................Access 385
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.
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.
Contents
Preface ..................................................................................................................................x
Access 2010
Unit L: Creating Advanced Repor ts ........................................................................................Access 289
Applying Advanced Format ting ...........................................................................Access 290
Controlling Layout ...............................................................................................Access 292
Set ting Advanced Print Layout ............................................................................Access 294
Creating Char ts .....................................................................................................Access 296
Modif ying Char ts .................................................................................................Access 298
Applying Char t Types ...........................................................................................Access 300
Creating Multicolumn Repor ts .............................................................................Access 302
Using Domain Functions ......................................................................................Access 304
Practice ..................................................................................................................Access 306
Unit M: Creating Macros ........................................................................................................Access 313
Understanding Macros .........................................................................................Access 314
Creating a Macro ..................................................................................................Access 316
Modif ying Actions and Arguments .....................................................................Access 318
Assigning a macro to a key combination
Assigning a Macro to a Command But ton ...........................................................Access 320
Using a trusted database and setting up a trusted folder
Using If Statements ...............................................................................................Access 322
Working with Events ............................................................................................Access 324
Creating a Data Macro ..........................................................................................Access 326
Troubleshooting Macros .......................................................................................Access 328
Practice ..................................................................................................................Access 330
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.
Unit N: Creating Modules and VBA ........................................................................................Access 337
Understanding Modules and VBA ........................................................................Access 338
Comparing Macros and Modules .........................................................................Access 340
Creating Functions ...............................................................................................Access 342
Using If Statements ...............................................................................................Access 344
Documenting Procedures .....................................................................................Access 346
Building Class Modules ........................................................................................Access 348
Modifying Sub Procedures ....................................................................................Access 350
Troubleshooting Modules .....................................................................................Access 352
Practice ..................................................................................................................Access 354
Unit O: Building a Dat abase Inter face ...................................................................................Access 361
Working with Objects ...........................................................................................Access 362
Grouping Objects ..................................................................................................Access 364
Naming objects
Creating a Dialog Box ...........................................................................................Access 366
Creating a Pop Up Form .......................................................................................Access 368
Creating a Navigation Form .................................................................................Access 370
Creating a Switchboard ........................................................................................Access 372
Modif ying a Switchboard .....................................................................................Access 374
Using the Documenter .........................................................................................Access 376
Practice ..................................................................................................................Access 378
viii 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.