Table of Contents

CONCEPTS.
Essential Computer Concepts.
WINDOWS.
Exploring the Basics of Microsoft Windows 7.
FILE MANAGEMENT.
Managing Your Files: Organizing Files and Folders with Windows 7.
INTERNET.
Browser and Email Basics.
OFFICE.
Getting Started with Microsoft Office 2010.
WORD.
Tutorial 1: Creating a Document.
Tutorial 2: Editing and Formatting a Document.
Tutorial 3: Creating a Multiple-Page Report.
Tutorial 4: Desktop Publishing and Mail Merge.
EXCEL.
Tutorial 1: Getting Started with Excel.
Tutorial 2: Formatting a Workbook.
Tutorial 3: Working with Formulas and Functions.
Tutorial 4: Enhancing a Workbook with Charts and Graphs.
ACCESS.
Tutorial 1: Creating a Database.
Tutorial 2: Building a Database and Defining Table Relationships.
Tutorial 3: Maintaining and Querying a Database.
Tutorial 4: Creating Forms and Reports.
POWERPOINT.
Tutorial 1: Creating a Presentation.
Tutorial 2: Adding and Modifying Text and Graphic Objects.
INTEGRATION.
Integrating Word, Excel, Access and PowerPoint.
WEB.
Appendix A: Introduction to SkyDrive and Office Web Apps.
GLOSSARY/INDEX.
TASK REFERENCE.

About the Author

June Jamrich Parsons is an educator, digital book pioneer, co-author of Texty and McGuffey award-winning textbooks and a TAA fellow. She co-developed the first commercially successful multimedia, interactive digital textbook that established the standard for platforms now being developed by numerous educational publishers. Her career includes extensive classroom teaching, product design for eCourseware, textbook authoring for Course Technology and Cengage, creative strategist for MediaTechnics Corporation and director of content for Veative Virtual Reality Labs. She holds a Ph.D. in instructional technology, C.C.P. (Certified Computing Professional) certification and is a member of the Association for Computing Machinery. Kathleen Finnegan is a co-author on New Perspectives on Microsoft® Access® and has edited and managed many other successful textbooks on Microsoft® applications for Cengage Learning’s Course Technology. She has taught various computer courses for corporate training and high-tech companies and has developed courseware as both a technical writer and editor, with over 20 years of experience in this field. An esteemed professional and respected author, Dan Oja, along with June Parsons, purchased an Apple II+ in 1981 and quickly became fluent in BASIC, dBASE II, Lotus 123, WordStar, and a variety of accounting programs. The next year, he and Dr. Parsons opened a successful small computer retail store that offered software instruction to children and adults. With Dr. Parsons, Mr. Oja began writing and creating educational software for Course Technology in 1992. Together, they contributed to the leading success of the Windows for Business and Illustrated Series. They also developed the New Perspectives, e-Course, and Practical series. Today, Mr. Oja's and Dr. Parson's team of highly skilled media specialists and desktop publishers located in various states and provinces work together via the Internet to deliver exceptional texts. Kathleen Finnegan is a co-author on New Perspectives on Microsoft® Access® and has edited and managed many other successful textbooks on Microsoft® applications for Cengage Learning’s Course Technology. She has taught various computer courses for corporate training and high-tech companies and has developed courseware as both a technical writer and editor, with over 20 years of experience in this field. A leading textbook author, lecturer and instructor, Patrick Carey has authored or co-authored more than 40 popular academic and trade texts for the academic market. He has taught and written about a wide range of topics, including website design, JavaScript programming, Microsoft Office and Excel, statistics, data analysis and mathematics. Mr. Carey received his M.S. in biostatistics from the University of Wisconsin, where he worked as a researcher designing and analyzing clinical studies. Today, he splits his time between Wisconsin and Colorado, and when he is not writing, he can be found hiking and cycling. Ms. Ann Shaffer is the co-author of NEW PERSPECTIVES ON MICROSOFT® WORD and has contributed to many other Cengage publications. She has more than 25 years of experience as a developmental editor and co-author of books, journal articles and multimedia in a variety of fields, including computer science, mathematics, history, engineering and social sciences. She holds a master’s degree in English from the University of Wisconsin-Madison.