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.
Courses may not be offered each semester. Be sure to check the listing, to make sure you have the Online section of the course, as in-class can be listed as well. To verify whether this course is being offered this semester and the fees, please contact the Registrar's Office at 416-675-5000 or check the website http://humber.ca/search/ce/courses.html for further information.