This course introduces the students to relational databases with Microsoft Access. The course starts with an overview of Microsoft Access and databases in general. Students will learn the fundamental features of relational database and how databases are used to store related information and query the information. After learning how to create and modify a database and work with records, students will learn to sort data and filter to a database. Students will then explore the different ways to query a database and extract the information based on different criteria. Subsequent to working with multi-table databases, students will then learn to work with different types of functions to manipulate data, forms to input data into a database and reports to display data.

Students work with basic and more advanced features of Microsoft Outlook to manage messages for efficient communication, maintain personal and business contacts, and organize appointments and tasks.

This course is an introduction to the fundamental principles and practices of accounting as a device for reporting business activity. It provides the student with an understanding of the underlying theory and principles of accounting. The construction of financial statements as they evolve from business transactions and records is emphasized using the rules of double-entry bookkeeping. In addition, adjusting journal entries and everyday transactions for both service and retail businesses are recorded coupled with the preparation of basic financial statements.

• Introduction to Accounting
• Financial Statements and Accounting Transactions
• Analyzing and Recording Transactions
• Adjusting Accounts for Financial Statements
• Completing the Accounting Cycle and Classifying Accounts

Accounting procedures in a computerized environment are examined using the General, Payables and Receivables modules of Sage 50 Accounting: general ledger setup, accounts receivable setup, accounts payable setup, recording of transactions using sage 50 accounting, and period end procedures using Sage 50 accounting.

The workplace of the twenty-first century demands excellent communications skills. The focus of this course is on learning writing techniques that ensure effective business communication: Achieve an effective style by using precise verbs, concrete nouns, and vivid adjective; Write memorandums and e-mail messages that deliver information and make requests; Write letters and memorandums that request information concisely and promote goodwill; Apply skillful writing techniques in refusing requests; Compose carefully planned sales letters; Write letters of appreciation, congratulation, sympathy, recommendation, and introduction; Write effective formal and informal reports ;Write a formal report including data, using tables, charts, and graphs.

The daily routines of a modern business office are examined, and the skills necessary to assist in the smooth operation of the office are presented in this course. A variety of presentation methods may be used including lecture, discussion, role plays, case studies and work simulations.

Project Management is of paramount importance to all organizations to improve effectiveness and efficiency. This course utilizes the popular Microsoft Project applications program with realistic case studies and step-by-step guidance.

• Project Management Phases and Goals
• Compare the Gantt Chart and Network Diagram Views
• Enter and Edit Tasks, Durations, and Task Dependencies
• Expand, Collapse, Move, and Filter Tasks in Network Diagrams
• Assign Resources and Costs to Tasks
• Update Tasks that are on Schedule or Behind Schedule
• Update Tasks that are Ahead of Schedule or Partially Complete
• Copy and Export Project Data to other Microsoft Office Applications
• Copy and Import Project Data from other Microsoft Office Applications

This course is designed to equip students with interpersonal skills identified by employers as essential for success in the professional world. Using a variety of instructional methods including case studies, group exercises, and discussion, students learn and practice key communication skills.

In addition to learning career-oriented skills, students learn how to get a job in their chosen profession. Our Employment Services department will assist the graduate in resume writing, as well as preparing for job interviews. Our staff is sensitive to current job market trends and the needs of employers in each local market. Our graduates receive guidance and training to use career tools that help job seekers build a better resume and cover letter, manage an online portfolio, hone interviewing skills, and develop a personal brand online. Students will have the use of a computer lab which has unlimited Internet access, as well as job search resources. Facilitators will also be made available to advise on job finding resources, interview skills and techniques and to carry out mock interviews. This course also looks at the planning, preparation, execution, and follow-up stages of an interview: How people find jobs; Employer expectations; Presenting an enthusiastic attitude; Focusing on the right job and the hidden job market; Transferrable skills; Thank you letters; Effective telemarketing; Handling objections, self-confidence, and self-esteem; Individual counselling and coaching.