Using Microsoft® Excel® and Access 2016 for Accounting

Glenn Owen, B.A., CPA, recently retired from Allan Hancock College. As part of the accounting and business faculty, he guided students to understand accounting and information systems for 21 years. Mr. Owen is also 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.

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.