Computer Applications: Accounting

Course Code

ACCT 150

Academic Year

2016-2017

This course is designed to give the students an intermediate level of MS Excel 2010 and MS Access 2010.Upon completion of this course, the successful student will be able to:
1. Recognize business situations where Excel could be applied using scenarios, links, and collaboration.
2. Build and edit Excel worksheets for accounting applications.
3. Be able to format Excel worksheets to clarify, emphasize and overall, enhance the readability of business information.
4. Recognize business situations where Access could be usefully applied.
5. Plan a database and create the resultant tables with relationships to meet a business situation.
6. Plan and create advanced queries to answer specific questions which require the isolation of subsets of data to arrive at the answer.
7. Plan and create useful forms to facilitate the inputting and viewing of information using form design guidelines.
8. Plan and create useful and professional business reports with sorting, and grouping levels drawing on queries and related tables.

Please note that students who choose to take an online section of this course must write the final exam in person (either at the Humber North or Lakeshore campus, or (if located more than 100km from the campus) through an approved proctoring facility. Any costs associated with this are the sole responsibility of the student.