Overview

For introductory computer courses on Microsoft Office 2010 or courses in computer concepts with a lab component for Microsoft Office 2010 applications.   Your Office is the Office Applications textbook written for instructors who want more than a `skill & drill’ book that enables students to learn discreet tasks but fails to illustrate the big picture of how these skills work together.  Your Office bridges the gap between skill and application, and empowers students to master Office 2010 as a tool to solve problems and make decisions. The cases progress students from learning the skills in each Office Application to using the applications as tools to make business decisions. The unique modular structure provides a strong foundation for students through practice in each workshop and then synthesizes the objectives covered over two workshops, challenging students to really retain what they learned as opposed to learning and then forgetting soon after.   The series scenario introduces a large global business (the resort and spa) made up of smaller businesses (golf pro shop, spa, restaurants, event planning, etc) featured in the cases that run throughout all four applications.  This approach gives students a solid understanding of how an organization works by exposing them to how individuals in all facets of a business interact with tools like Microsoft Office and use information to make decisions.

Full Product Details

Author:   Amy S. Kinser ,  Diane Lending ,  Jennifer Paige Nightingale ,  Patti Hammerle
Publisher:   Pearson Education (US)
Imprint:   Pearson
Dimensions:   Width: 21.60cm , Height: 2.30cm , Length: 27.60cm
Weight:   1.424kg
ISBN:  

9780132560887

ISBN 10:   0132560887
Pages:   736
Publication Date:   12 January 2012
Audience:   Professional and scholarly ,  Professional & Vocational
Format:   Spiral bound
Publisher's Status:   Out of Print
Availability:   In Print  
Limited stock is available. It will be ordered for you and shipped pending supplier's limited stock.

Table of Contents

"Module 1. Storing the Putts for Paws Golf Tournament Data in a Database Prepare  Workshop 1: Understanding the Putts for Paws Main Database Objects Understanding Database Basics and Tables What is Access? What are the Four Main Objects in a database? Creating a new database and templates Maneuvering in the Navigation Pane Ways to view the objects Shutter Button Customizing the navigation pane Enabling the Search Box File Extensions in Access Introducing Tables What is a table? Import a table Navigate through the table Difference between Access and Excel Discovering a Database (Manual Query) Understanding Queries, Forms, and Reports Introducing Queries Creating a Query using Wizard Selecting a value using Design View Printing Query Results Introducing Forms Creating a Form Entering data via a Form Introducing Reports What is a Report? Creating a Report using Wizard Printing Report Results Backing up your Database Compact and Repair EOW: Practice Problem 1 EOW: Practice Problem 2 Prepare  Workshop 2: Gathering the Putts for Paws Data into the Database Inserting Data into a Database Database Design Automated Mechanisms for Data Acquisition Copy and Pasting Importing (.accdb, .xlsx, .csv, & .txt) Manual Data Entry Entering Data via Data Sheet view Removing Data Understanding Tables and Keys Creating a table in design view Data types (Text, Memo, Number, Currency, Yes/No, and Date/Time) Field Size Formatting Input Masks Understanding and Designating Keys Primary Keys Foreign Keys Composite Keys Natural v. Numeric Keys Understanding Relational Databases Understanding Basic Principles of Normalization Entities, Entity Classes, & Attributes Redundancy minimization Understanding and Creating Relationships Utilizing the Relationships Window Relationship Types One-to-many Adding a foreign key Forming the relationship Populate the foreign key Using two related tables in a report Many-to-many One-to-one Understanding  Referential Integrity Cascade Update Cascade Delete EOW: Practice Problem 1 EOW: Practice Problem 2 Module Capstone More Practice 1 Problem Solve 1 Problem Solve 2 Problem Solve 3 Perform in Your Life Perform in Your Career 1 Perform in Your Career 2 How Others Performed Module 2. Organizing the Storage of Turquoise Oasis Spa's Transactions Prepare Workshop 3:  Organizing the Storage of Spa Transactional Data Understanding Relational Databases Identifying the Advantages of the Relational Database over the Flat File database Understanding Basic Principles of Normalization Entities, Entity Classes, & Attributes Redundancy minimization Understanding and Creating Relationships Utilizing the Relationships Window Relationship Types Many-to-Many One-to-Many One-to-One Understanding Referential Integrity Cascade Update Cascade Delete Enforcing Evaluating Transactions at the Spa Finding data on using datasheet view Find feature Find with wildcards Simple Query Wizard and the limitations Creating a Multi-tabled Query using Design View Understand which tables to add to the view Adding Basic Criteria (Exact Match, Basic Operators, & AND/OR) Adding a simple Calculated Field using the Builder Adding Sum, Min, Max, & Average aggregation Using Other Query Wizards The Find Unmatched Query Wizard Using the wizard Understanding why the simple query wizard is unable to find this data Find Duplicates Query Wizard Cross tab query wizard EOW: Practice Problem 1 EOW: Practice Problem 2 Prepare Workshop 4: Developing a User Interface for Spa Transactions Creating Forms using the Form Wizard Moving and resizing controls Adding a subform on a tab control Enhancing with Conditional Formatting Navigating forms Printing forms Creating Reports using the Report Wizard Setting Printing Options Grouping & Sorting Adding Subtotals Printing Reports EOW: Practice Problem 1 EOW: Practice Problem 2 Module Capstone More Practice 1 Problem Solve 1 Problem Solve 2 Problem Solve 3 Perform in Your Life Perform in Your Career 1 Perform in Your Career 2 How Others Performed   Module 3 The Red Bluff Golf Club Pro Shop, Advanced Tables and QueriesPrepare Workshop 5: Advanced Tables Controlling the Way Data is Entered Advanced Field Options Using Input Masks Defining Input Masks Using the Input Mask Wizard Using Custom Formatting Defining Data Validation Rules Working with Captions Creating Indexes Defining a Single Field Index Defining Multiple Field Indexes Requiring Data Property Advanced Data Types Creating Lookup Fields Using the Lookup Field Wizard Lookup Field Properties Calculated Data Type Yes/No Data Type Autonumber (and preference for natural keys) Attachments, Hyperlinks, and OLE Objects Filtering Data Using the Table Analyzer Wizard EOW: Practice Problem 1 EOW: Practice Problem 2 Prepare Workshop 6: Utilizing Queries to Retrieve Business Data Advanced Criteria & Calculations Using Wildcard Characters in String Comparisons LIKE Function Wildcard Characters Find Records with the ""Most"" or ""Least"" Values Top Values Make a Query Ask for Input Using Parameters in a Query Specify Parameter Data Types Concatenate Function Not, In and Other Advanced Operators Advanced Functions in Queries If Functions Basic If Function for Individual Condition Nested If Functions for Various Conditions IsNull Function Working with Fields that Contain No Valid Data Dates Date versus Now Function Use DateDiff to Determine a Time Interval Use DateAdd to Subtract a Time Interval Use DateSerial to Return a Date (Year, Month, and Day) Use DatePart to Evaluate a Date Round Rounding to a Specific Number of Decimal Places Distinguishing Between Rounding and Formatting EOW: Practice Problem 1 EOW: Practice Problem 2 Module Capstone More Practice 1 Problem Solve 1 Problem Solve 2 Problem Solve 3 Perform in Your Life Perform in Your Career 1 Perform in Your Career 2 How Others Performed Module 4 The Turquoise Oasis Spa, Advanced Calculations and Action QueriesPrepare Workshop 7: Creating Business Information Using Aggregation with Advanced Calculations Understanding the GROUP BY Clause in Aggregated Calculations Calculating Sales Volume Using GROUP BY to Summarize Duplicate Data Understanding the WHERE Clause in Aggregated Calculations Calculating Sales Revenue Business Calculations Using Sub-Querying Creating a Query on a Query Calculating the Percentage of Sales Revenue Calculating the Percentage of Sales Volume Calculating Physical Volume Calculating the Percentage of Physical Volume Understanding Structured Query Language SELECT Statement Basics Viewing SQL Statements Creating a Basic SQL Query Using the WHERE Clause Using the HAVING Clause with AS and GROUP BY Creating a Union Query Creating a SQL Sub-query Creating a Crosstab Query Crosstab Query Wizard Editing a Crosstab Query EOW: Practice Problem 1 EOW: Practice Problem 2 Prepare Workshop 8: Action Queries and Advanced Relationships Understanding Action Queries Creating a New Table Creating a Make Table Query Running a Make Table Query Adding Data to a Table Creating an Append Query Running an Append Query Editing and Deleting Data Creating, Testing and Running Update Queries Simple Update Queries Complex Update Queries Creating, Testing and Running Delete Queries Simple Delete Queries Complex Delete Queries Advanced Relationships Using Multiple Tables Creating Inner Joins Creating Outer Joins Unmatched Query Wizard EOW: Practice Problem 1 EOW: Practice Problem 2 Module Capstone More Practice 1 Problem Solve 1 Problem Solve 2 Problem Solve 3 Perform in Your Life Perform in Your Career 1 Perform in Your Career 2 How Others Performed   Module 5 The Red Bluff Golf Course, Advanced Forms and ReportsPrepare Workshop 9: Customized Forms Advanced Form Settings Understanding the property sheet Understanding the data tab of the property sheet Understanding the format tab of the property sheet Changing tab order in a form Adding a title, logo, date, and time to a form Adding a footer to a form Modifying a form in design view Creating a form with a subform Adding fields to a form Adding calculated fields to a form Finding a record with a combo box Adding command buttons to a form Using buttons for record navigation Using buttons for form operations Advanced forms Creating a split form Creating a multiple items form Adding a chart to a form Creating  a PivotTable form Creating a PivotChart form EOW: Practice Problem 1 EOW: Practice Problem 2 Prepare Workshop 10: Customized Reports Design view Build a report with subtotals and totals Modify group footer Move and resize total fields Hide duplicate values Add and remove fields from a report Add totals to a report Hide detail on a summary report Decide when totals are inappropriate Parameter report Create a report with a query as source Add conditional formatting Create a report from a parameter query Create a report based on parameters in a form Create a form for entering parameters Add report buttons to a form Mailing labels Create mailing labels EOW: Practice Problem 1 EOW: Practice Problem 2 Module Capstone More Practice 1 Problem Solve 1 Problem Solve 2 Problem Solve 3 Perform in Your Life Perform in Your Career 1 Perform in Your Career 2 How Others Performed   Module 6 The Turquoise Oasis Spa, Creating a refined User ExperiencePrepare Workshop 11:  Navigation Forms and User Interface Navigation Forms View a Navigation Form Open and Use a Navigation Form Create a Navigation Form Use a Predefined Layout to Create a Navigation Form Modify a Navigation Form Add a Form Tab Delete a Form Tab Move a Form Tab Modify the Appearance of  a Form Tab Refining the User Interface Create a Main Menu Create a Navigation Form  for Main Menu Add Command Buttons to the Navigation Form Create Navigation Buttons on a Form Set Startup Display Options Making Changes to the Startup Options Test the Application View the User Interface as a User EOW: Practice Problem 1 EOW: Practice Problem 2   Prepare Workshop 12: Macros Understanding Macros Trusted Locations The Macro Designer Troubleshooting Macros Finding errors using Single-Step Automating Routine Tasks with Macros Export database objects with Filters Importing Data Run Action Queries Macro Groups Sub macros Key-assignment macro Auto Exec Macro Database Events Common events Sequence of events Embedding macros Data macros Table level events EOW: Practice Problem 1 EOW: Practice Problem 2     Module Capstone More Practice 1 Problem Solve 1 Problem Solve 2 Problem Solve 3 Perform in Your Life Perform in Your Career 1 Perform in Your Career 2 How Others Performed   Module 7. The Red Bluff Golf Course, Sharing the database and automating with Visual Basic for ApplicationsPrepare Workshop 13: VBA in Access VBA Basics What is VBA and Why Use it in Access Convert a Pre-Existing Macro to VBA Examine the VBA Formatting and Structuring VBA Code The DoCmd Object The TransferSpreadsheet Method Editing the Routine The FileDialog Object The With Statement If Statements in VBA Looping in VBA Creating VBA Routines Create an OnClick Event Using the Edit Toolbar and Adding Comments Error Handling and Debugging Compiling and Securing your VBA Compiling VBA Modules Working with ACCDE Files Password Protecting the VBA in a database EOW: Practice Problem 1 EOW: Practice Problem 2   Prepare Workshop 14: Implementing Your Database Implementing Databases Shared and Exclusive Modes Preparing the Database for a Single User Performance Analyzer Saving Access as  a Previous Version Preparing the Database for Multiple Users Linking and Refreshing Tables The Linked Table Manager The Database Splitter Encryption and Passwords Setting the User's Experience Controlling Navigation Options Special Keys Setting Startup Preferences Methods of Implementation EOW: Practice Problem 1 EOW: Practice Problem 2   Module Capstone More Practice 1 Problem Solve 1 Problem Solve 2 Problem Solve 3 Perform in Your Life Perform in Your Career 1 Perform in Your Career 2 How Others Performed   Appendix: Terra Cotta Brew, Normalizing a Database for Effective Design Appendix: Normalizing a Database for Effective Design Normalizing a Database Identifying Anomalies Satisfying the First Normal Form Satisfying the Second Normal Form Satisfying the Third Normal Form Joining tables with Relationships Understanding an Entity -Relationship Diagram   Perform in Your Career 1 How Others Performed  "

Reviews

Instructor Reviews of the Your Office Series !(Your Office is what) we have been waiting for. One that takes the students to the level of business, the way it is in the real world. Now the students can make a smooth transition from the classroom to that career. - Carla Jones, Middle Tennessee State University teaches students the skills they need in the workplace by having students create realistic documents, spreadsheets, presentations, and databases for real world scenarios. Students learn by practicing skills over multiple chapters and are given an opportunity to do critical thinking while working on assignments. - Rich Cacace, Pensacola State College Has students thinking, problem solving and invites them to look past the book ... adds value by leading them to understand where they could apply these skills in their day to day life. - Karen Allen, Community College of RI takes students through the entire process from learning the necessary features to actually being able to create documents without much direction--just like they will need to do at work! - Susan Holland, Southeast Community College It is a case-based Office application text that does a great job of covering just what we need. The organization of the text is fantastic and the end-of-chapter assessments are the best I have seen in a long time. - Gina Jerry, Santa Monica College Is a system that allows the student a heap of hands on work, with easy to follow instructions and simply explained figures. The hands-on experience is then translated to real world situations. - Linda Fried, University of CO-Denver Allows the students to learn application concepts (the Why!) and not just the pointing and clicking. - Susan Fry, Boise State Univ. ...pulls it all together. It starts with basic examples, provides practice, integrates their acquired knowledge and permits the student to perform well. - David Largent, Ball State Univ. touches on all levels of Bloom's taxonomy. As an educator, this is the greatest development of the 21st century! - Jennifer Nightingale, Duquesne Univ.

Instructor Reviews of the Your Office Series !(Your Office is what) we have been waiting for. One that takes the students to the level of business, the way it is in the real world. Now the students can make a smooth transition from the classroom to that career. - Carla Jones, Middle Tennessee State University teaches students the skills they need in the workplace by having students create realistic documents, spreadsheets, presentations, and databases for real world scenarios. Students learn by practicing skills over multiple chapters and are given an opportunity to do critical thinking while working on assignments. - Rich Cacace, Pensacola State College Has students thinking, problem solving and invites them to look past the book ... adds value by leading them to understand where they could apply these skills in their day to day life. - Karen Allen, Community College of RI takes students through the entire process from learning the necessary features to actually being able to create documents without much direction--just like they will need to do at work! - Susan Holland, Southeast Community College It is a case-based Office application text that does a great job of covering just what we need. The organization of the text is fantastic and the end-of-chapter assessments are the best I have seen in a long time. - Gina Jerry, Santa Monica College Is a system that allows the student a heap of hands on work, with easy to follow instructions and simply explained figures. The hands-on experience is then translated to real world situations. - Linda Fried, University of CO-Denver Allows the students to learn application concepts (the Why!) and not just the pointing and clicking. - Susan Fry, Boise State Univ. ...pulls it all together. It starts with basic examples, provides practice, integrates their acquired knowledge and permits the student to perform well. - David Largent, Ball State Univ. touches on all levels of Bloom's taxonomy. As an educator, this is the greatest development of the 21st century! - Jennifer Nightingale, Duquesne Univ.

Instructor Reviews of the Your Office Series ...(Your Office is what) we have been waiting for. One that takes the students to the level of business, the way it is in the real world. Now the students can make a smooth transition from the classroom to that career. - Carla Jones, Middle Tennessee State University teaches students the skills they need in the workplace by having students create realistic documents, spreadsheets, presentations, and databases for real world scenarios. Students learn by practicing skills over multiple chapters and are given an opportunity to do critical thinking while working on assignments. - Rich Cacace, Pensacola State College Has students thinking, problem solving and invites them to look past the book ... adds value by leading them to understand where they could apply these skills in their day to day life. - Karen Allen, Community College of RI takes students through the entire process from learning the necessary features to actually being able to create documents without much direction--just like they will need to do at work! - Susan Holland, Southeast Community College It is a case-based Office application text that does a great job of covering just what we need. The organization of the text is fantastic and the end-of-chapter assessments are the best I have seen in a long time. - Gina Jerry, Santa Monica College Is a system that allows the student a heap of hands on work, with easy to follow instructions and simply explained figures. The hands-on experience is then translated to real world situations. - Linda Fried, University of CO-Denver Allows the students to learn application concepts (the Why!) and not just the pointing and clicking. - Susan Fry, Boise State Univ. ...pulls it all together. It starts with basic examples, provides practice, integrates their acquired knowledge and permits the student to perform well. - David Largent, Ball State Univ. touches on all levels of Bloom's taxonomy. As an educator, this is the greatest development of the 21st century! - Jennifer Nightingale, Duquesne Univ.

Instructor Reviews of the Your Office Series ...(Your Office is what) we have been waiting for. One that takes the students to the level of business, the way it is in the real world. Now the students can make a smooth transition from the classroom to that career. - Carla Jones, Middle Tennessee State University teaches students the skills they need in the workplace by having students create realistic documents, spreadsheets, presentations, and databases for real world scenarios. Students learn by practicing skills over multiple chapters and are given an opportunity to do critical thinking while working on assignments. - Rich Cacace, Pensacola State College Has students thinking, problem solving and invites them to look past the book ... adds value by leading them to understand where they could apply these skills in their day to day life. - Karen Allen, Community College of RI takes students through the entire process from learning the necessary features to actually being able to create documents without much direction--just like they will need to do at work! - Susan Holland, Southeast Community College It is a case-based Office application text that does a great job of covering just what we need. The organization of the text is fantastic and the end-of-chapter assessments are the best I have seen in a long time. - Gina Jerry, Santa Monica College Is a system that allows the student a heap of hands on work, with easy to follow instructions and simply explained figures. The hands-on experience is then translated to real world situations. - Linda Fried, University of CO-Denver Allows the students to learn application concepts (the Why!) and not just the pointing and clicking. - Susan Fry, Boise State Univ. ...pulls it all together. It starts with basic examples, provides practice, integrates their acquired knowledge and permits the student to perform well. - David Largent, Ball State Univ. touches on all levels of Bloom's taxonomy. As an educator, this is the greatest development of the 21st century! - Jennifer Nightingale, Duquesne Univ.

Author Information

Amy S. Kinser, Esq., Series Editor Amy holds a B.A. degree in Chemistry with a Business minor and a J.D. from the Maurer School of Law both at Indiana University. After working as an environmental chemist, starting her own technology consulting company, and practicing intellectual property law, she has spent the past eleven years teaching technology at the Kelley School of Business in Bloomington, Indiana.   Currently, she serves as the Director of Computer Skills and Senior Lecturer at the Kelley School of Business at Indiana University.  She also loves spending time with her two sons, Aidan and J. Matthew, and her husband J. Eric.   Patti Hammerle Patti holds a bachelor’s degree in Finance and a master’s degree in Business from Indiana University Kelley School of Business. She is an adjunct professor at the Kelley School of Business in Indianapolis where she teaches The Computer in Business. In addition to teaching, she owns U-Can Computer Manuals, a company that writes and publishes computer manuals primarily for libraries to teach from.  She has also written and edited other computer application textbooks.   When not teaching or writing, she enjoys spending time with family, reading, and running. Dr. Diane Lending Diane Lending is a Professor at James Madison University where she has taught Computer Information Systems for eleven years. She received a Ph.D. in Management Information Systems from the University of Minnesota and a B.A. degree in mathematics from the University of Virginia. Her research interests are in adoption of information technology and information systems education.   She enjoys traveling, playing card and board games, and living in the country with her husband, daughter, and numerous pets.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions