Higher Education

Using Excel & Access for Accounting 2010, 3rd Edition

  • includes Student Data CD-ROM
  • Glenn Owen Allan Hancock College
  • ISBN-10: 1111532672  |  ISBN-13: 9781111532673
  • 384 Pages
  • © 2012 | Published
  • College Bookstore Wholesale Price = $103.00
  • Newer Edition Available
  *Why an online review copy?
  • It's the greener, leaner way to review! An online copy cuts down on paper and on time. Reduce the wait (and the weight) of printed texts. Your online copy arrives instantly, and you can review it anytime from your computer or favorite mobile device.

If you prefer a print copy to review, please contact your representative.



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.

Features and Benefits

  • 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.
  • The text's step-by-step format keeps students on track, with plenty of screen shots making it easy to follow.

Table of Contents

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.

What's New

  • 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.

Meet the Author

Author Bio

Glenn Owen

Glenn Owen is a tenured member of Allan Hancock College’s Accounting and Business faculty, where he has lectured on accounting and information systems since 1995. 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.