Accounting Information Systems Laboratory

Learning Outcomes

On successful completion of this course, student will be able to: Explain the function of database management systems, structure of database objects that store accounting events, and identify the define a table’s structure, enter data into a table and modify a table’s datasheet display properties; Create actions queries, parameter queries, queries involving a single table and many table, and create form and subform from queries and tables, and create a report using the report wizard and create a multitable report; Record a value system model, value chain model of an enterprise and a Microsoft Access database based on business process models and a model of the sales/collectiom business process in a Microsoft.

Topics

1. Database and Accounting Systems
2. Creating, Populating and Displaying Tables
3. Creating and Using Queries, Form and Reports
4. Introduction to Data Modeling for Accounting Information Systems
5. Sales/collection Process
6. Acquisition/payment Process
7. Human Resources Process
8. Financing Process