Descripciones mejoradas de Syndetics:

For introductory computer courses on Microsoft Office 2010 or courses in computer concepts with a lab component for Microsoft Office 2010 applications.

 

The goal of the Exploring series has been to move students beyond the point and click, helping them understand the why and how behind each skill. The Exploring series for Office 2010 also enables students to extend the learning beyond the classroom.

 

Students go to college now with a different set of skills than they did five years ago. With this in mind, the Exploring series seeks to move students beyond the basics of the software at a faster pace, without sacrificing coverage of the fundamental skills that everybody needs to know.  A lot of learning takes place outside of the classroom, and the Exploring series provides learning tools that students can access anytime, anywhere.

Tabla de contenidos provista por Syndetics

• Chapter 1 Office Fundamentals and File Management
• Case Study: Rails and Trails
• Objectives
• Files and Folders
• Using Windows Explorer
• Working With Folders and Files
• Selecting, Copying, and Moving Multiple Files and Folders
• Hands-On Exercise 1 Files and Folders
• Microsoft Office Software
• Identifying Common Interface Components
• Getting Office Help
• Hands-On Exercise 2 Microsoft Office Software
• Backstage View Tasks
• Opening A File
• Printing A File
• Closing A File and Application
• Hands-On Exercise 3 Backstage View Tasks
• Home Tab Tasks
• Selecting and Editing Text
• Using the Clipboard Group Tasks
• Using the Editing Group Tasks
• Hands-On Exercise 4 Home Tab Tasks
• Insert Tab Tasks
• Inserting Objects
• Review Tab Tasks
• Reviewing A File
• Page Layout Tab Tasks
• Changing Page Settings
• Hands-On Exercise 5 Tasks on the Insert Tab, Page Layout Tab, and Review Tab
• Chapter Objectives Review
• Key Terms
• Multiple Choice
• Practice Exercises
• Mid-Level Exercises
• Capstone Exercise
• Microsoft Office Access 2010
• Chapter 1 Introduction to Access
• Case Study: Managing A Business In the Global Economy
• Objectives
• Databases Are Everywhere!
• Navigating Among the Objects In An Access Database
• Understanding the Difference Between Working In Storage and Memory
• Practicing Good Database File Management
• Backing Up, Compacting, and Repairing Access Files
• Hands-On Exercise 1 Databases Are Everywhere!
• Filters, Sorts, and Access Versus Excel
• Creating Filters
• Sorting Table Data on One Or More Fields
• Knowing When to Use Access Or Excel to Manage Data
• Hands-On Exercise 2 Filters, Sorts, and Access Versus Excel
• Relational Database
• Using the Relationships Windows
• Understanding Relational Power
• Hands-On Exercise 3
• Relational Database
• Chapter Objectives Review
• Key Terms
• Multiple Choice
• Practice Exercises
• Mid-Level Exercises
• Capstone Exercise
• Beyond the Classroom
• Chapter 2 Relational Databases and Queries
• Case Study: Bank Auditor Uncovers Midhandled
• Funds
• Objectives
• Table Design, Properties, Views, and Wizards
• Designing Data
• Creating Tables
• Hands-On Exercise 1 Table Design, Properties, Views, and Wizards
• Multiple Table Databases
• Understanding Table Relationships
• Sharing Data With Excel
• Establishing Table Relationships
• Hands-On Exercise 2 Multiple Table Databases
• Single-Table Queries
• Creating A Single-Table Query
• Specifying Criteria For Different Data Types
• Copying and Running A Query
• Using the Query Wizard
• Hands-On Exercise 3 Single-Table Queries
• Multi-Table Queries
• Creating A Multi-Table Query
• Modifying A Multi-Table Query
• Hands-On Exercise 4 Multi-Table Queries
• Chapter Objectives Review
• Key Terms
• Multiple Choice
• Practice Exercises
• Mid-Level Exercises
• Capstone Exercise
• Beyond the Classroom
• Chapter 3 Customize, Analyze, and Summarize Query Data
• Case Study: Housing Slump Means Opportunity
• For College Students
• Objectives
• Calculations, Expressions, and Functions
• Understanding the Order of Operations
• Creating A Calculated Field In A Query
• Hands-On Exercise 1 Calculations, Expressions, and Functions
• Expression Builder, Functions, and Date Arithmetic
• Creating Expressions With the Expression Builder
• Using Built-In Functions In Access
• Performing Date Arithmetic
• Hands-On Exercise 2 Expression Builder, Functions, and Date Arithmetic
• Aggregate Functions
• Adding Aggregate Functions to Datasheets and Queries
• Hands-On Exercise 3 Aggregate Functions
• Chapter Objectives Review
• Key Terms
• Multiple Choice
• Practice Exercises
• Mid-Level Exercises
• Capstone Exercise
• Beyond the Classroom
• Chapter4 Creating and Using Professional Forms and Reports
• Case Study: Coffee Shop Starts New Business
• Objectives
• Form Basics
• Creating Forms Using the Form Tools
• Modifying A Form
• Sorting Records In A Form
• Hands-On Exercise 1 Form Basics
• Form Sections, Views, and Controls
• Identifying Form Sections
• Revising Forms Using Form Views
• Identifying Control Types In Forms
• Hands-On Exercise 2 Form Sections, Views, and Controls
• Report Basics
• Creating Reports Using Report Tools
• Modifying A Report
• Sorting Records In A Report
• Hands-On Exercise 3 Report Basics
• Report Sections, Views, and Controls
• Identifying Report Sections
• Revising Reports Using Report Views
• Identifying Control Types In Reports
• Hands-On Exercise 4 Report Sections, Views, and Controls
• Chapter Objectives Review
• Key Terms
• Multiple Choice
• Practice Exercises
• Mid-Level Exercises
• Capstone Exercise
• Beyond the Classroom
• Chapter 5 Pivottables and Pivotcharts
• Case Study: Retaining Employees In Tough Times
• Objectives
• Data Mining With Pivottables
• Creating A Pivottable
• Adding Aggregate Functions to A Pivottable
• Modifying A Pivottable
• Hands-On Exercise 1 Data Mining With Pivottables
• Charts Convey Information
• Creating A Pivotchart
• Identifying Chart Elements
• Modifying A Pivotchart
• Hands-On Exercise 2 Charts Convey Information
• Calculations In Pivottables
• Adding Calculations to A Pivottable
• Working With Calculations In A Pivottable
• Hands-On Exercise 3 Calculations In Pivottables
• Chapter Objectives Review
• Key Terms
• Multiple Choice
• Practice Exercises
• Mid-Level Exercises
• Capstone Exercise
• Beyond the Classroom
• Chapter 6 Data Validation Techniques
• Case Study: Manager Fired Over Data Entry Errors
• Objectives
• Data Validation In Tables
• Establishing Data Validation
• Creating An Input Mask
• Creating and Modifying A Lookup Field
• Hands-On Exercise 1 Data Validation In Tables
• Data Validation In Forms and Data Macros
• Setting the Tab Order
• Creating A Combo Box Control
• Restricting Edits In A Form
• Comparing Fields Using A Data Macro
• Hands-On Exercise 2 Data Validation In Forms and Data Macros
• Data Validation With Queries and Reports
• Creating A Query to Display Missing Data
• Creating A Missing Data Report
• Creating An Aggregate Report
• Hands-On Exercise 3 Data Validation With Queries and Reports
• Chapter Objectives Review
• Key Terms
• Multiple Choice
• Practice Exercises
• Mid-Level Exercises
• Capstone Exercise
• Beyond the Classroom
• Chapter 7 Advanced Queries
• Case Study: Replacements, Ltd.
• Objectives
• Action Queries
• Determining When to Use An Action Query
• Updating Data With An Update Query
• Adding Records to A Table With An Append Query
• Creating A Table With A Make Table Query
• Deleting Records With A Delete Query
• Hands-On Exercise 1 Action Queries
• Queries For Special Conditions
• Creating A Parameter Query to Provide Flexibility
• Summarizing Data With A Crosstab Query
• Finding Unmatched Records With A Query
• Finding Duplicate Records With A Query
• Hands-On Exercise 2 Queries For Special Conditions
• Chapter Objectives Review
• Key Terms
• Multiple Choice
• Practice Exercises
• Mid-Level Exercises
• Capstone Exercise
• Beyond the Classroom
• Chapter 8 Get Connected
• Case Study: Data Exchange
• Objectives
• Connecting Access to External Files
• Creating A Hyperlink Field
• Adding An Attachment Field
• Adding Attachment Controls to Forms and Reports
• Hands-On Exercise 1 Connecting Access to External Files
• Exporting Data to Office Applications
• Exporting Data to Excel
• Exporting Data to Word
• Exporting Data to A Pdf Or Xps Document
• Exporting Objects to Another Access Database
• Hands-On Exercise 2 Exporting Data to Office Applications
• Importing Data Into Access
• Linking to An Excel Spreadsheet
• Linking to An Access Table
• Importing A Text File
• Hands-On Exercise 3 Importing Data Into Access
• Chapter Objectives Review
• Key Terms
• Multiple Choice
• Practice Exercises
• Mid-Level Exercises
• Capstone Exercise
• Beyond the Classroom
• Chapter 9 Fine-Tuning the Database
• Case Study: the Metropolitan Zoo
• Objectives
• Normalizing Database Tables
• Verifying First Normal Form
• Verifying Second Normal Form
• Verifying Third Normal Form
• Hands-On Exercise 1 Normalizing Database Tables
• Using the Built-In Analysis and Design Tools
• Using the Database Documenter Tool
• Using the Performance Analyzer Tool
• Using the Table Analyzer Tool
• Using the Database Splitter Tool
• Hands-On Exercise 2 Using the Built-In Analysis and Design Tools
• Safeguarding Your Database Application
• Creating A Menu System
• Encrypting and Password-Protecting A Database
• Digitally Signing and Publishing A Database
• Saving A Database As An Accde File
• Hands-On Exercise 3 Safeguarding Your Database Application
• Chapter Objectives Review
• Key Terms
• Multiple Choice
• Practice Exercises
• Mid-Level Exercises
• Capstone Exercise
• Beyond the Classroom
• Chapter 10 Using Macros and Sql In Access
• Case Study: Retirement Plan Helps Retain Employees
• Objectives
• Working With Macros
• Understanding the Purpose of A Macro
• Creating A Stand-Alone Macro
• Using the Macro Builder
• Attaching An Embedded Macro to An Event
• Hands-On Exercise 1 Working With Macros
• Working With Data Macros
• Identifying When to Use A Data Macro
• Creating An Event-Driven Data Macro
• Creating A Named Data Macro
• Hands-On Exercise 2 Working With Data Macros
• Using Structured Query Language
• Understanding the Fundamentals of Sql
• Interpreting An Sql Select Statement
• Using An Sql Select Statement As A Record Source
• Hands-On Exercise 3 Using Structured Query Language
• Chapter Objectives Review
• Key Terms
• Multiple Choice
• Practice Exercises
• Mid-Level Exercises
• Capstone Exercise
• Beyond the Classroom
• Glossary
• Index

Notas de autor provistas por Syndetics

Dr. Robert T. Grauer, Creator of the Exploring Series

Bob Grauer is an Associate Professor in the Department of Computer Information Systems at the University of Miami, where he is a multiple winner of the Outstanding Teaching Award in the School of Business, most recently in 2009. He has written numerous COBOL texts and is the vision behind the Exploring Office series, with more than three million books in print. His work has been translated into three foreign languages and is used in all aspects of higher education at both national and international levels. Bob Grauer has consulted for several major corporations including IBM and American Express. He received his Ph.D. in operations research in 1972 from the Polytechnic Institute of Brooklyn.

Keith Mast, Access Author

Keith A. Mast develops a wide range of Access applications that solve challenging business problems and

improve efficiency. His solutions help businesses and organizations in manufacturing, pharmaceutical,

financial services, and agriculture, among other industries. Clients include Visible Filing Concepts, Inc.;

Moyer's Chicks, Inc.; Marcho Farms, Inc.; TCM America, Inc.; LANsultants, Inc.; Spector, Roseman,

Kodroff, & Willis, PC; Heinz, Inc.; DuPont; and Sony Entertainment. He is an adjunct faculty member at Montgomery County Community College, Blue Bell, Pennsylvania, continuing his long-standing love of teaching and exemplified by his prior experience as a high school teacher, business school instructor, and Access seminar leader.

Keith promotes the ethical standards of the consulting profession both in how Mast Consulting, LLC deals with its clients and as an active volunteer leader of the Independent Computer Consultants Association of the Delaware Valley.

Keith resides in Norristown, PA, a suburb of Philadelphia. In his free time, he enjoys biking, running,

kayaking, ballroom dancing, and being in nature. For more information, visit him on Facebook, LinkedIn, or at www.keithmast.com.

Mary Anne Poatsy, Series Editor

Mary Anne is a senior faculty member at Montgomery County Community College, teaching various

computer application and concepts courses in face-to-face and online environments. She holds a B.A.

in psychology and education from Mount Holyoke College and an M.B.A. in finance from Northwestern

University's Kellogg Graduate School of Management.

Mary Anne has more than 12 years of educational experience. She is currently adjunct faculty at

Gwynedd-Mercy College and Montgomery County Community College. She has also taught at Bucks

County Community College and Muhlenberg College, as well as conducted professional training. Before

teaching, she was vice president at Shearson Lehman in the Municipal Bond Investment Banking

Department.

Dr. Lynn Hogan, Office Fundamentals and File Management and

Windows 7 Author

Lynn Hogan has taught in the Computer Information Systems area at Calhoun Community College for

29 years. She is the author of Practical Computing and has contributed chapters for several computer

applications textbooks. Primarily teaching in the areas of computer literacy and computer applications,

she was named Calhoun's outstanding instructor in 2006. She received an M.B.A. from the University of

North Alabama and a Ph.D. from the University of Alabama. Lynn resides in Alabama with her husband

and two daughters.