Nelson Higher Education

Higher Education

Using Microsoft® Excel® and Access 2013 for Accounting, 4th Edition

  • Includes Student Data CD-ROM.
  • Glenn Owen
  • ISBN-10: 1285183479
  • ISBN-13: 9781285183473
  • 384 Pages | Paperback
  • Previous Editions: 2012, 2009, 2003
  • COPYRIGHT: 2015 Published
Request a Copy for Review

Overview

About the Product

USING EXCEL & ACCESS FOR ACCOUNTING 2013 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

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

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

  • 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, Rosey's Roses.

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

About the Author

Glenn Owen

Glenn Owen, B.A., C.P.A., recently retired from Allan Hancock College’s accounting and business faculty, where he guided students to an understanding of accounting and information systems for 21 years. In addition, Mr. Owen is a retired lecturer from 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. He also held 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 popular commercial accounting application. His innovative teaching style emphasizes the decision maker’s perspective and encourages students to think creatively. Mr. Owen's 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.

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.

New to this edition

  • All instructions and figures have been updated to match Microsoft® Office 2013. The new edition allows students to take advantage of the user-friendly design and features of Microsoft Office 2013 to prepare them for what they will see in the workplace.
  • Rosy's Roses is a new case that has been added to end-of-chapter homework to provide instructors with more assignment options.