Course Overview

In this course you will become proficient in Microsoft Access. You will receive instruction in relational database, creating tables with data, extracting information using queries, designing forms and creating reports, advanced queries including action queries, advanced form and reports including sub forms and sub reports, import/export, and much more. You will work through many real-life business examples.

We welcome auditing student.*

* Provided there is space available on the first class, undecided students may join the first half of class to observe. Please contact us to schedule in advance.

  • Working in the Access Window
  • Understanding Database Basics
  • Creating Database Tables
  • Entering Records
  • Finding Data
  • Understanding Table Relations
  • Modifying Tables and Fields
  • Creating Forms
  • Creating Reports
  • Sorting Data within a Report
  • Filtering Data within a Report
  • Using Control’s in Report’s and Forms
  • Creating Conditional Formatting Control’s based on a Value
  • Arranging Control Layouts

About the Course

Classes are held in a Computer Lab equipped with Microsoft Office Suite 2010

Completion

  • Certificate of Completion
  • Tax Receipt Form for tuition fees for courses taken in the calendar year. To qualify, the fees must be more than $100 for the year.

Prerequisite

Basic knowledge of Windows

About the Instructor

Sujeewa Abeyasinghe is a friendly, patient, client-oriented instructor with more than ten years in the Canadian Banking and Finance industry. He is dedicated to making his students feel comfortable in their learning environment and strives to ensure that every student is engaged and active in class while allowing them to progress at their own pace.

Students benefit from his strong accounting background and broad experience using Microsoft Office in real work situations. He is an excellent communicator with good leadership and mentoring skills combined with a strong work ethic.

You can benefit from Sujeewa’s wide experience and acquire the skills you need to be successful in your own career.

Next Session:

Nov 18, 2017 |Toronto
Saturdays | 9:00 A.M. – 2:00 P.M. (2 weeks, 10 Hours)

star1star1star1star1star1 – Former Student

“I like Sujeewa’s teaching style and his instructions are precise and easy to understand/ follow. Sujeewa is very knowledgeable about the MS Office Suite. He is patience, has very good interpersonal skills and makes students comfortable. I would take additional courses with him and would recommend this course to my friends/colleagues.”

star1star1star1star1star1 – Former Student

“I really liked my instructor Sujeeva, he had been a wonderful instructor and I would recommend Skills for Change to all my friends”

star1star1star1star1star1 – Former Student

“Our instructor was really patient, he was explaining things individually when we need it. He is the instructor to keep in mind when you want to attend more courses.”

star1star1star1star1 – Former Student

“The course os very helpful. Would like to see more options related to high end courses in Excel, word and Access. Like, How to use macros in them and more. So advanced courses in MS Office (Word, Excel, Access) or even Microsoft Visio would be great addition.”