Standard

R State Standard £ Developed College: n/a

ACC 157 – Integrated Accounting Management Systems

Course Description:

Emphasizes use of database management packages, electronic spreadsheet packages, and accounting software packages for accounting/financial applications with more advanced systems. Topics include: creation and management of database applications, creation and management of spreadsheet applications, and creation and management of accounting integrated software systems.

Competency Areas:	Hours:
Database Management Applications	Class	2
Spreadsheet Management Applications	D. Lab	8
Accounting Integrated Systems Applications	P. Lab/O.B.I.	0
	Credit	6
Prerequisite: ACC 106, ACC 103, ACC 104 Corequisite:

Course Guide

Competency	After completing this section, the student will:	Hours
		Class	D. Lab	P. Lab/ O.B.I.
DATABASE MANAGEMENT APPLICATIONS		4	16	0
Database files creation	Manage and print a database file
Tables and queries creation	Create and print tables and queries
Forms and reports creation	Create and print forms and reports
Sharing database files	Transfer database files to other software systems
SPREADSHEET MANAGEMENT APPLICATIONS		6	24	0
Spreadsheet files creation	Manage and print spreadsheet files
Formatting, formulas, and function creations	Use proper formatting techniques, correct formulas, and appropriate functions
Enhancing charts and worksheets	Create and use charts and enhanced worksheets presentations
Using advanced features of spreadsheet software	Use a variety of advanced features available with the spreadsheet software package
Sharing spreadsheet files with other software packages	Transfer spreadsheet files to other software systems
Preparing accounting/financial problems with spreadsheet software	Create and manage accounting solutions to problems using a variety of spreadsheet features
ACCOUNTING INTEGRATED SYSTEMS APPLICATIONS		10	40	0
Create company files	Create new or convert from a manual system the accounting files to establish a computerized file for a company
Manage all areas of a computerized accounting software system	Manage accounts receivable, payable, payroll, taxes, adjusting and closing entries, inventory, and other accounting systems as necessary to complete a full accounting cycle for a service, merchandise, or manufacturing company
Generate financial statements, management reports, and charts	Manage and print all essential financial statements, managerial reports, tax and payroll reports, and display charts and other statistical information

Suggested Resources

Media (Print Audio/Visual Web Other)	Note: Please adhere to the APA Formatting and Style Guidelines. Examples: Author, A. A. (Year of publication). Title of work: Capital letter also for subtitle. Location: Publisher. Duncan, G.J., & Brooks-Gunn, J. (Eds.). (1997). Consequences of growing up poor. New York: Russell Sage Foundation.
Print	Horne, J. (2008). Computerized Accounting with Quickbooks Pro 2008. Upper Saddle River, NJ: Prentice Hall.
	Smith, G. (2008). Excel Applications for Accounting Principles. Mason, OH: Cengage.

Posted: 08/26/08