Request for consultation

Thanks for your request. You’ll soon be chatting with a consultant to get the answers you need.
{{formPostErrorMessage.message}} [{{formPostErrorMessage.code}}]
First Name is required. 'First Name' must contain at least 0 characters 'First Name' cannot exceed 0 characters Please enter a valid First Name
Last Name is required. 'Last Name' must contain at least 0 characters 'Last Name' cannot exceed 0 characters Please enter a valid Last Name
Institution is required.
Discipline is required.
Why are you contacting us today? is required. 'Why are you contacting us today?' must contain at least 0 characters 'Why are you contacting us today?' cannot exceed 0 characters Please enter a valid Why are you contacting us today?

Overview

USING EXCEL & ACCESS FOR ACCOUNTING 2010 teaches students how businesses use spreadsheets and databases in accounting. It explains how to use these tools in solving real accounting problems and is written in a step-by-step format, with plenty of screenshots making it easy to follow. This textbook presents a tour of Microsoft Excel, along with an explanation of how that software is used in business. Next, a "Basics" chapter provides students with an immediate opportunity to begin using Excel with a real accounting problem and concept. The same process follows for chapters that teach Microsoft Access.

Glenn Owen, Allan Hancock College & UC Santa Barbara

Glenn Owen, BA, CPA, recently retired from Allan Hancock College’s Accounting and Business faculty, where he lectured on accounting and information systems for 21 years. In addition, he is a retired lecturer at the University of California at Santa Barbara, where he taught accounting and information systems courses from 1980 to 2011. His professional experience includes five years at Deloitte & Touche as well as vice president of finance positions at Westpac Resources, Inc. and Expertelligence, Inc. An acclaimed and well-respected author, Mr. Owen is well known for his QuickBooks® texts, which offer self-paced case-based instruction on the use of this commercial accounting application. His innovative teaching style emphasizes the decision maker’s perspective and encourages students to think creatively. His graduate studies in educational psychology and his 40 years of business experience yield a balanced blend of theory and practice that permeates and strengthens all of his books.
  • All instructions and figures have been updated to match Microsoft® Office 2010. The new edition allows students to take advantage of the user-friendly design and features of Microsoft Office 2010 to prepare them for what they will see in the workplace.
  • New Chapter: "Other Topics: Present/Future Values, Predicting Costs, & Allowance for Uncollectable Account" has been added to the Excel section of the book to help students make calculations and create projections.
  • New Student Demo Videos: The author has created many student demonstration videos to help students visualize Excel and Access processes. Students will see icons in the margin throughout the textbook that reference these videos. The videos include audio and show step-by- step illustrations of business processes explained in this text. Videos are available at no additional cost on the companion web site: www.cengage.com/accounting/owen.
  • New Grading Rubrics: These help instructor's grade cases in the end-of-chapter material and link each case requirement and event to a specific student learning outcome. These rubrics will be available on the instructor companion web site: www.cengage.com/accounting/owen.
  • Snick's Board Shop is a new case that has been added to end-of-chapter homework to provide instructors with more assignment options.
  • The text's step-by-step format keeps students on track, with plenty of screen shots making it easy to follow.
  • A case featuring Wine Depot carries throughout all chapters. Through this case, students gain experience using Excel and Access with realistic information. New to this edition is another case, Snick's Board Shop.
  • The documenter feature in Microsoft Access allows students to prove they have made important control changes like input masks, validation rules and default values. Excel's grouping feature expands the student's understanding of budget development.
  • A continuing case problem is used within the chapter presentation that helps students see the application of Excel and Access features while encouraging real experience with the software.
  • "Trouble?" paragraphs anticipate likely questions and provide students with the information necessary to resolve the problem and continue on.
1. Excel Tour.
2. Excel Basics.
3. Financial Statement Analysis.
4. Depreciation.
5. Loan and Bond Amortization.
6. Cash Budgeting.
7. Other Topics: Present/Future Values, Predicting Costs, & Allowance for Uncollectable Accounts.
8. Access Tour.
9. Access Basics.
10. Tables.
11. Queries.
12. Forms.
13. Reports.

Textbook Only Options

Traditional eBook and Print Options

{{collapseContainerClosed['detail_0'] ? 'Show More' : 'Show Less'}}
z

  • ISBN-10: 1133466133
  • ISBN-13: 9781133466130
  • STARTING AT $17.99

  • STARTING AT $102.49

  • ISBN-10: 1111532672
  • ISBN-13: 9781111532673
  • Bookstore Wholesale Price $138.00
  • RETAIL $183.95

Cengage provides a range of supplements that are updated in coordination with the main title selection. For more information about these supplements, contact your Learning Consultant.

FOR INSTRUCTORS

Working Papers Study Guide, Chapters 1-12

ISBN: 9781111530211
With quality content consistent with the text, the study guide contains chapter outlines linked to the learning objectives and assignments in the text. These include review questions, exercises, and problems. The working papers are designed to help you successfully complete the end-of-chapter exercises and problems. Available in print.

Working Papers with Study Guide, Chapter 13-24

ISBN: 9781111530204
With quality content consistent with the text, the study guide contains chapter outlines linked to the learning objectives and assignments in the text. These include review questions, exercises, and problems. The working papers are designed to help you successfully complete the end-of-chapter exercises and problems. Available in print.

Instructor's Resource CD-ROM

ISBN: 9781111531362
This powerful resource tool contains the content from the Instructor's Resource Solutions Manual as well as PowerPoint® lecture slides, solutions to Excel template problems, Chapter Quizzes, and ExamView® testing software. A computerized version of the test bank, ExamView®, is available to adopters of College Accounting, 11e. This program is an easy-to-use test creation software compatible with Microsoft Windows. Instructors can add or edit questions, instructions, and answers, and select questions by previewing them on the screen, choosing them randomly, or choosing them by number. Instructors can also create and administer quizzes online, whether over the Internet, a local network (LAN), or a wide area network (WAN). ExamView® is available only on the Instructor's Resource CD-ROM. PowerPoint Lecture slides enhance lectures and simplify class preparation. Each chapter contains the learning objectives along with figures directly from the text and practice exercises to help you create a powerful, customizable tool. PowerPoint slides available on the IRCD and the companion website.

Instructor's Resource and Solutions Manual, Chapters 1-12

ISBN: 9781111532017
This helpful guide provides suggested homework check questions, teaching and learning objectives, key points, lecture outlines, demonstration problems, responses to discussion questions, and solutions to all text exercises, problems, and activities. Also included are transition guides from the 10th to 11th edition, reviews of T Account Placement and Representative Transactions, chart to gauge the difficulty levels of assignments and estimate student completion time and suggested abbreviations for account titles. The IRSM is available in print, electronically on the instructor resource CD-ROM and password protected section of the text's companion website.

Instructor's Resource and Solutions Manual, Chapters 13-24

ISBN: 9781111532000
This helpful guide provides homework check questions, teaching and performance objectives, key points, lecture outlines, demonstration problems, responses to discussion questions, and solutions to all text exercises, problems, and activities. Also included are reviews of T Account Placement and Representative Transactions, suggested abbreviations for account titles, answers to study guide questions, blank master forms, and tools to gauge the difficulty levels of assignments and estimate student completion time. The IRSM is available in print, electronically on the instructor resource CD-ROM and password protected section of the text's companion website.

Solutions Transparencies Chapters, A Problems 1-12

ISBN: 9781111534592
Contains solutions for the Series A Exercises, Problems, Accounting Cycle Review Problem (chapter 5) and Comprehensive Review Problem (chapter 12). Product printed on acetate for use on an overhead projector.

Solutions Transparencies Chapters, A Problems 13-24

ISBN: 9781111534608
Contains solutions for the Series A Exercises. Product printed on acetate for use on an overhead projector.

Test Bank, Chapters 1-12

ISBN: 9781133190486
Revised and verified to ensure accuracy, the test bank includes questions now clearly identified by Topic, learning objectives, level of difficulty, AACSB, Blooms Taxonomy, AICPA and ACBSP standards to allow greater guidance in developing assessments and evaluating student progress. The test bank has also been increased by an average of 107%. All multiple choice questions were increased to 60 questions for chapters 1-12 and increased to 40 multiple choice questions for chapters 13-24. The test bank is available in print, electronically on the instructor resource CD-ROM and on the password protected section of the text's companion website.

Test Bank, Chapters 13-24

ISBN: 9781133190493
Revised and verified to ensure accuracy, the test bank includes questions now clearly identified by Topic, learning objectives, level of difficulty, AACSB, Blooms Taxonomy, AICPA and ACBSP standards to allow greater guidance in developing assessments and evaluating student progress. The test bank has also been increased by an average of 107%. All multiple choice questions were increased to 60 questions for chapters 1-12 and increased to 40 multiple choice questions for chapters 13-24. The test bank is available in print, electronically on the instructor resource CD-ROM and password protected section of the text's companion website.

FOR STUDENTS

Working Papers Study Guide, Chapters 1-12

ISBN: 9781111530211
With quality content consistent with the text, the study guide contains chapter outlines linked to the learning objectives and assignments in the text. These include review questions, exercises, and problems. The working papers are designed to help you successfully complete the end-of-chapter exercises and problems. Available in print.

Working Papers with Study Guide, Chapter 13-24

ISBN: 9781111530204
With quality content consistent with the text, the study guide contains chapter outlines linked to the learning objectives and assignments in the text. These include review questions, exercises, and problems. The working papers are designed to help you successfully complete the end-of-chapter exercises and problems. Available in print.