ACC 162 - Microsoft Excel and Access in Accounting Applications

Description: Use of the spreadsheet software Microsoft Excel and the database software Microsoft Access in the analysis of financial data and generating accounting reports.

Prerequisites: CSA 126  (or CSA 138  and CSA 139  ) AND ACC 121  or ACC 131  

Recommended preparation: ACC 131  and ACC 132  

Credits: 3
Lecture: 3
Lab: 0

Course Content:

1. Excel financial statements
2. Excel depreciation charts
3. Excel amortization schedules
4. Excel budgets
5. Graphs in Excel
6. Access tables
7. Access queries
8. Access forms
9. Access reports

1. Analyze financial statements using Excel functions and formulas. (1)
2. Use Excel to complete straight line, double-declining, and sum of the year's digits depreciation schedules. (2)
3. Produce amortization schedules with Excel. (3)
4. Develop budgets and forecasts using Excel. (4)
5. Design, save, and print graphs in Excel. (5)
6. Develop and modify Access tables to organize financial data. (6)
7. Extract data using Access queries. (7)
8. Create Access forms to facilitate user input of financial information into a database. (8)
9. Create, modify, save, and print Access reports. (9)