Computer Applications: Accounting

Course Code: ACCT 150

Academic Year: 2020-2021

This course is designed to give the students intermediate level knowledge 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. Format Excel worksheets to clarify, emphasize and 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; and 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, at either 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.