Description
What if you could integrate two critical business software programs into your accounting classroom without using confusing and complicated manuals? What if your students could use these programs to reinforce basic accounting concepts in an interactive case setting? What if you could do both without spending a fortune and a vast amount of time preparing examples, cases, and illustrations? Excel and Access for Accounting is a textbook that fulfills and expands upon all three of these ”what ifs.”
Why Is This Textbook Needed?
Many accounting educators are looking for ways to incorporate more business software into their accounting curriculum without displacing basic accounting instruction. They have tried to accomplish this by creating a stand-alone computer- based course, a lab component course, or by adding business computer software to their regular accounting curriculum. Current texts in this field are very generic in nature, spending little if any time on accounting-specific issues. Those that do address accounting issues address only worksheet or database issues but not both. Some texts that have a worksheet focus deliver a wide array of financial and managerial topics but lack a natural case flow. Some with a database focus emphasize the creation of accounting systems but do not address how databases are used to support the accounting function.
Moreover, employers expect today’s college student to be computer literate in commercial accounting, worksheet, and database software. The demand for this type of training is growing daily as more and more businesses employ business software to solve real-world problems.
Instructors often want to incorporate business software into the first course but are reluctant to invest the time and effort necessary to accomplish this goal. Existing materials are often ”preparer” driven in that they focus on the creation of worksheets and databases without addressing the effective use of these tools. Students are often discouraged in their use of computers because of the complicated and confusing manuals that concentrate on using the software without any business or accounting context.
This text responds to all of those needs. It provides a self-paced, step-by-step
environment in which the students use a worksheet (Excel) and a database
(Access) to solve real accounting and business problems. The text is designed
to reinforce the concepts students learn in their first accounting courses and to
show how worksheets and databases can help users make better and more
informed business decisions.
Brief Contents
Preface vii
Part 1 Excel for Accounting 1
Chapter 1 Excel Tour 3
Chapter 2 Excel Basics 24
Chapter 3 Financial Statement Analysis 60
Chapter 4 Depreciation 85
Chapter 5 Loan and Bond Amortization 107
Chapter 6 Cash Budgeting 131
Chapter 7 Other Topics: Present/Future Values, Predicting Costs, and Allowance for Uncollectible Accounts 160
Part 2 Access for Accounting 185
Chapter 8 Access Tour 187
Chapter 9 Access Basics 199
Chapter 10 Tables 232
Chapter 11 Queries 264
Chapter 12 Forms 308
Chapter 13 Reports 343
Index 370