Standard
|
ACC 157 –
Integrated Accounting Management Systems
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/Corequisite: ACC 106, ACC 103, ACC 104, SCT 100 |
|
|
|
|
|
|
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 |
|
|
|
|
|
Formatting, formulas, and function creations |
|
|
|
|
|
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
|
Microsoft Access
2000-Illustrated Series; (2000) Lisa Friedrichsen;
Course Technology/Thomson Learning;
Microsoft Access 97
Projects; (1997) Harry L. Phillips and Stan Dobrawa;
Course
Microsoft Excel 2000-Illustrated Series;
(2000) Elizabeth E. Reding and Tara L. O’Keefe; Course
Technology/Thomson Learning;
Excel Spreadsheet Applications for
Accounting Principles (2000) Gaylord Smith; South-Western College/Thomson
Learning;
The Coddled Canine; (2002) Anne Tippett;
South-Western/Thomson Learning;
Computerized Accounting with Quickbooks Pro 2000 and
2001; (2001) Janet Horne; Prentice Hall;
Microsoft Excel 2000 Comprehensive. 2000 edition. Course Technology. Parsons.