- 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.
Using Excel & Access for Accounting 2010, 3rd Edition 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.
Key Features
- 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.
New to this edition
- 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.
About the Author
- 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 lecturer at the University of California at Santa Barbara, where he has been teaching accounting and information systems courses since 1980. He also has been a lecturer at the Orfala College of Business at Cal Poly San Luis Obispo, teaching financial and managerial accounting courses. His professional experience includes spending five years at Deloitte & Touché, as well as holding the position of vice president of finance at Westpac Resources, Inc., and Expertelligence, Inc. He has authored many Internet-related books and accounting course supplements and is currently developing online accounting instruction modules for his Internet-based financial accounting courses. Mr. Owen recently released: Using Peachtree Complete 2012 For Accounting, Using Quickbooks Pro 2012 For Accounting and a new edition of Using Excel And Access For Accounting 2010 text, which gives accounting students specific self-paced instruction on the use of spreadsheets and database applications in accounting. His innovative teaching style emphasizes the decision maker's perspective and encourages students to think creatively. His graduate studies in educational psychology and his 35 years of business experience yield a balanced blend of theory and practice.
Book Details
- Paperback: 368 pages
- Publisher: Cengage Learning; 3 edition (February 3, 2011)
- Language: English
- ISBN-10: 1111532672
- ISBN-13: 978-1111532673
- Product Dimensions: 10.9 x 8.9 x 0.6 inches
List Price: $97.95