Overview

Introduction

Learn your database fundamentals with Microsoft Access! You have your data and want to use the computer to organize it in ways that will allow you to capture, manipulate and analyze it easily.

Course Description

Microsoft Access allows you to capture, manipulate and analyze data easily. Learn the fundamental concepts, terminology, objects and tools that make up a database. Design and create tables, queries, forms and reports, and get an introduction to the standard language of databases: SQL.

Duration: 12 hours

Register for this course

[edit] Theoretical

• Data Normalization
• Database terminology
• Tables
• Relationships
• Access 2010 / 2007 User Interface
• Queries
• Forms
• Reports

[edit] Practical

• General
  • Create Access databases
  • Open database objects in multiple views
  • Move among records
  • Format datasheets
• Creating and Modifying Tables
  • Add a predefined input mask to a field
  • Create Lookup fields
  • Modify field properties
• Creating and Modifying Queries
  • SELECT queries
    • Multiple Tables
    • Calculated expresssions
• Creating and Modifying Forms
  • Create/Display Forms
  • Modify Form properties
• Viewing and Organizing Information
  • Enter, edit, and delete records
  • Create queries
  • Sort records
  • Filter records
• Defining Relationships
  • Create one-to-many relationships
  • Enforce referential integrity
• Producing Reports
  • Create and format reports
  • Add calculated controls to reports
• Preview and print reports
• Integrating with Other Applications
  • Import data to Access
  • Export data from Access

Prerequisites

Please note: We will be using Access 2010 during this course. If you are using Access 2003 or earlier, you will find that the principles will be applicable, but the user interface will be different.

Some experience with Microsoft Windows and a mouse.

Experience with Excel will be an asset but is not required.

• Course Outline

• Getting Ready MindMap
• Learning MindMap
• MindMaps MindMap
• Install LiveMeeting Client
• Test LiveMeeting (restart Internet Explorer after this step)
• Join LiveMeeting

• MaxiVista Viewer A version 4011

Courses Coming

• Downtown Robson Square
• Main Campus David Lam

Upcoming Courses

Overview

Course Description

Starting with data in various forms including ASCII text files, Excel spreadsheets, and existing Access databases, you will examine typical problems that arise when dealing with data that is not appropriately formatted. You will examine advanced topics relating to table maintenance, queries, forms, reports, relationships between tables, and exports to different file types. Along the way, we will address issues and problems that are relevant to more experienced Access users (SELECT, UPDATE, DELETE, queries and Macros for more multi-step procedures).

Duration: 12 hours

Register for this course

For announcements please check the links to Twitter and Facebook at the right side of this page.

Objectives

Theoretical Considering Client/Server modes in Access Rethinking your database design Better Tables Queries Forms Reports

Practical Table Design Query Design Form Design Report Design Importing and Linking to External Data Dealing with duplicate records orphaned records compound data in columns archiving old records Macros in Access - an introduction

Prerequisites

Academic We will be relying on material covered in the prerequisite course so you must have completed the following: Access: Introduction

Practical A minimum of 6 months experience with Access is highly recommended.

• Getting Ready MindMap
• Learning MindMap
• MindMaps MindMap
• Install LiveMeeting Client
• Test LiveMeeting (restart Internet Explorer after this step)
• Join LiveMeeting

• MaxiVista Viewer A version 4011

• Course Outline MindMap
• Client Server MindMap

Courses Coming

• Downtown Robson Square
• Main Campus David Lam

Upcoming Courses

Overview

Introduction

Excel is the spreadsheet component of Microsoft Office and it is an extremely versatile tool for manipulating numeric data, creating charts and sorting and filtering text data.

Course Description

With Excel you can:

• Work with your numeric data
• Display it as charts
• Manipulate non-numeric data as tables like you can in many database products

In this hands-on introductory workshop you will examine spreadsheet principles, entering data, creating formulas, designing worksheets, charting, data management and printing. Several applications for Excel are explored using examples and case studies   

Duration: 12 hours

Register for this course

Theoretical Objectives History and applications for worksheets Creating formulas Formatting to add meaning Functions (structure and use) Charts for communication Database terminology & applications

Practical Objectives Worksheets for manipulating numeric data Formatting Creating and modifying Charts Creating and modifying Data tables (edit, sort and filter) Budget Models Decision Support Tool

Prerequisites

Prerequisites

Some experience with Microsoft Windows and a mouse.

Downloads

Note: The password to open these files is in your notes.

• Windows download
  • Save this shortcut to your Desktop (optional)
• Mac download - Stuffit required to open (free version works fine)
• Service Pack for "EXCEL.EXE is not a valid Win32 application"

• Getting Ready MindMap
• Learning MindMap
• MindMaps MindMap
• Install LiveMeeting Client
• Test LiveMeeting (restart Internet Explorer after this step)
• Join LiveMeeting

• MaxiVista Viewer A version 4011

• Course Outline MindMap
• Client Server MindMap

Courses Coming

• Downtown Robson Square
• Main Campus David Lam

Upcoming Courses

Overview

Introduction

You have  been working with Excel for a while, (more than six months) and you have experienced some or all  of the following symptoms:

• Large worksheets are difficult to navigate and manage
• Work that made perfect sense when you created it is difficult to fathom when revisited
• Sharing your worksheets with others has led to a new role for you... software support technician
• You are certain that there have to be better ways to do things, but you haven't got time to find them
• As you get better at working with Excel, you want to expand your Excel vocabulary so you can recognize new opportunities to apply this tool to your work   

Course Description

This course covers planning and designing worksheets, protecting files, working with large and multiple worksheets, named ranges, built-in and user-defined functions, macros, data functions, pivot tables, and integration for Excel with other Microsoft Office products. The course includes templates that can be modified.  Duration: 12 hours

Register for this course

Theoretical Objectives Worksheet Designers and Worksheet Users Large Worksheets Protecting Your Work Formats / Custom Formats Templates Multiple Sheets - 3 D Issues Documentation Functions (anatomy, applications, user defined) Lookup functions Names Goal Seeking and Solver Scenarios Macros Database operations Charting Pivot Tables

Practical Objectives In addition to Theoretical Objectives Create models and templates

Prerequisites

Excel Introduction or equivalent practical experience.

Downloads

Note: The password to open these files is in your notes.

• Excel II Sample files (Windows format)
  • Save this shortcut to your Desktop (optional)
• Mac download - Stuffit required to open (free version works fine)
• Service Pack for "EXCEL.EXE is not a valid Win32 application"

• Getting Ready MindMap
• Learning MindMap
• MindMaps MindMap
• Install LiveMeeting Client
• Test LiveMeeting (restart Internet Explorer after this step)
• Join LiveMeeting

• MaxiVista Viewer A version 4011

Courses Coming

• Downtown Robson Square
• Main Campus David Lam

Upcoming Courses

Course Outline

If you are familiar with previous versions of Microsoft Outlook then sending and receiving email with Outlook 2010/2007 is very simple. For many people making the transition, that is where they stop exploring. In this course we uncover the mysteries of the new fluent user interface (the Ribbon) to help you to do what you have always done like emailing, scheduling and responding to appointments, categorizing your mail and calendar events. We also explore new ways to be productive with flags, rules, automatic formatting, quick art, smart parts and more.

Duration: 6 hours (Morning and afternoon session on the same day)

Register for this course

For announcements please check

Theoretical Objectives Understand why the Inbox gets out of control Discuss (explain in your own words) how at least three of the features Outlook can change your approach to dealing with email. Understand key benefits of using the organizational features of Outlook. Discuss (explain in your own words) how at least three of these features can improve the quality of your results (or speed time to outcome), or simply reduce the number of times you touch/read an email. Understand the key actions that can arise from an email and learn shortcuts to accomplish these quickly.

Practical Objectives Use the Fluent User Interface Ribbon Backstage View Quick Access Toolbar Navigation Pane Folders Buttons To-Do Bar Date Navigator Appointments Task List Categories Tasks Folders Search Folders Key Tips (old name - keyboard shortcuts) Optional topics Archiving / Backup Journal

Prerequisites

Recommended: Prior experience with Windows and any version of Microsoft Office would be an asset.

• Getting Ready MindMap
• Learning MindMap
• MindMaps MindMap
• Install LiveMeeting Client
• Test LiveMeeting (restart Internet Explorer after this step)
• Join LiveMeeting

• MaxiVista Viewer A version 4011

• Course Outline MindMap
• Client Server MindMap

Courses Coming

• Downtown Robson Square
• Main Campus David Lam

Upcoming Courses

Course Outline

If you are an experienced user of earlier versions of Microsoft Word, then making the initial transition to Word 2101/2007 is easy, until you try to do familiar things like formatting and extensive editing. In this course we uncover the mysteries of the new fluent user interface (the Ribbon) to help you to do what you have always done like create and edit text, format with styles and outlines, check grammar and spelling. We also explore new ways to be productive with shapes, smart art, quick parts, references and more.

Duration: 6 hours (Morning and afternoon session on the same day)

Register for this course

For announcements please check

Theoretical Objectives Discuss (explain in your own words) how at least three of these benefits can change your approach to using Word 2010/2007. Understand key benefits of using features that transcend simple creation and editing of text content. Examples: Building Blocks Styles Themes Discuss (explain in your own words) how at least three of these benefits can improve the quality of your results (or speed time to outcome).

Practical Objectives Word 2010/2007 Use the Ribbon (new fluent user interface): Building Blocks Styles Outlines Table of Contents Tracking Changes Key Tips (old name - keyboard shortcuts) Optional Topics (time permitting) Blacklining and Document Comparison - see: Tracking Changes Page Numbering - see: Lists Creating Templates Version Control Page/Section breaks Cross References Headers and Footers

Prerequisites

Prerequisites

Prior experience with Word 2003 or earlier would be an asset. Access to the Internet to review post-course resources is highly recommended.

Downloads

Note: The password to open these files is in your notes.

• Windows download

• Getting Ready MindMap
• Learning MindMap
• MindMaps MindMap
• Install LiveMeeting Client
• Test LiveMeeting (restart Internet Explorer after this step)
• Join LiveMeeting

• MaxiVista Viewer A version 4011

• Course Outline MindMap
• Client Server MindMap

Courses Coming

• Downtown Robson Square
• Main Campus David Lam

Upcoming Courses

Course Outline

If you have just bought a new PC or plan to in the coming months, this course introducing Microsoft Windows 7 is for you. Whether at work or at home, when everyday PC users are confronted with new versions of existing software, our natural inclination is to test whether we can still do what we used to do - the old way. Learn the best of both worlds: find your favourite old features as well as the new ones! Discover the Windows 7 benefits and features such as the new user interface, instant search and sync centre, and new Office 2010 features, including the ribbon, quick access toolbar, key tips, and Windows Live.

Duration: 6 hours (Morning and afternoon session on the same day)

Register for this course

For announcements please check

Theoretical Objectives Understand key benefits of using Microsoft Windows 7. Discuss (explain in your own words) how at least three of these benefits can change your approach to using your computer. Understand key benefits of using Microsoft Office 2010/2007 Understand how to find things in the new interface Discuss (explain in your own words) how at least three of these benefits can improve the quality of your results (or speed time to outcome) with Access, Excel, PowerPoint, or Word. Explore Windows Live, Office Live (optional material) Discuss pluses, minuses, and interesting aspects of computing in the cloud Collaboration (optional material) Microsoft SharedView (web) Live Mesh

Practical Objectives Windows 7 Find almost anything on your computer with Search anywhere and the Search folder. Organize your files with View, Navigation Pane, Folders View, Filtering, Stacking, Saved Searches, Libraries. Creating and using User Accounts. Restoring old versions of a file. Office 2010/2007 Use the Ribbon (new fluent user interface): Tabs Groups and Dialog Box Launcher Commands Quick Access Toolbar Key Tips (old name - keyboard shortcuts) Significant changes since Office 2007

Prerequisites

Recommended: Prior experience with any version of Windows and Microsoft Office would be an asset. Access to the Internet to review post-course resources is highly recommended.

• Install LiveMeeting Client
• Test LiveMeeting (restart Internet Explorer after this step)
• Join LiveMeeting

Courses Coming

• Downtown Robson Square
• Main Campus David Lam

Upcoming Courses

Course Description

Leverage your understanding of HTML 4.01 and build on it with the new capabilities in HTML 5 with support for multimedia, new forms controls, local offline storage, content specific elements, and more. This course assumes that you know the basics of HTML 4.01 and the focus will be on the new capabilities in HTML 5 that are being supported in modern browsers.
Prerequisites: Fundamentals of HTML (4). Prior exposure to JavaScript and Cascading Style Sheets would be very helpful but is not required for this course.
Technical Prerequisites: Access to the Internet

Duration: 12 hours (4 evening sessions)

Register for this course

Theoretical Objectives Discuss / Answer: What is HTML 5? Where it fits in with other technologies What's new in HTML 5 Support in Browsers Workarounds and Tools Support in development tools What can I use today? The Semantic Web? Using the new elements Heading Article Section Footer Cite, Details, Mark

More new Elements Media elements Audio Video Canvas Form elements Web Storage Application Caching Geolocation CSS Layouts Where JavaScript fits in Impacts on Search Engine Optimization

Practical Objectives You will learn about creating standards compliant web sites and recognize the application of the concepts shown in the Theoretical Objectives.

Prerequisites

Prior experience authoring in HTML 4 is required, CSS or visual design is an asset but is not required.

Knowledge of the following will be very helpful:

• Cascading Style Sheets (CSS) for styling page elements
• CSS for page layout
• JavaScript

Access to the internet is required to complete assignments.

Location

• Downtown Robson Square
• Main Campus David Lam

Courses Coming

• Downtown Robson Square
• Main Campus David Lam

Overview

Introduction

With modern tools you can create a web page, or even an entire web site without knowing anything about programming - but - to get beyond simply adding content to pre-made templates you do need to know what is going on below the surface: You need to know about programming. Even if you don't intend to write programs, an understanding of the fundamentals will demystify many of the technologies you will encounter in web development.

Course Description

We explore a big picture view of the Internet and identify centres of technology. It is in these centres of technology that various kinds of programming take place. We then look at high level programming concepts: variables, scope, control structures, sub procedures and functions and discuss scripting, compiled and hybrid languages and concepts related to object oriented programming.

Duration: 18 hours (6 evening sessions)

Register for this course

Theoretical Objectives You will learn concepts and terminology related to programming, and understand where these are used in web development. Some of the high level concepts covered in this course: Programming in General Scripting in Contrast High/Low level languages Abstraction Sequence Branching Iteration Variables Procedures/Functions Parameters Return Values State and Statelessness on the web Object Oriented Programming

Practical Objectives You will learn how to read programming/scripting code in several environments and recognize the application of the concepts shown in the Theoretical Objectives. (left panel on this page). You will learn the general layout of a integrated software development environment tool and create a simple website.

Prerequisites

Access to the internet is required to complete assignments.

Location

• Downtown Robson Square
• Main Campus David Lam

Courses Coming

• Downtown Robson Square
• Main Campus David Lam

Overview

Client-side scripting (at the browser) is a common method of bringing interactivity to the user experience on the web.

Learn about one of the most popular (widely supported) tools for doing this: JavaScript

This course provides a hands-on introduction to programming in JavaScript, general scripting fundamentals as well as JavaScript specifics (80% of the course). We will also explore using the jQuery Javascript Library (20% of the course).

Duration: 12 hours

Register for this course

Objectives

Theoretical Objectives Understand how JavaScript fits into the context of web development Understand where JavaScripts fits into the context of specific web pages Understand these concepts of programming in JavaScript: Sequence Variables Functions Selection Iteration Arrays Object Orientation Understand how JavaScript is related to the Document Object Model and how JavaScript can manipulate and otherwise affect an HTML document Know where to find and how to use JavaScript libraries and utilities  Understand where jQuery fits in the context of JavaScript

Practical Objectives Create web pages that use JavaScript to: Dynamically write content to web page Create user interfaces using forms Create pop-up messages to inform and capture user input Create functions to Encapsulate business logic Dynamically update the current web page Introduction to jQuery Use jQuery within a web page to manipulate CSS properties Use jQuery UI (User Interface) libraries in web page

Prerequisites

Academic

The better you understand HTML - the more you will take from this course.

• Programming Basics
• HTML (Fundamentals of HTML Authoring)
• HTML 5

Technical

Access to the Internet You will need to FTP files from / to our server to / from your remote location in order to successfully complete the assignment

• Tools
  1. FTP Client: wsftp Limited Edition or similar. (Note: Firefox FireFTP does not work reliably with our server). You can also try free-ftp
     1. Download the wsftp Limited Edition
     2. Right click the executable file and Run as Administrator
     3. See FTP access for details on setting up the connection.
  2. Text Editor: SC303.exe WScite Text Editor (single file executable)
     • or wscite303.zip WScite Text Editor with full documentation
  3. SciTEGlobal.properties ⇐ download this to the same directory as the executable file for SciTE editor so that you will have the same configuration we use in the lab.

• Getting Ready MindMap
• Learning MindMap
• MindMaps MindMap
• Install LiveMeeting Client
• Test LiveMeeting (restart Internet Explorer after this step)
• Join LiveMeeting

• MaxiVista Viewer A version 4011

• Setup for Examples

1. Student Home Page Maker
2. Student Template Page Maker View the Source of this page, then save the text to your local hard drive (c:\My Documents) as your_name99.htm (note - you will have to force the extension to htm).
3. Style Sheet to go with Template Save this file to your local hard drive (c:\My Documents) as Styles.css

• Tools
  1. FTP Client: wsftp Limited Edition or similar. (Note: Firefox FireFTP does not work reliably with our server). You can also try free-ftp
     1. Download the wsftp Limited Edition
     2. Right click the executable file and Run as Administrator
     3. See FTP access for details on setting up the connection.
  2. Text Editor: SC303.exe WScite Text Editor (single file executable)
     • or wscite303.zip WScite Text Editor with full documentation
  3. SciTEGlobal.properties ⇐ download this to the same directory as the executable file for SciTE editor so that you will have the same configuration we use in the lab.

Course Description

In this hands-on course you focus on using Microsoft Expression Web to create feature-rich websites that are standards compliant. You learn how to create modern user interfaces, generate CSS layouts to manipulate position, sizing, margins and padding, perform cross-browser testing, and use the Search Engine Optimization (SEO) checker tool to improve search engine ranking.

Duration: 12 hours (4 evening sessions)

Register for this course

Theoretical Objectives You will learn concepts and terminology related to web site development, and understand where these are used in the context of Expression Web 4 Some of the high level concepts covered in this course: What is Expression Web 4? Where it fits in with other products What's new in the latest release Expression Web 4 User Interface Setting Options for your workspace Setup for HTML 5 and CSS 3 Draft

The Design Surface Panels and Workspaces Stylesheets Code View Snapshots Snippets Create a website Master Layouts (different approaches) CSS Layouts from Templates Dynamic Web Templates Master Pages SuperPreview Site View Reports Search Engine Optimization Reports

Practical Objectives You will learn how to create standards compliant web sites and recognize the application of the concepts shown in the Theoretical Objectives. (left panel on this page).

Prerequisites

Prior experience in creating websites, HTML, CSS or visual design is an asset but is not required.

Knowledge of the following will be helpful

• Cascading Style Sheets (CSS) for styling page elements
• CSS for page layout
• XHTML / HTML

Access to the internet is required to complete assignments.

Location

• Downtown Robson Square
• Main Campus David Lam

Courses Coming

• Downtown Robson Square
• Main Campus David Lam