Using Microsoft® Excel® and Access 2013 for Accounting

  • Includes Student Data CD-ROM.
  • AUTHOR: Glenn Owen
  • ISBN-13: 9781285183473 
  • Grade(s): 9 | 10 | 11 | 12
  • 384 Pages  Paperback 
  • 4th Edition  |  Previous Editions: 2012, 2009, 2003
  • ©2015     Published
  • Prices are valid only in the respective region

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

  • 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.
  • 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.
  • Rosy's Roses is a new case that has been added to end-of-chapter homework to provide instructors with more assignment options.
  • 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 Contributor

AUTHOR
  • Glenn Owen

    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.

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.