Staff Computer Course - Course Outline

Troubleshoot Problems in Microsoft Word, Excel and PowerPoint (CSC307a)

Course Outline:

  1. Troubleshooting in MS Word
    • Converting files to and from the previous version of Word
    • Converting files between Adobe Acrobat and Word format
    • Recover a document when Word Shut down Unexpectedly
    • Recover information from a damaged document
    • Handling font changed
    • Install additional fonts
    • Insert sample text
    • Print a Word document on a system that does not have Word installed
    • Move AutoCorrect entries from one computer to another
    • Send a Word document in an E-mail message
    • Get a list of shortcut keys in Word
    • Add additional templates
  2. Troubleshooting in MS Excel
    • Format number as text data
    • Display leading zero
    • Sort Alphanumeric Text as Numeric Values
    • Delete your name in creating a comment
    • Handle if part of your comment does not appear
    • Why decimal points are added to all numbers when enter
    • Handle the missing fill handle
    • Handle wrong cell reference after move or copy
    • Handle when the Find and Replace command does not find data
  3. Troubleshooting in MS PowerPoint
    • Handle slide numbers in custom shows
    • Modify the default presentation template
    • Handle error when inserting clip image into a presentation
    • Handle error when inserting organization chart
    • Handle error when inserting movie from the selected file

Duration: One day

Pre-requisite(s): Participants should have a sound working knowledge of MS Office 2000


Wireless LAN Access Services for CityU Members (CSC412)

Course Outline:

  1. Introduction to Wireless
    • What is Wireless LAN (WLAN)
    • CityU WLAN Service
    • Eduroam
    • Wi-Fi at PCCW/Y5Zone hot spots
  2. Wireless LAN Compliance
    • IEEE 802.11a
    • IEEE 802.11b
    • IEEE 802.11g
    • Comparsion chart
  3. Secure connection vs insecure connection
    • What is Wireless LAN Security ?
    • Wireless LAN Security modes
    • How to switch/select and set default WLAN networks
  4. Setting up your device to access Wireless LAN
    • Laptop with Windows 7
    • Special alert in the credential caching problem while using Windows 7with WPA
    • Laptop with Windows Vista
  5. How to identify locations that offer free Wi-Fi access to CityU members
    • CityU WLAN Coverage
    • EduroamCoverage
    • Identify locations that offer Wi-Fi access to City U members

Duration: 3 hours


Enhance PowerPoint Presentations with Multimedia Elements (CSC317)

The aim of this course is to provide the basic techniques in creating and editing multimedia elements using specialized software for the MS PowerPoint presentations.

Course Outline:

  1. Introduction in the major features and multimedia functions of MS PowerPoint
  2. Inserting Sound File & Editing Technique in PowerPoint
    • File formats
    • Insert sound clips into PowerPoint file
    • Edit sound
  3. Basic Image Editing technique
    • Understand the interface of the application
    • Understand photo/Image file formats and resolutions
    • Image editing
    • Image Manipulation
    • Creation of background images
  4. The Creation of Simple Animations
    • Understand the interface of the application
    • Different animation formats
    • Add a sound to an animation
    • Add an effect to an animated object after it appears
    • Transition effects
  5. Video & Editing technique
    • Understand the interface of the Application
    • Insert a video on a slide
    • Basic video editing technique
  6. Voice Narration
    • Record a voice narration
    • Re-record voice narration
    • Pause or stop voice narration during recording
    • Delete voice narration or a sound from a slide
  7. Create a Link and Actions on Slides
    • Creating a Hyperlink in Your Presentation
    • Action Buttons
  8. Inserting & Editing Graphics and Drawings
    • Creating Drawings
    • Inserting Drawing Objects
    • Selecting Objects
    • Working with Drawing Objects
  9. Photo Album
    • Create a Photo Album
    • Set Layout in Photo Album
    • Modifying Layout and Design Options in a Photo Album
    • Display pictures in black and white in a Photo Album
  10. Package for CD
    • Package for CD
    • How To View A Packaged Presentation

Duration: One day

Pre-requisite(s):Completed Microsoft PowerPoint 2003 Introduction (CSC309) or with equivalent knowledge.


Using Excel Functions Effectively

This course delivers the application of the functions below. At the end of the course, students will be able to utilize the calculative functions of Excel.

Course Outline:

  1. Information Function
    The main usage of information function is to extract information from cell. For example the format of cell and the file name of the linked documents.
    Moreover, information function include IS(), which is a function for viewing the status of data.
  2. Database Function
    To organize information by Excel, most of the time we have to use database. When we need to calculate result within a database by using custom criteria, Database Function can bring into full play. For example, if you would like to calculate the sum and average of exports in America at the third season, or if you want to calculate the accumulated number of clients in five years from your customer database, the Database Function is critically useful at this moment.
  3. Text Function
    The main usage of Text Function is to extract words from cell, which means completing word process. For example, extracting part of the words from cell, merging two groups of word or more or handling search of words and replacement etc.
  4. Lookup and Reference Function
    It is always hard to find the information you need in a database, but if you are familiar with the usage of Lookup and Reference Function, this would definitely raise your efficiency. HLookup and Vlookup are the most popular examples of Lookup and Reference Function.
  5. Statistical Function
    Statistical Function is best to handle data analysis, statistical areas like probability, variance and seek for average value etc. For example, a company has to execute quality control management of products by requesting its staff to calculate how well the products are. Statistical Function can be used to handle such cases easily.
  6. Financial Function
    In the application of Financial Function, most of the functions were used to calculate investment interest, depreciation amount and investment returns etc. This is absolutely useful for those who need to prepare financial reports frequently.
  7. Other Functions
    Apart from the functions mentioned above, other kinds of functions will also be taught in details. For example, the Math and Trig Function, Date & Time Function and Logical Function.

Duration: One day

Pre-requisite(s):Completed Microsoft Excel 2003 Introduction (CSC310) or with equivalent knowledge.


Preparing Professional Reports Using MS Excel (CSC512)

This course is designed for advanced excel users to prepare professional reports. After completion of the course, participants will be able to import information into Excel, integrate other office applications using OLE mechanism, produce an interactive report, together with knowledge in choosing suitable formats that best fit the report.

Course Outline:

  1. Using Worksheet Function
    • Lookup & Reference Function
    • Database and List Management Function
  2. Data Validation
    • Creating list box to choose options
  3. Pivot Table
    • Create and Edit a Pivot Table
    • Refreshing Data
    • Grouping and Ungrouping Data
  4. Pivot Chart
    • Create and Edit a Pivot Chart
  5. Outlining a Worksheet
    • Outlining a Worksheet Manually or Automatically
  6. Scenario Manager
    • Creating and Displaying Scenarios
    • Using Toolbars to view Scenarios
    • Creating Scenario Reports
  7. Data Consolidation
    • Consolidating Data by using 3-D References, Position or Category
  8. Using Microsoft Query to get external data
    • Run Database Query

Duration: One day

Pre-requisite(s):Participants should have a sound working knowledge of the Windows environment.


Microsoft SharePoint Designer 2010 - Introduction

Course Outline:

  1. Overview
  2. Changes in SharePoint Designer 2010
  3. User Interface
    • Explore new interface of SharePoint Designer
    • Review new work areas of Designer
    • Browse Site Pages, Master Pages, Lists and Libraries, Workflows, Content Types, Data Sources and Browse Entities
    • Explore Site Structure
    • Create a new site, new page,new master pageand list
    • Attach a master page
    • Change list settings
    • Create Content Type
    • Create/Modify CSS
    • Check-In/Check-Out
    • Add Web Partsand Web Part Zone
    • Adding Images (_images directory)
    • Reset to Site Definition

Duration: One day


Microsoft SharePoint Designer 2010 - Advanced

Course Outline:

  1. Data Views
    • DataSources
      • Create/Manage Data Sources
      • Merge Two Data Sources
      • Link Two Data Sources
    • DataViews
      • Create/Manage Data Views
      • Data View Parameters
      • Data View Parameters
  2. External Content Types
    • Business Connectivity Services
    • ExploreExternal Content Types
    • Create a new External Content Type
    • Create an External List
  3. Workflows
    • Built-inActivities
    • LoopingWorkflow
    • ReusableWorkflows
      • Create Reusable Workflows (Site/Global)
      • Export a workflow to Visio
      • Import a workflow from Visio
      • Save as Template
    • Modify Out of Box Workflows

Duration: One day


Chinese Input Method - Chang Jie (CSC702)

Date: 25 Apr 2013 (Thu)
Time: 9:30 a.m. - 5:15 p.m.
Venue: AC2-4101

課程內容

  1. 倉頡及速成輸入法之基本概念
  2. 造字功能

講授時間:一天

參加資格:


Chinese Input Method - Q9 2002 (CSC704)

九方中文輸入法解決了電腦及其他小型介面的使用中文輸入法瓶頸,全面解決了中文輸入法的間題,令中文輸入法既簡單又快捷。

Date: 17 Apr 2014 (Thu)
Time: 14:15 p.m. - 17:15 p.m.
Venue: AC2-4101

課程內容

  1. 課程內容
  2. 九方輸入法系統
  3. 筆劃輸入規則
  4. 拼音輸入規則
  5. 字形輸入規則
  6. 九方系統輔助功能

講授時間:半天

參加資格:


Microsoft Expression Web 4 - Introduction (CSC511)

Date: 23 Jan 2014 (Thu)
Time: 9:30 a.m. - 5:15 p.m.
Venue: AC2-4101

Course Outline:

  1. Introduction to Expression Web 4
    • About Expression Web
    • Understand the interface
    • Preview pages in a browser
  2. Working with Sites
    • Creating new site
    • Import or Export Files
  3. Working with Text
    • Formating Toolbar
    • Set the appearance of text
    • Copy and reuse formatting
    • Add a line break
    • Insert symbols
    • Using lists
  4. Working with images
    • Adding Images
    • Set the size of a picture
    • Create a thumbnail picture
    • Crop a picture
    • Align or wrap content around a picture
    • Add margins to a picture
    • Set the page background
    • Adding Flash media
    • Adding video
    • Adding sound
  5. Working with hyperlinks
    • Create or modify a hyperlink
    • Picture hyperlinks
    • Bookmarks (HTML anchors)
    • Change the appearance of a hyperlink
    • Adding interactive buttons
  6. Working with Styles
    • About CSS
    • Types of styles
    • Create a style
    • Apply a style
    • Modify a style
    • Attach or detach an external cascading style sheet
  7. Controlling Page Layout
    • Adding a table
    • Format a table
    • Adding CSS layout pages
    • Using layers
    • Add or remove a layer
    • Position a layer
    • Resize a layer
    • Set border, padding, and background properties
  8. Dynamic Web Templates
    • Create a Dynamic Web Template
    • Attach or detach a Dynamic Web Template
    • Update web pages
  9. Publishing sites
    • Publish to a remote production server
    • Work on a remote staging server
    • Work directly on a server using FrontPage Server Extensions
    • Work directly on a remote production server using FTP

Duration: One day


MS SharePoint 2010 for Site Owner (CSC514)

Date: 7 Nov 2013 (Thu)
Time: 9:30 a.m. - 17:15 p.m
Venue: AC2-4101

Course Outline:

  1. Creating Site
    • Create and Manage SharePoint sites
    • Delete sites and site collections
  2. Customizing Sites
    • Introduction to customizing site and pages
    • Work with site settings
    • Change the default images on the home pages
    • Change the Site Colors or theme
    • Change the Welcome Page
  3. Managing navigation and site structures
    • Introduction to site navigation
    • Configure navigation inheritance
    • Configure navigation items on the Site Navigation Settings page
    • Customize the top link bar
    • Use the Table of Contents Web Part to display navigation on a Web Page
    • Show or hide tree view navigation for a site
  4. Creating Lists, and Libraries
    • Create a library
    • Create a list
    • Create a calendar
    • Create a picture library
    • Display data from a list or library on a separate page
  5. Managing SharePoint Security
    • About security features
    • About controlling access to sites and site content
    • About managing SharePoint Groups and users
    • Manage SharePoint Groups
    • Permission Levels and permissions
    • Manage Permissions Levels
    • Manage permissions for a list, library, folder, document, or list item
    • Remove users and groups from site access
  6. Using Web Parts
    • Introduction to customizing pages by using Web Parts
    • Customize pages on a site by adding Web Parts
    • Add or remove a Web Part
    • Customize Web Parts
  7. Using SharePoint 2010 Workflow
    • Introduction to workflows
    • Create a workflow
    • Delete or remove a workflow

Duration: One day


MS SharePoint 2010 for End-Users (CSC515)

Course Outline:

  1. Overview of MOSS 2010
    • Introduction to SharePoint key features
    • Hierarchy of SharePoint Portal and Sites
  2. Navigating with MOSS 2010
    • Introduce SharePoint interface
    • Interface for create and edit
    • Locations for documents, files and pictures
    • Views and items
    • Wiki and Blog Capabilities
  3. Trend in Team Collaboration
    • What’s Team Collaboration?
    • Traditional vs. Virtual Teams
    • The Challenge of Virtual Team Collaboration
  4. Document Management
    • Explanation of Document Library / Picture Library
    • Upload and edit documents
    • Use recycle bin
    • Check in and out a document
    • Co-authoring
    • Version control
    • Content approval
    • Using and Managing Alerts
    • Create a library
    • Create or change a view
  5. Using Basic Web Parts
    • Introduction to customizing pages by using Web Parts
    • Customize pages on a site by adding Web Parts
    • Add or remove a Web Part
    • Customize Web Parts
    • Site Users Web Part
    • User Tasks Web Part
    • Content Editor Web Part
    • “I need to…” Web Part
    • Relevant Documents
  6. Accelerating Team Effectiveness Using List
    • Create a list
    • Create a calendar
    • Create a new discussion board
    • Collect comments and feedbacks using Survey
    • Create or change a view

Duration: One day

Pre-requisite(s): General knowledge of Windows and Office. The course assumes that the participants have no prior experience with SharePoint 2010.


Microsoft Windows 8 for General Users (CSC422)

Date: 31 Jul 2014 (Thu)
Time: 14:15 p.m. - 17:15 p.m
Venue: AC2-4200

Course Outline:

  1. Windows 8 Editions and System Requirement
    • Windows 8 Editions
    • Minimum System Requirements
    • What’s Different from Windows 7
  2. Using Windows 8
    • Get to know Windows
    • Search, share, change settings, and more
    • Close an app, shut down your PC, and more
    • Customize the Start screen
    • New, Refresh, and other commands in apps
    • Switch between apps
    • Snap an app: Use two apps at the same time
    • Set up your PC
    • Install your apps
    • How to search
  3. Find & Organize
    • How to work with files and folders
    • Learn about the different parts of the File Explorer window
  4. Configuring Disks
    • Basic disks and volumes
    • Accessing Disk Management
    • Resizing a Partition
    • Creating a Partition
    • Deleting a Partition
    • Changing Drive Letters
    • Formatting a Partition
  5. Share files and folders on a network or a shared PC
    • Managing Shared Folder
  6. Security, Privacy & Accounts
    • Security checklist for Windows
    • Create a user account
    • How can I help protect my PC from viruses?
    • Windows Firewall from start to finish
    • Turn Windows Firewall on or off
    • Understand Windows Firewall settings
    • Internet Explorer 10
    • What is Encrypting File System (EFS)
    • Help protect your files with BitLocker Drive Encryption
    • Unlock the drive
  7. Optimizing and Maintaining Windows 8
    • Performance Tools
    • Restore, refresh, or reset your PC
    • File History (Backup & Restore)
    • Windows Update

Duration:3 hours


Microsoft Live and Google Application (CSC421)

Course Outline:

  1. Create User Account
    • MS Live & Google Apps
  2. Microsoft Live
    • What is Microsoft Live
    • Log In to Microsoft Live
    • Working with Office Live
    • Hotmail
    • People or Contact List
    • Category (Mailing List)
    • Calendar
    • Photos
    • Skydrive
    • Spaces
  3. Outlook Connector
    • >Overview
    • Download and Install Outlook Connector
    • Display Hotmail Calendars in Outlook
  4. Google Apps
    • What is Google App
    • Log In to Google Apps
    • Using Gmail
    • Contacts and Groups
    • Using Google Calendar
    • Using Google Docs
    • Using Sites
  5. Using Google Mail in Outlook
    • Enable IMAP in Google
    • Configure Outlook

Duration:3 hours


System Backup and Recovery (CSC016)

This course is aimed at those who are interested in providing software solution for disaster recovery of their PC. After this course, participants will be able to backup and restore their own data and the OS.

Date: 22 May 2013 (Thu)
Time: 9:30 a.m. - 12:30 p.m
Venue: AC2-4200

Course Outline:

  1. Introduction to Backup & Restore
    • Why should I backup?
    • Back up your files
    • Back up your programs, system settings, and files
    • Where should I save my backup?
    • Restore files from a backup
  2. Using CD Writer
    • CD-R vs. CD-RW
    • Burn a CD or DVD in Windows Media Player
  3. Backup System and Programs
    • Understanding cloning and image files
    • Using Ghost executable
    • Using Ghost to clone disk to an image file or disk
    • Restoring your system
  4. Automating System Recovering Procedure
    • What is System Restore>
    • What are the system recovery options in Windows 7?
  5. Backup and Restore Windows 7 Operating System
    • What is a System Image
    • Restore your computer from a system image backup
    • Create a system repair disc
    • To use the system repair disc
  6. Backup User Data Files, E-Mails and Web Page Favorites
    • Backup using Folder Synchronization Software
    • E-Mail Backup and Restore
    • IE Backup and Restore

Duration:3 hours

Pre-requisite(s): Participants should have a sound working knowledge of the Windows environment.


How to Secure Your PC (CSC015)

Date: 17 Apr 2014 (Thu)
Time: 9:30 a.m. - 12:30 p.m.
Venue: AC2-4101

Although the Windows operating systems are commonly installed on personal computers, they are not designed to be used with computers storing data that is considered critical to a project or that must be very securely protected. In fact, there is an increasing number of incident reports from Windows users. Thus, this course is intended to help these users become more aware of computer security.

Course Outline:

  1. Computer Security Basics
    • What is Computer Security?
    • How Easy to Break Into My Computer?
    • Computer Security Risks to Computer Users
    • Physical Security Issue
    • What is Wireless LAN Security
    • Wireless Lan Security modes
    • Security Threats and Risks Associated with Wireless Networks
  2. Techniques used by Hackers
    • Backdoor and Remote Administration Program
    • Trojan Horse Program
    • Denial of Service
    • Packet Sniffing
    • Web Unexpected Input
    • Java, JavaScript and Active X
    • Email Spoofing
    • Viruses and Worms
    • Internet Pop-up
    • Zero-day attack
    • Other Hack Tools
  3. Anti-Virus Software
    • How Do You Know Your PC is Infected by Virus?
    • Popular Virus Protection Software
    • Right Click Scanning
    • On-Demand Scanning
    • Virus Definition
    • Handling of Unknown Virus
  4. Use a Firewall
    • Types of Firewall
    • Which one is Suitable for Individual Use
    • Introduce Windows 7 Firewall
  5. Applying Patches, Running Windows Updates & Internet Protection
    • Microsoft Windows
    • Windows Automatic Updates
    • Microsoft Office
    • Internet Explorer
    • Pop-up Blocker
    • Clear Auto Complete
  6. Practicing Safe Computing
    • Don't Open Unknown email
    • Disable Hidden Filename Extensions
    • Turn off your Computer or Disconnect from the Network When Not in Use
    • About History
    • Disable Auto-complete
    • Disable Cookies in the browsers
    • Disable Java, JavaScript and ActiveX if possible
    • Disable Plug-ins
    • Avoid Malicious Sites
    • Disable Scripting features in email programs
    • Phishing Filter in IE7
    • Exercise - Setting IE Security
    • Windows 7 User Account Control
    • UAC Setting in Windows 7
    • Set Security Level in MS Office
    • Using Backups to Protect Your Data
    • Protect with Screen-Saver Settings
    • Safety tips on using WLAN
    • Configuring Secured Connection for WLAN
    • Data protection with Windows BitLocker Drive Encryption (WindowsVista and 7 only)
    • USB device Security
    • Notebook Security
    • Bitlocker To Go (Windows 7 only)

Duration:3 hours

Pre-requisite(s):Basic PC knowledge


CityU Information Security Policies and Standards (CSC017)

Date: 28 Nov 2013 (Thu)
Time: 09:30 a.m. - 12:30 p.m
Venue: AC2-4101

Course Outline:

  1. Information Security at a Glance
    • Why InfoSec Policies and Standards
    • Information Security Concepts
    • Critical Success factors to InfoSec
    • Glossaries
    • Illustrated
    • Common Threats
    • Threats, Vulnerabilities and Risks
  2. Information Security Maturity and Governance
    • Information Security Maturity
    • CityU Information Security Plan
  3. Information Security Policies and Standards
    • Holistic Information Security
    • Daily Operations
    • General Roles and Responsibilities
    • Info and IT Asset Identification
    • Acceptable Usage
    • Information Classification – Sensitive
    • Information Classification – Non-sensitive
    • Information Labeling
    • Sample Record Control Table
    • Information Handling
    • Holistic Information Security
    • Information Security Policies and Standards

Duration:3 hours

Pre-requisite(s):Basic PC knowledge


Understanding and Controlling Computer Virus (CSC301)

Date: 9 Jan 2014 (Thu)
Time: 2:15 p.m.. - 5:15p.m
Venue: AC2-4101

McAfee VirusScan provides comprehensive virus prevention, detection and elimination software for your computer. It finds and repairs infected files to keep your data safe and secure. Easy updating of the virus definition service over the Internet keeps McAfee VirusScan prepared for the latest threats.

Course Outline:

  1. Getting Started
    • What's new in McAfee VirusScan Enterprise
      • How viruses work
      • Macro viruses spread quickly
      • How to maintain protection
    • Installing McAfee VirusScan Enterprise
      • System requirements
      • Before installation
      • Install McAfee VirusScan Enterprise
      • After Installation
    • McAfee VirusScan Enterprise basics
      • Work with McAfee VirusScan Enterprise
      • Maintain McAfee VirusScan Enterprise protection
      • Customize McAfee VirusScan Enterprise
  2. Antivirus tools
    • Protecting your Computer from viruses
      • Ensure that Auto-Protect is enable
      • Scan disks, folders and files
      • About custom scans
      • Scan email messages
      • If problems are found during a scan
      • Schedule automatic virus scans
    • Protecting your handheld device from threats
      • About Auto-Protect
      • Set a preference to scan after a synchronization
      • Scan for threats
      • View the Scan summary
  3. Advanced Tools
    • Recovering missing or erased files
    • Eliminating data permanently
  4. What to do if a virus is found
    • What to do if a virus is found on your computer
      • If a virus is found during a scan
      • If a virus is found by Auto-Protect
      • If you have files in Quarantine
      • If McAfee VirusScan Enterprise cannot repair a file
      • If your computer does not start properly
      • Look up virus names and definitions
    • What to do if a threat is found on your handheld device
      • If a threat is found by Auto-Protect
      • If a threat is found by a scan
      • View information about threats
      • If a threat is deleted
      • If a program is deleted

Duration:3 hours

Pre-requisite(s):Knowledge of basic PC operations


Solving Common PC Problems (CSC306)

Course Outline:

  1. Windows basic troubleshooting
    • Getting older programs to run on Windows 7
    • Updating your program or drivers
    • To start a program each time you start Windows
    • To change or remove a program
  2. Startup & shutdown troubleshooting
    • Start Windows in Safe Mode
    • Start the computer using the last known good configuration
    • [System Restore] overview
    • BIOS error warning sound
  3. Increase computer performance
    • Startup applications
    • Adjust performance options
    • End running application
    • Disk Cleanup
    • Using disk defragmenter
    • Reserve disk space for virtual memory
    • Back up files to a file or a tape
    • Restore files from a file or a tape
  4. Hardware troubleshooting
    • Device manager
    • USB plug & play hardware
  5. Computer security and virus handling
    • Anti-virus software scan
    • Windows Update
    • Use Windows Firewall
  6. Securing your computer
    • Running Windows Update
    • Using Automatic Update
    • Enable Windows Firewall
    • What to Do if Virus is Detected
    • Files in Quarantine
    • How to Block Web Pop-up
    • Activate Screen Saver
    • Creating Strong Passwords
    • How to Change your Password
    • How to Remove Auto Complete
  7. Printers troubleshooting
    • Document printing problem
    • Installing network printers
    • Setting printer properties
    • Cancel printing all documents
    • Pause or resume printing all documents
    • View documents waiting to print
  8. Network connection troubleshooting
    • Connection Checking
    • IPCONFIG command
    • Connecting two computers
  9. How to add new Chinese input method
    • Add another keyboard layout
    • Remove a text service
    • Use shortcut key to switch language & keyboard layout
  10. Remote desktop connection
    • Remote desktop connection
    • Enable remote desktop connection
  11. Setup Windows Dual Boot
    • How to setup Windows Dual Boot options
    • Technique of installing multiple OS
  12. Customized Windows Desktop Setting
    • How to Add My Computer & My Network Places Icon on Desktop
    • How to Add the Quick Launch in Taskbar
    • How to Disable MSN Messenger Autorun
    • Map Network Drive

Duration: One day

Pre-requisite(s):Participants should have a sound working knowledge of the Windows environment.


Adobe Flash CS6 - Introduction (CSC432)

Date: 20 Mar 2014 (Thu)
Time: 9:30 a.m. - 17:15 p.m
Venue: AC2-4101

Course Outline:

  1. Getting Acquainted
    • Starting Flash and Opening a File
    • Creating a New Document
    • Getting to Know the Workspace
    • Choosing a new workspace
    • Saving your workspace
    • About the Stage
    • Changing the Stage properties
    • Working with the Library Panel
    • About the Library panel
    • Importing an item to the Library panel
    • Adding an item from the Library panel to the Stage
    • Understanding the Timeline
    • Renaming a layer
    • Adding a layer
    • Inserting frames
    • Creating a keyframe
    • Moving a keyframe
    • Organizing Layers in a Timeline
    • Creating layer folders
    • Adding layers to layer folders
    • Changing the appearance of the Timeline
    • Using the Properties Inspector
    • Positioning an object on the Stage
    • Using the Tools Panel
    • Selecting and using a tool
    • Undoing Steps in Flash
    • Previewing Your Movie
    • Modifying the Content and Stage
    • Stage Resizing and Content Scaling
    • Saving Your Movie
    • Using Auto-Save
    • Using Auto-Recovery for a backup
    • Saving an XFL document
    • Modifying an XFL document
    • Publishing Your Movie
    • Finding Resources for Using Flash
    • Checking for Updates
  2. Working with Graphics
    • Getting Started
    • Understanding Strokes and Fills
    • Creating Shapes
    • Using the Rectangle tool
    • Using the Oval tool
    • Making Selections
    • Selecting strokes and fills
    • Editing Shapes
    • Using the Free Transform tool
    • Using Copy and Paste
    • Changing shape contours
    • Changing strokes and fills
    • Using Gradient and Bitmap Fills
    • Creating gradient transitions
    • Using the Gradient Transform tool
    • Adding a bitmap fill
    • Grouping objects
    • Making Patterns and Decorations
    • Creating a symbol for a pattern
    • Using the Deco tool Symmetry Brush
    • Aligning objects
    • Breaking apart and grouping objects
    • Using the Deco tool Decorated Brush
    • Using the Deco tool Flower Brush
    • Converting Vector Art to Bitmap Art
    • Creating Curves
    • Using the Pen tool
    • Editing curves with the Selection and Subselection tools
    • Deleting or adding anchor points
    • Creating Transparencies
    • Modifying the alpha value of a fill
    • Matching the color of an existing object
    • Creating and Editing Text
    • Using the Text tool
  3. Creating and Editing Symbols
    • Getting Started
    • Importing Illustrator Files
    • About Symbols
    • Creating Symbols
    • Importing Photoshop Files
    • Editing and Managing Symbols
    • Adding folders and organizing the Library
    • Editing a symbol from the Library
    • Editing a symbol in place
    • Breaking apart a symbol instance
    • Changing the Size and Position of Instances
    • Using rulers and guides
    • Changing the Color Effect of Instances
    • Changing the brightness
    • Changing the transparency
    • Understanding Display Options
    • Visible option for movie clips
    • Blending effects
    • Export as Bitmap
    • Applying Filters for Special Effects
    • Applying a blur filter
    • Positioning in 3D Space
    • Changing the 3D rotation of an object
    • Changing the 3D position of an object
    • Resetting the rotation and position
    • Understanding the vanishing point and the perspective angle
  4. Adding Animation
    • Getting Started
    • About Animation
    • Understanding the Project File
    • Animating Position
    • Using the Controller to Preview the Animation
    • Changing the Pacing and Timing
    • Change the animation duration
    • Adding frames
    • Moving keyframes
    • Animating Transparency
    • Animating Filters
    • Animating Transformations
    • Changing the Path of the Motion
    • Moving the path of the motion
    • Changing the scale or rotation of the path
    • Editing the path of the motion
    • Orienting objects to the path
    • Swapping tween targets
    • Creating Nested Animations
    • Creating animations inside movie clip symbols
    • Using the Motion Editor
    • Setting the Motion Editor display options
    • Changing property values
    • Inserting keyframes
    • Editing keyframes
    • Resetting values and deleting properties
    • Easing
    • Setting eases of a motion tween
    • Using preset eases
    • Animating 3D Motion
    • Testing Your Movie

Duration: One day


Adobe Flash CS6 - Advanced (CSC433)

Date: 3 Apr 2014 (Thu)
Time: 9:30 a.m. - 17:15 p.m
Venue: AC2-4101

 

Course Outline:

  1. Creating Interactive Navigation
    • Getting Started
    • About Interactive Movies
    • Creating Buttons
    • Creating a button symbol
    • Duplicating buttons
    • Swapping bitmaps
    • Placing the button instances
    • Naming the button instances
    • Understanding ActionScript 3.0
    • About ActionScript
    • Understanding scripting terminology
    • Variable
    • Keyword
    • Arguments
    • Function
    • Objects
    • Methods
    • Properties
    • Using proper scripting syntax
    • Navigating the Actions panel
    • Preparing the Timeline
    • Adding a Stop Action
    • Creating Event Handlers for Buttons
    • Adding the event listener and function
    • Checking syntax and formatting code
    • Creating Destination Keyframes
    • Inserting keyframes with different content
    • Using labels on keyframes
    • Creating a Home Button with Code Snippets
    • Adding another button instance
    • Using the Code Snippets panel to add ActionScript
    • Code Snippets Options
    • Creating your own code snippet
    • Sharing your code snippet
    • Playing Animation at the Destination
    • Creating transition animations
    • Using the gotoAndPlay command
    • Stopping the animations
    • Animated Buttons
    • Creating the animation in a movie clip symbol
  2. Using Text
    • Getting Started
    • Understanding TLF Text
    • Merging the TLF Text library
    • Adding Simple Text
    • Adding the titles
    • Creating vertical text
    • Modifying characters
    • Adding Multiple Columns
    • Modifying the text box
    • Using the Tab Ruler
    • Wrapping Text
    • Adding the graphics
    • Linking the text boxes
    • Adding content to the linked text boxes
    • Deleting and inserting text boxes
    • Breaking and relinking text boxes
    • Hyperlinking Text
    • Adding a hyperlink
    • Creating User-input Text
    • Adding the static text elements
    • Adding the display fields
    • Embedding fonts
    • Naming the text boxes
    • Changing the contents of text boxes
    • Testing the calculator
    • Loading External Text
    • Naming the text boxes
    • Embedding the fonts
    • Loading and displaying external text
  3. Working with Sound and Video
    • Getting Started
    • Understanding the Project File
    • Using Sounds
    • Importing sound files
    • Placing sounds on the Timeline
    • Adding frames to the Timeline
    • Clipping the end of a sound
    • Changing the volume of a sound
    • Deleting or changing the sound file
    • Setting the quality of the sounds
    • Adding sounds to buttons
    • Understanding Flash Video
    • Using Adobe Media Encoder
    • Adding a video file to Adobe Media Encoder
    • Converting video files to Flash Video
    • Understanding Encoding Options
    • Cropping your video
    • Adjusting video length
    • Setting advanced video and audio options
    • Saving advanced video and audio options
    • Playback of External Video
    • Controlling the video playback
    • Working with Video and Transparency
    • Importing the video clip
    • Using a Green Screen
    • Using Cue Points
    • Inserting cue points
    • Detecting and responding to cue points
    • Adding the synchronized Flash elements
    • Finishing touches
    • Embedding Flash Video
    • Encoding the FLV for embedding
    • Embedding an FLV on the Timeline
    • Using embedded video
  4. Loading and controlling Flash Content
    • Getting Started
    • Loading External Content
    • Using the Code Snippets Panel
    • Removing External Content
    • Controlling Movie Clips
    • Creating Masks
    • Define the Mask and Masked layers
    • Create the mask

Duration:One day


Adobe Dreamweaver CS6 - Introduction (CSC434)

Date: 21 Nov 2013 (Thu)
Time: 9:30 a.m. - 5:15 p.m
Venue: AC2-4101
Date: 10 Apr 2014 (Thu)
Time: 9:30 a.m. - 5:15 p.m
Venue: AC2-4101

Course Outline:

  1. Customizing Your Workspace
    • Touring the workspace
    • Switching and splitting views
    • Design view
    • Code view
    • Split view
    • Working with panels
    • Minimizing
    • Floating
    • Dragging
    • Grouping, stacking, and docking
    • Selecting a workspace layout
    • Adjusting toolbars
    • Personalizing preferences
    • Creating custom keyboard shortcuts
    • Using the Property inspector
    • Using the HTML tab
    • Using the CSS tab
    • Image properties
    • Table properties
  2. HTML Basics
    • What is HTML?
    • Where did HTML begin?
    • Writing your own HTML code
    • Understanding HTML syntax
    • Inserting HTML code
    • Formatting text with HTML
    • Applying inline formatting
    • Adding structure
    • Writing HTML in Dreamweaver
    • Frequently used HTML 4 codes
    • HTML tags
    • HTML character entities
    • Introducing HTML5
    • What’s new in HTML5
    • HTML5 tags
    • New techniques and technologies
  3. CSS Basics
    • What is CSS
    • HTML vs. CSS formatting
    • HTML defaults
    • CSS box model
    • Formatting text
    • Cascade theory
    • Inheritance theory
    • Descendant theory
    • Specificity theory
    • Code Navigator
    • Formatting objects
    • Width
    • Height
    • Borders and backgrounds
    • Margins and padding
    • Positioning
    • Multiples, classes, and IDs, oh my!
    • Applying formatting to multiple elements
    • Creating class attributes
    • Creating ID attributes
    • CSS3 overview and support
    • CSS3 features and effects
    • Additional CSS support
  4. Creating a Page Layout
    • Web design basics
    • What is the purpose of the website?
    • Who is the customer?
    • How do they get here?
    • Scenario
    • Working with thumbnails and wireframes
    • Creating thumbnails
    • Creating a page design
    • Creating wireframes
    • Defining a Dreamweaver site
    • Using the Welcome screen
    • Previewing your completed file
    • Modifying an existing CSS layout
    • Adding a background image to the header
    • Inserting new components
    • Changing element alignment
    • Modifying the page width and background color
    • Modifying existing content and formatting
    • Inserting an image placeholder
    • Inserting placeholder text
    • Modifying the footer
    • Checking browser compatibility

Duration:One day


Adobe Dreamweaver CS6 - Advanced (CSC435)

Date: 24 Apr 2014 (Thu)
Time: 9:30 a.m. - 5:15 p.m.
Venue: AC2-4101

Course Outline:

  1. Working with Templates
    • Previewing completed files
    • Creating a template from an existing layout
    • Inserting editable regions
    • Producing child pages
    • Updating a template
    • Using library items
    • Creating a library item
    • Updating library items
    • Using server-side includes
    • Creating server-side includes
    • Inserting server-side includes
    • Updating server-side includes
  2. Working with Images
    • Reviewing web image basic
    • Vector graphics
    • Raster graphics
    • Resolution
    • Size
    • Color
    • Raster image file formats
    • GIF
    • JPEG
    • PNG
    • Previewing the completed file
    • Inserting an image
    • Adjusting image positions with CSS classes
    • Working with the Insert panel
    • Using Adobe Bridge to insert images
    • Inserting non-web file types
    • Working with Photoshop Smart Objects
    • Copying and pasting images from Photoshop and Fireworks
    • Inserting images by drag and drop
    • Optimizing images with the Property inspector
    • Bonus exercise: completing the news page
  3. Working with Navigation
    • Hyperlink basics
    • Internal and external hyperlinks
    • Relative vs. absolute hyperlinks
    • Previewing the completed file
    • Creating internal hyperlinks
    • Creating an image-based link
    • Creating an external link
    • Setting up email links
    • Targeting page elements
    • Creating a link destination using an ID
    • Adding an ID to an HTML table
    • Inserting Spry menu bars
    • Modifying Spry menus directly
    • Customizing the appearance of the Spry menu bar
    • Editing CSS using the Code Navigator
    • Checking your page
  4. Adding Interactivity
    • Learning about Dreamweaver behaviors
    • Previewing the completed file
    • Working with Dreamweaver behaviors
    • Applying a behavior
    • Applying a Swap Image Restore behavior
    • Removing applied behaviors
    • Adding behaviors to hyperlinks
    • Working with Spry Accordion widgets
    • Inserting a Spry Accordion widget
    • Adding additional panels
    • Customizing a Spry Accordion

Duration: One day


Adobe Fireworks CS5 - Introduction (CSC430)

Course Outline:

  1. Getting to know the workspace
    • The Interface
    • Preparing the canvas
    • Using the Tools panel
    • Using the Property inspector
  2. Working with Bitmap Graphics
    • Resolution and file size
    • Cropping an image
    • Managing images on the canvas
    • Hiding and locking objects
    • Distortion-free bitmap scaling
    • Adjusting tonal range
    • Applying the Unsharp Mask Live Filter
  3. Working with Selections
    • About selecting objects and selection tools
    • Bitmap selection tools
    • Selecting and modifying with the Magic Wand tool
    • Using the Magic Wand tool with keyboard modifiers
    • Selecting with the lasso tools
    • Converting a selection to a path
  4. The Layers Panel
    • About layers
    • Identifying objects
    • Naming objects
    • Rearranging objects within a layer
    • Moving objects from one layer to another
    • Protecting layers
  5. Working with Text
    • Text basics
    • Creating a fixed-width text block
    • Editing text
    • Flowing text within a vector shape
    • Anti-aliasing
    • Special text effects
    • Using text as a mask
    • Adding Live Filters to a masked object

Duration: One day

Pre-requisite(s):


Adobe Fireworks CS5 - Advanced (CSC431)

Course Outline:

  1. Masking
    • About masks
    • Designing the banner ad
    • Editing gradient colors
    • Editing gradient direction and angle
    • Creating and editing masks
    • Converting a bitmap selection to a mask
    • Editing a bitmap mask
    • Applying Live Filters to a masked image
  2. Using Symbols
    • What are symbols?
    • Graphic symbols
    • The universal Common Library
    • Adding a graphic symbol to a document
    • Button symbols
    • Adding more buttons
    • Testing rollovers
    • Completing the design
    • Animation symbols
  3. Prototyping Basics
    • Exploring the Pages panel
    • Master pages
    • Comparing page designs
    • Page stacking order
    • Creating a master page
    • Adding more pages
    • Creating a secure, interactive PDF
  4. Working with Vector Graphics
    • About vectors
    • Basic vector drawing techniques
    • Resizing vectors
    • Changing the appearance of basic vector shapes
    • Distortion-free vector scaling with the 9-slice Scaling tool
    • Adding text to your design
    • Understanding paths and the Pen tool
    • Editing paths
    • Customizing fills and strokes
    • Customizing the stroke
  5. Optimizing for the Web
    • Optimization basics
    • Web graphic formats
    • About the Optimize panel
    • Optimizing a single image file
    • Working with previews
    • Choosing optimization settings
    • Exporting the file
    • Creating and optimizing slices
    • Creating slices manually with the Slice tool
    • Adding interactivity
    • Exporting composite designs

Duration: One day


Adobe Photoshop CS6 - Introduction (CSC436)

Date: 3 Jul 2014 (Thu)
Time: 9:30 a.m. - 5:15 p.m.
Venue: AC2-4200

Course Outline:

  1. Computer Graphics & Photoshop Startup
    • Understanding Graphic format
    • About pixel dimensions and resolution
    • About monitor resolution
    • About printer resolution
    • Resampling
    • Color modes
    • Convert an image to another color mode
    • Getting Start With Photoshop
    • About tools
    • Use a tool
    • Move a selection
    • Transform freely
    • Zoom in or out
    • About selecting pixels
    • Select with the marquee tools
    • Adobe Color Picker overview
    • About layers
    • About type and type layers
    • Saving image files
    • Save large documents
  2. Select bitmap effectively
    • Select Bitmap
    • Select, deselect, and reselect pixels
    • Select with the Lasso tool
    • Select with the Magnetic Lasso tool
    • Select with the Quick Selection tool
    • Select with the Magic Wand tool
    • Select a color range
    • Adjust selections manually
    • Refine selection edges
    • Soften the edges of selections
    • Extract an object from its background
    • Save and load selections
    • Create a temporary quick mask
    • Refine Edge
  3. Colour Adjustment and Enhancement
    • Before making color and tonal adjustments
    • Adjustments panel overview
    • Correcting Colors in CMYK and RGB
    • About histograms
    • Adjust tonal range using Levels
    • Adjust color and tonality with Curves
    • Adjust hue and saturation
    • Adjust color saturation using Vibrance
    • Improve shadow and highlight detail
    • Apply the Color Balance adjustment
    • Apply a gradient map to an image

Duration: One day


Adobe Photoshop CS6 - Advanced (CSC437)

Date: 17 Jul 2014 (Thu)
Time: 9:30 a.m. - 5:15 p.m.
Venue: AC2-4200

Course Outline:

  1. Retouching and Repairing Images
    • Crop images
    • Sharpen using Unsharp Mask
    • Blur filters
    • Reduce image noise and JPEG artifacts
    • Noise filters
    • Retouching tools gallery
    • Retouch with the Clone Stamp tool
    • Retouch with the Healing Brush tool
    • Red Eye Tool
    • Dodge or burn areas
    • About blending modes
    • Content Aware Fill
    • Content-aware scaling
    • Blending mode examples
  2. Nondestructive editing, Masks & Channels
    • About Smart Objects
    • Edit the content of a Smart Object
    • Apply a Smart Filter
    • Group and ungroup layers
    • Link and unlink layers
    • Align objects on different layers
    • Automatically align image layers
    • Auto blend layers
    • Specify a tonal range for blending layers
    • Create a knockout
    • About layer and vector masks
    • Add layer masks
    • Unlinking layers and masks
    • Load a layer or layer mask's boundaries as a selection
    • Combine multiple images into a group portrait
  3. Effects, Styles, Patterns and Automate Tasks
    • About layer effects and styles
    • Layer Style dialog box overview
    • Create and manage preset styles
    • Scale a layer effect
    • Convert a layer style to image layers
    • About patterns
    • Define an image as a preset pattern
    • About layer comps
    • Apply and view layer comps
    • About actions
    • Actions panel overview
    • Play an action on a file
    • Record an action
    • Puppet tools
    • Apply the Lighting Effects filter
    • Brush presets
    • Mixer Brush
    • Repoussé
    • Create 3-D image
    • Merge To HDR
    • Animation Gif

Duration: One day


Adobe Illustrator CS6 - Introduction (CSC438)

Date: 14 Aug 2014 (Thu)
Time: 9:30 a.m. - 5:15 p.m.
Venue: AC2-4200

Course Outline:

  1. Start Up with Illustrator
    • Tools panel overview
    • About templates
    • Drawing basics
    • About paths
    • About direction lines and direction points
    • About color
    • CMYK
    • About fills and strokes
    • About swatches
    • Add colors from artwork to Swatches panel
    • Apply or edit a gradient
    • Gradient panel and Gradient tool overview
    • About effects
    • Apply an effect
    • Create a drop shadow
    • About saving artwork
    • Save artwork for Microsoft Office
  2. Drawing & Colouring I
    • Drawing simple lines and shapes
    • Draw rectangles and squares
    • Draw polygons
    • Drawing with the Pen tool
    • Rulers, grids, guides, and crop marks
    • Change the unit of measurement
    • Use guides
    • Smart Guides
    • Measure the distance between objects
    • Editing paths
    • Adding and deleting anchor points
    • Smooth and simplify paths
    • Convert between smooth points and corner points   
    • Erase artwork
    • Selecting and arranging objects
    • Select objects with the Selection tool
    • Group or ungroup objects
    • Transforming
    • Transform panel overview
    • Move objects
    • Align and distribute objects
    • Rotate objects
    • Reflect objects
    • Duplicate objects by dragging
    • Offset duplicate objects
    • Reshaping objects with effects
  3. Drawing & Colouring II
    • Methods of combining objects
    • Pathfinder panel overview
    • Summary of Pathfinder effects
    • About compound shapes
    • About compound paths          
    • Methods for cutting, dividing, and trimming objects
    • Clipping masks
    • Create 3D objects
    • Map artwork to a 3D object
    • About Live Paint
    • Trace artwork
    • Change the opacity of artwork

Duration: One day


Adobe Illustrator CS6 - Advanced (CSC439)

Date: 28 Aug 2014 (Thu)
Time: 9:30 a.m. - 5:15 p.m.
Venue: AC2-4200

Course Outline:

  1. Painting, Brushes, Symbol & Appearance
    • Draw and merge paths with the Blob Brush tool
    • About brushes
    • Work with brush libraries
    • Apply brush strokes
    • Draw paths and apply brush strokes simultaneously
    • Convert brush strokes to outlines
    • Calligraphic brush options
    • Colorization options for scatter, art, and pattern brushes
    • Scatter brush options
    • Art brush options
    • Pattern brush options 
    • About patterns
    • Guidelines for constructing pattern tiles
    • Create pattern swatches
    • Create corner tiles for brush patterns
    • About symbols
    • Create a symbol
    • Symbol libraries
    • About symbol sets
    • Modify symbol instances in a symbol set
    • About appearance
    • Edit or add an appearance attribute
    • Copy appearance attributes between objects
  2. Types, Layout & Printing
    • Enter text at a point
    • Enter text in an area
    • Wrap text around an object
    • Enter text along a path
    • Move or flip text along a path
    • Convert type to outlines         
    • About linked and embedded artwork
    • Place (import) files
    • Links panel overview  
    • Specify document setup options
    • Setting up documents for printing
    • Using multiple artboards
    • Print multiple artboards          
    • Specify crop marks for trimming or aligning
    • About printer’s marks 
    • About bleed
    • About Adobe PDF
    • Create Adobe PDF files
    • TIFF export options
    • About web graphics
    • About slices
    • Web graphic formats
  3. Advanced Technique: Special Effects, Blend & Mesh
    • Appearance panel overview
    • About effects
    • Apply an effect
    • About graphic styles
    • Graphic Styles panel overview
    • Create a graphic style 
    • Gradient Mesh Tool, Gradients & Blends
    • About blended objects
    • Create a blend with the Blend tool
    • Blend options
    • Meshes
    • Create mesh objects
    • Edit mesh objects
    • Width Tool
    • Change the caps or joins of a line
    • Add arrowheads
    • Shape Builder Tool
    • Gap Detection
    • Bristle Brush
    • Drawing Mode
    • Prespective Drawing

Duration: One day


Adobe Acrobat (CSC103)

Date: 8 May 2014 (Thu)
Time: 9:30 a.m. - 5:15 p.m.
Venue: AC2-4101

Course Outline:

  1. Looking at the Work Area
    • Workspace basics
    • Adjusting the view of PDFs
    • Navigating PDF pages
  2. Creating Adobe PDF Files
    • Create PDFs by printing to file
    • About Acrobat PDFMaker
    • Convert a file to PDF using PDFMaker
    • View PDFMaker conversion settings
    • Convert Microsoft Word, PowerPoint, and Excel files to PDF
    • Convert email messages to PDFs
    • Set up automatic email archiving
    • Create PDFs from Word mail merges
    • PDFs from Microsoft Project (Acrobat Pro)
    • Convert Visio files to PDF (Acrobat Pro)
    • Convert a file to PDF using Acrobat
    • Drag and drop to create PDFs
    • Convert clipboard content to PDF
    • Create a PDF from a blank page
    • Create multiple PDFs from multiple files (Acrobat Pro)
    • Correct OCR text in PDFs
    • Enable Fast Web View in a PDF
  3. Saving and exporting PDFs
    • Saving PDFs
    • Exporting PDFs to other file formats
    • Reusing PDF content
  4. Editing PDF
    • Edit text in a PDF
    • Add to a numbered or bulleted list
    • Add new text to a PDF
    • Add text to flat forms or when signing (Typewriter tool)
    • Move, rotate, or resize a text box
    • Place an image or object into a PDF
    • Move or resize an image or object
    • Rotate, flip, crop (clip), or replace an image
    • Move an image or object in front or behind other elements
    • Edit an image outside of Acrobat
    • About bookmarks
    • Create a bookmark
    • Edit a bookmark
    • Create a bookmark hierarchy
    • Add tagged bookmarks
  5. Accessibility
    • Characteristics of Accessible PDF files
    • Make Accessible action
    • Read a PDF with Read Out Loud
  6. Commenting
    • Mark up text with edits
    • Commenting in PDFs
  7. Printing
    • Basic PDF printing tasks
    • Print a booklet
    • Print PDFs in a PDF Portfolio
  8. PDF Form
    • Create a form from an existing document
    • Enable Reader users to save form data
  9. Adding security
    • Password security and restricting printing, editing, and copying
    • Add a password to a PDF
    • Restrict editing of a PDF
    • Restrict printing, editing, and copying
    • Remove password security

Duration: One day

Pre-requisite(s):Participants should have a sound working knowledge of the Windows environment.


Introduction to JavaScript (CSC109)

JavaScript is an easy-to-use programming language that can be embedded in the header of your Web pages. It can enhance the dynamics and interactive features of your page by allowing you to perform calculations, check forms, write interactive games, add specific visual effects, customise graphics selections, create security passwords and more.

Course Outline:

  1. Introduction
    • What is JavaScript, and What Can It Do?
    • How Do I Put JavaScript in My Pages?
    • What is Object Oriented Programming?
  2. The Message Box
    • Basic Structure
    • Alert Command
    • Forms
  3. Making Logical Decision
    • The Prompt() Function
    • The If-Then Statement
  4. Looping
    • Looping with For Statement
    • Useful Properties & Operators
    • Putting it all together
  5. Methods
    • Window Methods
    • Date Methods
    • Strings
  6. Windows
    • Window. Open()
    • The Document Object
  7. Events
    • Event in a Form
    • onChange Events
    • Dropdown List
    • Check Boxes
    • onLoad Events
    • The SetTimeout() Method
    • Common Attributes Controlled by the Style Sheet
  8. Introducing Dynamic HTML
    • What is Dynamic HTML Style Sheets
    • Style Sheets in Depth
    • Linking to a Style Sheet
    • Importing Style Sheets
    • Inline Styles
    • The DIV and SPAN Tags

Duration: One day

Pre-requisite(s):Participants should have knowledge of at least one programming language, and have taken the course Introduction to HTML (CSC108).


JavaScript - Advanced (CSC113)

Course Outline:

  1. JavaScript Objects
    • Object-Oriented Programming Concepts
    • Defining your own Object:
      • The new Statement
      • Objects as arrays
    • Using variable length arrays and extended instances
    • Built-in objects
    • Math Object
    • Date Object
    • String Object
    • Browser & HTML Objects
  2. Creating your own Java-script Objects
    • Global and local Variables
    • More on Java Script Functions
    • JavaScript's Associative Arrays
    • JavaScript HTML Objects
  3. Using Frames & Cookies in Advanced Application
    • Storing Parameters and other data
    • Command-line Parameters
    • Storing persistent Data in cookies
    • Frames & JavaScript
    • Specifying Frames in HTML
    • Building a frameset
  4. Controlling Web page Appearance
    • Web Building with Java Script
    • Text properties & color Values
  5. Advanced Techniques
    • XML & XHTML
    • Debugging Scripts
    • Regular Expressions

Duration: One day

Pre-requisite(s): Participants should have knowledge of at least one programming language, and have taken the course Introduction to JavaScript (CSC109).


Introduction to HTML (CSC108)

HTML is the language used to create World Wide Web pages on the Internet and it stands for HyperText Markup Language. This course guides you through the elements required to create the Web pages using HTML. All jargon terms will be carefully explained.

Course Outline:

  1. What is an HTML document
  2. Page creation and editing
  3. Basic structure
  4. Headings, line breaks and horizontal rules
  5. Text and paragraphing lists
  6. Linkage to URLs and specific sections
  7. Adding images and tables

Duration: One day

Pre-requisite(s): Participants should have a sound working knowledge of the Windows environment and Internet.


Introduction to XML (CSC107)

This is a practical course for developers with no experience in creating XML documents. The course teaches basic XML mark-up using XML 1.0 and some related extensions.

Course Outline:

  1. XML Basics
    • Elements
    • Hierarchies
    • Attributes
    • Declarations
    • Entities
    • Well-formed documents
  2. Document type definitions
    • Document models
    • When to use a DTD
    • How to use a DTD
    • Validation
    • DTD Markup Syntax
  3. Document modelling techniques
  4. Links
  5. Namespaces
  6. More XML Extensions

Duration: One day

Pre-requisite(s): Completed Introduction to HTML (CSC108) and XML – Overview (CSC106) or with equivalent knowledge.


How to Secure your PC for Windows 7

Course Outline:

  1. Computer Security Basics
  2. Techniques used by Hackers
  3. Anti-Virus Software
  4. Use a Firewall
  5. Applying Patches, Running Windows Updates & Internet Protection
  6. Practicing Safe Computing

Duration: 3 hours


Chinese Input Method - Chang Jei

Course Outline:

  1. 倉頡輸入法簡介
  2. 倉頡字母
  3. 輔助字形
  4. 倉頡輸入法
  5. 字形取碼注意事項
  6. 例外字
  7. 省略原則
  8. 定義字首

Duration: 3 hours


Chinese Input Method - Q9

Course Outline:

  1. 九方輸入系統簡介
  2. 字形輸入
  3. 輸入小貼士(姓氏、標點、多碼字)
  4. 檢字
  5. 筆劃輸入
  6. 輔助功能

Duration: 3 hours


Microsoft Word - Introduction

Course Outline:

  1. The Microsoft Word 2010 Screen
  2. Compatibility Mode
  3. Manipulating Text
  4. Paragraph Formatting
  5. Borders and shading
  6. Page Formatting
  7. Headers & Footers
  8. Tables
  9. Pictures
  10. Using graphics within Microsoft Word
  11. Proofing and Printing

Duration: 3 hours


Microsoft Word - Advanced

Course Outline:

  1. Paragraph Formatting
  2. Sections
  3. Styles
  4. AutoCorrect
  5. Building Blocks (AutoText)
  6. Captions
  7. Footnotes and Endnotes
  8. Bookmarks
  9. Tables of Contents & Indexes
  10. Master Documents
  11. Tracking and Comments
  12. Comparing and Combining Documents
  13. Macros
  14. Mail Merging
  15. Passwords and Editing Restrictions

Duration: 3 hours


Microsoft Excel - Introduction

Course Outline:

  1. Using Excel 2010
  2. Selection techniques
  3. Manipulating rows and columns
  4. Manipulating cells and cell content
  5. Worksheets
  6. Manipulating Worksheets
  7. Paste Special Options
  8. Alignment formatting
  9. Number formatting
  10. Freezing
  11. Formulas
  12. Functions
  13. Charts
  14. Customising Excel
  15. Setup & Printing Issues

Duration: 3 hours


Microsoft Excel - Advanced

Course Outline:

  1. Functions and Formulas
  2. Logical Functions
  3. Lookup Functions
  4. Database Functions
  5. Cell Formatting
  6. Pivot Tables
  7. Input Tables
  8. Importing Text Files
  9. Sorting and Filtering Data
  10. Tracking and Reviewing Changes
  11. Validating
  12. Auditing
  13. Macros
  14. Passwords & Security Issues

Duration: 3 hours


Microsoft PowerPoint - Introduction

Course Outline:

  1. Using PowerPoint 2010
  2. Creating a Presentation
  3. Manipulating Slides
  4. Themes
  5. Text Boxes
  6. Manipulating text
  7. Paragraph Formatting
  8. Graphics
  9. Manipulating Graphics
  10. Inserting Charts
  11. Manipulating Slides
  12. Slide Masters
  13. Slide Shows
  14. Customising and Compatibility Issues

Duration: 3 hours


Microsoft PowerPoint - Advanced

Course Outline:

  1. Sections
  2. Slide MastersThemes
  3. Themes
  4. Formatting Pictures & Images
  5. Diagrams
  6. Video and Audio
  7. Animation
  8. Linking and Embedding
  9. Merging, Comparing and Exporting
  10. Slide Show
  11. Sharing Presentation
  12. Design and Compatibility

Duration: 3 hours


Introduction to Access

Course Outline:

  1. Database Concepts
  2. Opening a Database & Security Issues
  3. Tables, Fields and Field Types
  4. Table Navigation & Modification
  5. Field Properties
  6. Manipulating Tables & Records
  7. Primary Keys and Indexing
  8. Filtering
  9. Sorting
  10. Searching
  11. Forms
  12. Queries
  13. Reports

Duration: 3 hours


Flash Introduction

Course Outline:

  1. Creating Simple Document
  2. Creating fla File and Adding Graphics
  3. Drawing On Stage
  4. Creating Symbol and Animation
  5. Publishing

Duration: 3 hours


MS Live & Google Apps

Course Outline:

  1. Create User Account
  2. Microsoft Live
  3. Outlook Connector
  4. Google Apps
  5. Using Google Mail in Outlook

Duration: 3 hours


Photoshop - Introduction

Course Outline:

  1. Workspace Basics
  2. Color Fundamentals
  3. Converting Between Color Modes
  4. Adjusting Crop, Rotation and Canvas
  5. Filter Basics
  6. Retouching Basics

Duration: 3 hours


Microsoft Word 2010 - Introduction (CSC501)

Date: 24 Nov 2011 (Thur)
Time: 9:30 a.m. - 5:15 p.m.
Venue: CY-2252 (AC1-Q)
Date: 10 May 2012 (Thur)
Time: 9:30 a.m. - 5:15 p.m
Venue: CY-P

 

Course Outline:

  1. The Microsoft Word 2010 Screen
    • Starting Microsoft Word 2010
    • The Microsoft Word 2010 screen
    • The levels of command organisation
    • The File Tab
    • Ribbon Tabs
    • Minimizing the Ribbon
    • Switching between tabs using the mouse wheel
    • Groups
    • Dialog box launcher
  2. Starting to Use Microsoft Word 2010
    • Using the default Microsoft Word document
    • Saving Microsoft Word documents
    • Opening and closing documents
    • Save As
    • Creating a new document
    • Using Help within Microsoft Word
    • Alt key help
    • Closing Microsoft Word
    • Saving documents using different formats
    • Creating documents using different templates
    • Switching between Word Views
    • Navigating through documents
  3. Compatibility Mode
    • What is Compatibility Mode?
    • Using the Convert button
  4. Manipulating Text
    • Select, then format
    • Selecting text
    • Inserting, deleting, undo and redo
    • Insert and overtype mode
    • Copying text within a document
    • Moving (cutting) text within a document
  5. Text Formatting
    • What is text Formatting?
    • Font type
    • Font size
    • Grow Font and Shrink Font icons
    • Font size keyboard shortcut
    • Bold, italic or underline
    • Subscript and superscript
    • Case changing
    • Highlighting
    • Font colour
    • Copying text formatting
    • Removing formatting
    • Using Zoom
    • Inserting special characters and symbols
  6. Paragraph Formatting
    • Paragraph marks
    • Soft paragraph (line break) marks
    • Recommended techniques for aligning and indenting text
    • Aligning text
    • Indenting paragraphs
    • Applying single or double line spacing within paragraphs
    • Applying spacing above or below paragraphs
    • Using paragraph spacing rather than using the Return key
    • Applying bullets to a list
    • Applying numbering to a list
    • Modifying bullet and numbering formatting
    • Removing bullet or numbering formatting
  7. Borders and shading
    • Using borders and shading
    • Adding a border
    • Modifying borders
    • Adding shading
    • Modifying your shading
    • Applying borders to selected text
  8. Page Formatting
    • What is Page formatting?
    • Page orientation and paper size
    • Changing the page size
    • Page margins
    • Inserting Page Breaks
    • Deleting Page Breaks
    • Use page breaks rather than repeatedly pressing the Return key
    • Headers and footers
    • Page numbering
    • Header and footer fields
    • Editing text within a header or footer
    • Cover pages
    • Applying Automatic Hyphenation
  9. Headers & Footers
    • Applying different headers and footers to sections
    • Applying different headers and footers to the first page
    • Applying different headers and footers to odd and even pages
  10. Tables
    • Using tables
    • Inserting a table
    • Navigating within a table
    • Selecting and editing text within a table
    • Selecting cells, rows, columns or the entire table
    • Inserting and deleting rows and columns
    • Modifying column width or row height
    • Modifying cell borders
    • Adding shading to cells
    • Modifying cell border width, colour and style
    • Table styles
    • Merging cells within a table
    • Splitting cells within a table
    • Modifying cell alignment
    • Modifying cell margins
    • Modifying text direction within cells
    • Repeating the table heading row for multi-page tables
    • Controlling row breaking across pages
    • Performing a single column sort
    • Multilevel sorting
    • Converting delimited text to a table
    • Converting a table to text
  11. Using graphics within Microsoft Word
    • Types of graphics that you can insert within Word 2010
    • Inserting Pictures
    • Inserting Clip Art
    • Inserting Shapes
    • Inserting SmartArt
    • Inserting a chart
    • Inserting a screen shot
    • Selecting, resizing and deleting graphics
    • Copying or moving graphics
  12. Proofing and Printing
    • The importance of proofing
    • Spell checking a document
    • Adding words to the built-in custom dictionary
    • Removing a word from the spell checking dictionary
    • Printing options
    • Selecting a printer
    • Choosing what to print
    • Setting the number of copies to print
    • Setting the pages per sheet
    • Printing only odd or even pages
    • Previewing and printing a document

Duration: One day


Microsoft Word 2010 - Advanced (CSC502)

Date: 15 May 2013 (Thu)
Time: 9:30 a.m. - 5:15 p.m
Venue: AC2-4101

Course Outline:

  1. Paragraph Formatting
    • Line spacing formatting options
    • Using the Widow/Orphan control
    • Using 'Keep lines together'
    • Using the 'keep with next' option
    • Using 'page break before'
    • Applying and modifying multilevel list formatting
  2. Sections
    • What are section breaks?
    • Inserting 'next page' section breaks
    • Inserting 'odd page' section breaks
    • Changing the section break type
    • Deleting section breaks
    • Changing page orientation within sections
    • Changing page vertical alignment within sections
    • Changing margins within sections
  3. Styles
    • Applying styles
    • Types of styles
    • Creating a paragraph style
    • Creating a character style
    • Modifying a style
    • Enabling automatic style updating
    • Deleting a style
  4. AutoCorrect
    • Creating, modifying and deleting an AutoCorrect entry
  5. Building Blocks (formerly called AutoText)
    • Creating and inserting Building Block items
    • Modifying a Building Block (AutoText) item
    • Deleting a Building Block (AutoText) item
  6. Captions
    • Manually adding a caption to an object
    • Adding and removing caption labels
    • Changing the caption number formatting
  7. Footnotes and Endnotes
    • Inserting footnotes
    • Editing and formatting footnotes
    • Inserting endnotes
    • Editing and formatting endnotes
    • Converting footnotes to endnotes
    • Converting endnotes to footnotes
  8. Bookmarks
    • Adding a bookmark
    • Deleting a bookmark
  9. Tables of Contents & Indexes
    • Creating a table of contents
    • Updating a table of contents
    • Creating and updating a table of figures
    • Marking an index entry
    • Marking an index sub-entry
    • Compiling and updating an index
  10. Master Documents
    • What are Master Documents?
    • Creating a new master document by creating sub-documents from headings
    • Inserting sub-documents into a master document
    • Unlinking or removing a sub-document from a master document
    • Using text outline options
  11. Tracking and Comments
    • Tracking changes
    • Accepting or rejecting changes
    • Inserting comments
    • Displaying and editing comments
    • Deleting comments
    • Showing or hiding comments
  12. Comparing and Combining Documents
    • Comparing documents
    • Combining revisions from multiple authors
  13. Macros
    • Macro to change page set-up
    • Macro to insert a table with a repeating heading row
    • Macro to insert fields into a header or footer
    • Assigning a macro to a button on a toolbar
  14. Mail Merging
    • What is mail merging?
    • Starting the Mail Merge Wizard
    • Mail Merge Wizard - Step 1 of 6 'Select document type'
    • Mail Merge Wizard - Step 2 of 6 'Select Starting document'
    • Mail Merge Wizard - Step 3 of 6 'Select recipients'
    • Mail Merge Wizard - Step 4 of 6 'Write your letter'
    • Mail Merge Wizard - Step 5 of 6 'Preview your letters'
    • Mail Merge Wizard - Step 6 of 6 Printing Options
    • Creating a mailing list to be used within a mail merge
    • Merging a mailing list to produce labels
    • Editing and sorting a mail merge recipient list
    • Sorting and editing a mail merge recipient list (within the mail merge process)
    • Ask fields and bookmarks
    • Inserting Ask fields
    • Inserting if...then...else... fields
    • Using merge criteria in a mail merge
  15. Passwords & Editing Restrictions
    • Adding 'opening' password document protection
    • Removing 'open' password document protection
    • Adding 'No Modifications' document password protection
    • Removing a 'no modification' document password
    • Allowing only tracked changes or comments
    • Marking a document as a Final Version

Duration: One day


Microsoft Access 2010 - Introduction (CSC503)

Date: 29 May & 5 Jun 2014 (Thur)
Time: 9:30 a.m. - 5:15 p.m
Venue: AC2-5506

Course Outline:

  1. Database Concepts
    • What is a database?
    • Database Examples
    • What is a relational database?
    • What is a table?
    • What is a record (row)?
    • What is a field (column)?
    • What is data?
    • The difference between data and information
    • Data types
    • Common uses of large-scale databases
    • Keeping data discrete
    • Each field should contain only one item
    • Database designers, database administrators and database users
  2. Opening aDatabase & Security Issues
    • Opening a database within your samples folder
    • Trusted Locations - Using the Trust Centre
    • Setting the default folder location within Access
    • Closing the Access program
  3. Tables, Fields and Field Types
    • Creating a new blank database
    • Adding fields and setting the field type
    • About Access Data Types
    • Closing and naming a table
  4. Table Navigation & Modification
    • Opening a table within a database
    • Switching between 'Datasheet View' and 'Design View'
    • Adding records to a table
    • Saving changes made to a table
    • Navigating through records within a table
    • Adjusting column width
    • Automatically resizing a column width to fit contents
    • Moving a column to rearrange the column order
  5. Field Properties
    • Field Properties
    • Input Masks
    • Validating Numbers
    • Validating Dates
    • Data Entry Required / Not Required
    • Field Properties - Reference Materials
    • Field Properties - Logical Operators
    • Field Properties - Validation Rule Examples
    • Field Properties - General
    • Field Properties - Format
    • Field Properties - Input Mask Characters
    • Field Properties - Input Mask Examples
  6. Manipulating Tables & Records
    • Renaming a table
    • Editing data within a record
    • Deleting data within a record
    • Using the Undo command
    • Deleting a single record
    • Deleting multiple records
    • Using Save As to back up the database using a different filename
    • Deleting a table
  7. Primary Keys and Indexing
    • Defining a Primary Key
    • Indexing - Reference Notes
    • Creating a single-field Index
    • Creating a multiple-field Index
    • Deleting multi-field indexes
  8. Filtering
    • Text Filters
    • Applying a single filter
    • Clearing a single filter
    • Creating multiple filters
    • Clearing multiple filters
  9. Sorting
    • Sorting Records A-Z
    • Sorting records Z-A
    • Removing a sort
    • Sorting on multiple fields
  10. Searching
    • Searching through records
  11. Relationships
    • Table relationships
    • One-to-many relationship
    • Many-to-many relationship
    • One-to-one relationships
    • Creating relationships between tables
    • About Referential integrity
    • Enabling Referential Integrity
    • Cascade options
    • Cascade update related fields
    • Cascade delete related records
    • Enabling cascade options
    • Deleting relationships
  12. Forms
    • Forms overview
    • Creating forms
    • Modifying forms
    • Modifying a form title
    • Changing a form logo
    • Modifying a form label
    • Saving a form
    • Form View
    • Adding and formatting attachments
    • Modifying data within records
    • Deleting records using a form
    • Adding records using a form
    • Adding or deleting text in a record using a form
    • Closing forms
    • Opening forms
    • Deleting a form
    • Filtering a form
    • Removing a filter from a form
    • Inserting and modifying a form header
    • Inserting and modifying a form footer
  13. Queries
    • What are queries?
    • Creating a simple query
    • Adding (and removing) criteria to a query
    • Running a query
    • Editing criteria in a query
    • Saving a query
    • Creating a two table query and sorting the results
    • Refining your query
    • What are Wildcards?
    • Deleting a query
    • Hiding and un-hiding fields within a query
  14. Reports
    • What are reports?
    • Creating a simple report
    • Using the Report Wizard
    • Modifying the layout of a report
    • Widening a report column
    • Modifying the report title
    • Adding a logo to a report
    • Formatting a form using themes
    • Modifying field names within a report
    • Inserting and formatting the date & time
    • Adding existing fields to a report
    • Resizing reports for printing
    • Totals
    • Closing a report
    • Deleting a report

Duration: 2 day / 12 hours


Microsoft Access 2010 - Advanced (CSC504)

Date: 19 & 26 Jun 2014 (Thu)
Time: 9:30 a.m. - 17:15 p.m
Venue: AC2-4200

Course Outline:

  1. TrustedLocations
    • Allowing Access to your sample folder for this course
  2. Fields
    • What is a table lookup?
    • Creating a lookup within a field
    • Modifying a lookup within a field
    • Deleting a lookup within a field
    • What is an input mask?
    • Creating an input mask
    • Modifying an input mask
    • Deleting an input mask
    • What does data entry required/not required mean?
    • Modifying a field to require data entry
    • Modifying a field so that it does not require data entry
  3. Relationships
    • What is a one-to-one relationship?
    • Creating a one-to-one relationship
    • Modifying a one-to-one table relationship
    • Deleting a one-to-one table relationship
    • What is a one-to-many table relationship?
    • Creating a one-to-many relationship
    • Modifying a one-to-many relationship
    • Deleting a one-to-many relationship
    • What is a many-to-many relationship?
    • Creating a many-to-many relationship using a junction table
    • Modifying or deleting a many-to-many relationship
    • What is referential integrity?
    • Enforcing referential integrity
    • Applying automatic updating of related fields
    • Applying automatic deletion of related records
  4. Joins
    • Applying an inner join
    • Modifying an inner join
    • Applying an outer join
    • Modifying an outer join
    • Creating a subtract join
    • Modifying a subtract join
    • What is a self join?
    • Applying a self join
  5. Queries
    • About queries
    • Creating and running an update query
    • Creating and running a delete query
    • Creating and running a Make Table query
    • Creating and running an Append query
    • Creating and running a crosstab query
    • Creating and running a Find Duplicates query
    • Creating and running a Find Unmatched Records query
    • What is a parameter query?
    • Creating and running a one variable parameter query
    • Modifying a one variable parameter query
    • Creating and running a two variable parameter query
    • Modifying a two variable parameter query
    • Using wildcards in a query: Star
    • Using wildcards in a query: Brackets and dash
    • Using wildcards in a query: Exclamation Mark
    • Using wildcards in a query: Hash
    • Showing Maximum or minimum values in a query
    • Using calculated fields that perform arithmetic calculations
    • Grouping information in a query using functions - sum
    • Grouping information in a query using functions - count
    • Grouping information in a query using functions - Average
    • Grouping information in a query using functions - Max & min
  6. Forms
    • Types of form controls
    • Bound controls vs. unbound controls
    • Creating, modifying and deleting bound controls: text box
    • Creating, modifying and deleting bound controls: combo box
    • Creating modifying and deleting bound controls: list box
    • Creating bound controls: check box
    • Modifying and deleting bound controls: check box
    • Manipulating bound controls: option groups
    • Applying bound control properties: limit to list
    • Applying bound control properties: distinct values
    • Manipulating unbound controls containing arithmetic expressions
    • Manipulating unbound controls containing logical expressions
    • Modifying the tab order within a form
    • What is a sub-form?
    • Creating a sub-form
    • Linking a sub-form
  7. Reports
    • Formatting arithmetic calculation controls to display apercentage
    • Formatting arithmetic calculation controls to display currency
    • Formatting arithmetic calculation controls to display specificdecimal places
    • Applying a running sum for a group or over all
    • What is Concatenation?
    • Concatenating fields within a report
    • Inserting a data field in a report group
    • Inserting a data field in a report page
    • Inserting a data field in report headers and footers
    • Sorting and grouping records in a report by field(s)
    • Forcing page breaks for groups in a report
    • Creating a linked sub-report
  8. Macros
    • Macro to close an object and open another object
    • Macro to open and maximize an object
    • Macro to print and close an object
    • Assigning a macro to a command button
    • Assigning a macro to an object
    • Assigning a macro to a control
  9. Linking Data
    • Linking external data in an Excel workbook to a database
    • Linking external text data in a TXT file to a database
    • Linking external text data in a CSV file to a database
    • Linking external data to a database using existing databasefiles
  10. Importing Data
    • Importing an Excel file into a database
    • Importing a CSV text into a database
    • Importing a TXT file into a database
    • Importing an XML file into a database
    • Importing an existing database file into a database

Duration: 2 day / 12 hours


Microsoft Excel 2010 - Introduction (CSC505)

Date: 24 Jul 2014 (Thu)
Time: 9:30 a.m. - 5:15 p.m.
Venue: AC2-4200

Course Outline:

  1. Using Excel 2010
    • Starting the Excel program
    • What is the Active Cell?
    • The Excel cell referencing system
    • Entering numbers and text
    • Default text and number alignment
    • Summing a column of numbers
    • Entering a date
    • Worksheets and Workbooks
    • Saving a workbook
    • Closing a workbook and exiting the Excel program
    • Creating a new workbook
    • Opening a workbook
    • Switching between workbooks
    • Saving a workbook using another name
    • Saving a workbook using a different file type
    • Getting help within Excel 2010
    • Searching for Help
    • The Help 'Table of Contents'
    • Printing a Help topic
    • Alt key help
  2. Selection techniques
    • Why are selection techniques important?
    • Selecting a cell
    • Selecting a range of connecting cells
    • Selecting a range of non-connecting cells
    • Selecting the entire worksheet
    • Selecting a row
    • Selecting a range of connecting rows
    • Selecting a range of non-connected rows
    • Selecting a column
    • Selecting a range of connecting columns
    • Selecting a range of non-connecting columns
    • Recommended techniques when creating or editing lists
  3. Manipulating rows and columns
    • Inserting rows into a worksheet
    • Inserting columns into a worksheet
    • Deleting rows within a worksheet
    • Deleting columns within a worksheet
    • Modifying column widths
    • Modifying column widths using 'drag and drop'
    • Automatically resizing the column width to fit contents
    • Modifying row heights
  4. Manipulating cells and cell content
    • Copying a cell or range contents within a workbook
    • Deleting cell contents
    • Moving the contents of a cell or range within a workbook
    • Editing cell content
    • Undo and Redo
    • Copying data between worksheets (within the same workbook)
    • Moving data between worksheets (within the same workbook)
    • Moving data worksheets (in different workbooks)
    • Copying data between worksheets (in different workbooks)
    • AutoFill
    • Copying a data range using AutoFill
    • Sorting a cell range
    • Searching and replacing data
  5. Worksheets
    • Switching between worksheets
    • Renaming a worksheet
    • Recommended techniques with naming worksheets
    • Inserting a new worksheet
    • Deleting a worksheet
    • Copying a worksheet within a workbook
    • Moving a worksheet within a workbook
    • Copying or moving worksheets between workbooks
  6. Manipulating Worksheets
    • Copying or moving worksheets between workbooks
    • Splitting a Window
    • Hiding rows
    • Hiding columns
    • Hiding worksheets
    • Un-hiding rows
    • Un-hiding columns
    • Un-hiding worksheets
  7. Formulas
    • Creating formulas
    • The easy way to create formulas
    • Copying formulas
    • Operators
    • Using operators in formulas
    • Formula error messages
    • Relative cell referencing within formulas
    • Absolute cell referencing within formulas
  8. Functions
    • What are functions?
    • Common functions
    • Sum function
    • Average function
    • Max function
    • Min function
    • Count function
    • The COUNTA function
    • The COUNTBLANK function
    • What are 'IF functions'?
    • Using the IF function
  9. Charts
    • Inserting a column chart
    • Inserting a line chart
    • Inserting a bar chart
    • Inserting a pie chart
    • Resizing a chart
    • Deleting a chart
    • Chart title or labels
    • Changing the chart background colour
    • Changing the column, bar, line or pie slice colours in a chart
    • Modifying the legend fill colour
    • Changing the chart type
    • Modifying charts using the Layout tab
    • Copying and moving charts within a worksheet
    • Copying and moving charts between worksheets
    • Copying and moving charts between workbooks
  10. Customising Excel
    • Modifying basic Excel options
    • Minimising the Ribbon
    • AutoCorrect options
  11. Setup & Printing Issues
    • Worksheet margins
    • Worksheet orientation
    • Worksheet page size
    • Headers and footers
    • Header and footer fields
    • Scaling your worksheet to fit a page(s)
    • Visually checking your calculations
    • Displaying gridlines when printing
    • Printing titles on every page when printing
    • Printing the Excel row and column headings
    • Spell checking
    • Previewing a worksheet
    • Viewing workbooks side by side
    • Zooming the view
    • Printing options
    • Setting the number of copies to print
    • Selecting a printer
    • Selecting individual worksheets or the entire workbook
    • Selecting which pages to print
    • Single or double sided printing
    • Collation options
    • Page orientation
    • Paper size
    • Margins
    • Scaling
    • Printing

Duration: One day


Microsoft Excel 2010 - Advanced (CSC506)

Date: 7 Aug 2014 (Thu)
Time: 9:30 a.m. - 17:15 p.m
Venue: AC2-4200

Course Outline:

  1. Functions and Formulas
    • Getting Help with Functions
    • Nested functions
    • Consolidating data using a 3-D reference sum function
    • Mixed references within formulas
  2. Logical Functions
    • IF
    • AND
    • OR
  3. Lookup Functions
    • VLOOKUP
    • HLOOKUP
  4. Database Functions
    • DSUM
    • DMIN
    • DMAX
    • DCOUNT
    • DAVERAGE
  5. Cell Formatting
    • Applying styles to a range
    • Conditional formatting
    • Custom number formats
  6. Pivot Tables
    • Creating and using a pivot table
    • Filtering and sorting data within a pivot table
    • Automatically grouping data in a pivot table and renaming groups
    • Manually grouping data in a pivot table and renaming groups
  7. Input Tables
    • One-input data tables
    • Two-input data tables
  8. Importing Text Files
    • What is a delimited text file?
    • Importing a delimited text file
  9. Sorting and Filtering Data
    • Sorting data by multiple columns at the same time
    • Applying a pre-installed custom sort
    • Creating a customized list and performing a custom sort
    • Removing a customised list
    • Using AutoFilter
    • Top 10 AutoFilter
    • Removing all AutoFilters from a worksheet
    • Advanced Filter Criteria
    • Sub-totalling
    • Removing subtotals
    • Expanding and collapsing outline detail levels
  10. Tracking and Reviewing Changes
    • Enabling or disabling the 'track changes' feature
    • Sharing, comparing and merging worksheets
  11. Validating
    • Data validation - Whole number
    • Data validation - Decimal number
    • Data validation - List
    • Data validation - Date
    • Data validation - Time
    • Data validation - Text Length
    • Customising a validation input message and error alert
    • Removing data validation
  12. Auditing
    • Tracing precedent cells
    • Tracing dependent cells
    • Identifying cells with missing dependents
    • Showing all formulas in a worksheet, rather than the resultingvalues
    • Inserting and viewing comments
    • Editing and deleting comments
    • Showing and hiding comments
  13. Macros
    • Macro to change the page set-up
    • Macro to apply a custom number format
    • Macro to format a cell range
    • Macro to insert fields into the header or footer
    • Assigning a macro to a button on the Quick Access toolbar
    • Deleting macros
  14. Passwords & Security Issues
    • Adding password protection to a workbook
    • Removing password protection
    • Password protecting cells and worksheets
    • Hiding and un-hiding formulas

Duration: One day


Microsoft Outlook 2010 and Exchange (CSC507)

Date: 21 Aug 2014 (Wed)
Time: 9:30 a.m. - 17:15 p.m
Venue: AC2-4200

Course Outline:

  1. Sending Messages
    • Creating and sending your first email
    • Checking that your email was sent
    • Sending emails to more than one person
    • Receiving emails
    • Sending a copy of a message
    • What is a blind carbon copy?
    • Sending a copy of a message to another address using blindcarbon copy
    • Setting the message subject
    • Spell checking your message
    • Attaching a file to a message
    • Deleting an attached file from an outgoing message
    • Issues when sending file attachments
    • Setting message importance (message priority)
    • Setting message sensitivity
    • Saving a draft copy of an e-mail
  2. Receiving, reading and replying to messages
    • The Inbox folder
    • Opening the Inbox folder
    • The Inbox screen
    • Selecting a message
    • Message Status icons
    • Reading a message
    • Switching between messages
    • Forwarding a message
    • Opening or saving an attached file
    • Replying to the sender of a message
    • Replying to the sender and all recipients of a message
    • Setting message reply options so that the original message isinserted, or not
    • Printing a message
    • Previewing a message before printing
    • Printing Options
  3. Organising Mail
    • Searching for a message
    • Searching for messages by sender, subject or content
    • Creating a new mail folder
    • Moving a message to a different folder
    • Deleting a mail folder
    • Sorting the contents of the Inbox
    • Deleting a message
    • Opening the 'Deleted Items' folder
    • Restoring a message from the 'Deleted Items' folder
    • Emptying the 'Deleted Items' folder
    • Automatically emptying the 'Deleted Items' folder when you exitOutlook
    • Flagging a message
    • Removing a flag mark from a mail message
    • Marking a message as unread
    • Marking a message as read
  4. Customising Outlook
    • Displaying or hiding the ribbon
    • Adding an Inbox heading
    • Removing an Inbox heading
    • Resetting the Inbox headings
  5. Contacts
    • Create a contact
    • Create a contact based on an existing contact
    • Create a contact based upon the sender of an e-mail message that you receive
    • Create a contact from an Electronic Business Card
    • Create and edit a Contact Group
    • Create a Contact Group
  6. Tasks
    • Create a task
    • Create a task from an Outlook item
    • Create a task in the To-Do Bar
    • Create a task in the Daily Task List in Calendar
    • Create and track assigned tasks
    • Assign a task to someone
    • Forward a task to someone else to track
    • Reclaim a declined task assignment
    • Track tasks that you have assigned
    • Accept or decline a task assignment
    • Send a status report or a comment about a task assignment
  7. Calendars
    • Schedule an appointment
    • Change an appointment
    • Make an existing appointment recurring
    • Schedule a meeting with other people
    • Change an appointment, event, or meeting
    • Respond to an e-mail message with a meeting request
    • Propose, accept, or decline a new meeting time
    • Cancel a meeting
    • View calendars side-by-side or overlaid
    • Introduction to calendar sharing
    • Manage another person's mail and calendar items
  8. Personal Folders
    • Introduction to Outlook Data Files (.pst and .ost)
    • Create an Outlook Data File (.pst)
    • Open an Outlook Data File (.pst)
    • Close an Outlook Data File (.pst)
  9. Delegation
    • About Delegate Access
    • Turn on Delegate Access
    • Change permissions for your delegate
    • Change delegate access to private items

Duration: One day


Microsoft PowerPoint 2010 - Introduction (CSC508)

Course Outline:

  1. Using PowerPoint 2010
    • Opening PowerPoint 2010
    • Opening a presentation
    • Navigating between slides
    • Using the Zoom tool
    • Changing PowerPoint views
    • Using Help
    • Searching for Help
    • Using the Help Table of Contents
    • Saving a presentation
    • Closing a presentation
    • Closing PowerPoint
    • Opening multiple presentations
    • Switching between multiple presentations
  2. Creating a Presentation
    • Creating a new presentation
    • Inserting a new slide
    • Recommended techniques when creating slide content
    • Undo and Redo
    • Saving a presentation
    • Saving a presentation using a different name
  3. Manipulating Slides
    • Inserting slides with a particular slide layout
    • Modifying the slide layout
    • Changing the background colour on the active slide
    • Changing background colour on all the slides within apresentation
  4. Themes
    • Applying a theme to a presentation
    • Modifying the theme colours
    • Modifying the theme fonts
  5. Font Formatting
    • Font formatting options
    • Changing the font type
    • Changing font size
    • Increasing or decreasing the font size
    • Bold, Italic or Underline formatting
    • Strikethrough effects
    • Shadow effects
    • Character spacing
    • Changing case
    • Font colour
    • Clearing all text formatting
  6. Paragraph Formatting
    • Text alignment
    • Columns
    • Modifying bullet point formatting
    • Using numbering instead of bullet points
    • Changing the list level
    • Indenting bulleted text
    • Line spacing vs. paragraph spacing
    • Line spacing
    • Paragraph spacing
    • Using Outline view
    • PowerPoint Presenter Notes
    • Text direction
    • Text alignment within a Text Box (placeholder)
    • Text AutoFit
    • Using the Format Painter
  7. Tables
    • Table selection techniques
    • Column selection
    • Row selection
    • Entire table selection
    • Creating a table
    • Applying a style to a table
    • Cell background shading
    • Applying table effects
    • Adding 'Quick Styles' to selected text
    • Applying borders to cells
    • Deleting rows or columns
    • Inserting rows or columns
    • Modifying column width and row height
    • Distributing rows and columns
  8. Graphics
    • Selecting an illustration
    • Moving an illustration
    • Copying an illustration
    • Deleting an illustration
    • Resizing an illustration
    • Stretching an illustration
    • Copying illustrations between presentations
    • Moving illustrations between presentations
    • Inserting Illustrations within PowerPoint
    • Inserting pictures
    • Inserting Clip Art
    • Inserting Shapes
    • Inserting text into a shape
    • Inserting perfect circles or perfect squares
    • Inserting a line
    • Inserting a free drawn line
    • Inserting an arrow
    • Inserting a text box
    • Inserting SmartArt
  9. Manipulating Graphics
    • Formatting the shape background fill colour style
    • Formatting the shape line weight and style
    • Formatting the shape line colour
    • Applying a shadow to an illustration
    • Modifying arrow line shapes and size
    • Rotating or flipping an illustration
    • Rotating illustrations by dragging with the mouse
    • Layering illustrations to the front or back
    • Aligning graphics relative to each other or relative to theslide
    • Aligning shapes
    • Grouping and ungrouping objects
  10. Charts
    • Inserting Charts
    • Changing the chart type
    • Changing the background colour in the chart
    • Changing the column, bar, line or pie slice colours in the chart
    • Chart Title Manipulation
    • Adding data labels to a chart
  11. Slide Masters
    • What is a slide master?
    • Inserting a picture (clipart) into a master slide
    • Inserting an image (from a file) into a master slide
    • Inserting a shape into a master slide
    • Removing a graphic from a master slide
    • Creating a footer
    • Automatic slide numbering
    • Inserting dates into the footer
  12. Slide Shows
    • Running a slide show
    • Adding Slide show transition effects
    • Removing transition effects
    • Adding slide show animation effects
    • Modifying slide show animation effects
    • Removing animation effects
    • Hiding slides
    • Displaying hidden slides within a slide show

Duration: One day


Microsoft PowerPoint 2010 - Advanced (CSC509)

Date: 12 Jun 2014 (Thu)
Time: 9:30 a.m. - 17:15 p.m
Venue: AC2-4200

Course Outline:

  1. PowerPoint 2010 Sections
    • Creating & Remaining Sections
    • Collapsing & Expanding Sections
    • Reordering Sections
    • Removing Sections and slides
    • Removing Sections
  2. Slide Masters
    • Inserting slide masters
    • Editing a customised slide master
    • Using customised slide masters
  3. Themes
    • Applying Themes
    • Modifying a Theme and saving it as a new Theme
    • Setting a Theme as the default theme
    • Deleting a Theme
    • Creating and saving a new template
    • Modifying a template
  4. Formatting Pictures & Images
    • Removing a picture background
    • Colouring Pictures
    • Artistic Effects
    • Picture Styles
    • Picture brightness and contrast
    • Using the Corrections button
    • Compressing pictures
    • Resetting a picture
    • SmartArt & Pictures
  5. Diagrams
    • Creating and formatting an organisation chart
    • Creating a cycle diagram
    • Creating a pyramid diagram
    • Creating a flowchart using 'Shapes'
    • Editing Flowchart shapes and connectors
  6. Video and Audio
    • Using Video
    • Changing the brightness and contrast of a video
    • Recoloring a video
    • Adding a poster frame image to a video
    • Resetting a video
    • Applying a video style
    • Playing a video in a shape
    • Changing the colour and weight of a video border
    • Applying special effects to a video
    • Trimming video
    • Video Looping
    • Using Audio
  7. Animation
    • Applying animation effects
    • Animation triggers
    • Using the Animation Painter
    • Creating custom animation effects
    • Modifying custom animation settings
    • Changing the custom animation sequence
    • Using custom animation to fade bulleted paragraphs
    • Animating chart columns by series
    • Animating the chart grid and legend
  8. Linking and Embedding
    • Action buttons - Linking to a different slide
    • Action buttons - Linking to a specific slide
    • Action buttons - Linking to a URL
    • Action buttons - Linking to Custom Shows
    • Action buttons - Linking to a different file
    • Linking data into a slide and displaying as an icon object
    • Linking and updating objects
    • Breaking a link
    • Inserting a link to a graphics file
    • Embedding data into a slide and displaying it as an object
    • Editing or deleting embedded data
  9. Merging, Comparing & Exporting
    • Merging all the slides from one presentation into anotherpresentation
    • Merging a Microsoft Word outline into a presentation
    • Comparing presentations
    • Saving a slide as a separate graphics file
    • Using the Screen Shot feature
  10. Slide Shows
    • Creating custom slide shows
    • Editing a custom slide show
    • Copying and deleting custom slide shows
    • Slide show transitions and timings
    • Controlling slide show looping
    • Applying settings so that slides advance manually
    • Setting slide show timings
    • Enabling or disabling slide show animations
    • Controlling a slide show
  11. Sharing Presentations
    • Marking as Final
    • Permissions - Encrypting with a password
    • Converting a presentation to a video
    • Packing for a CD
    • Saving as a PDF format
  12. Presentation Design & Compatibility Issues
    • Planning your presentation
    • Turn off your computer screen saver
    • Issues relating to presentation timing
    • Using graphics, diagrams and charts to convey ideas
    • Limiting the level of detail within a presentation
    • Using a consistent design scheme and adequate colour contrast
    • Accessibility considerations when designing a presentation
    • Using Alt (Alternative) Text tags
    • The Accessibility Checker
    • The Document Inspector
    • The Compatibility Checker

Duration: One day


What's New in Microsoft Office 2010 (CSC510)

Date: 28 Feb 2013 (Thu)
Time: 14:15 p.m. - 17:15 p.m
Venue: AC2-4101
Date: 23 May 2013 (Thu)
Time: 14:15 p.m. - 17:15 p.m
Venue: AC2-4101

Course Outline:

  1. Common New Features for MS Office 2010
    • Understanding File Extensions and Formats
    • The Ribbon
    • Using Tabsand Groups
    • Dialogue BoxLauncher
    • ContextualTabs
    • PreparingDocuments
    • Quick AccessToolbar
    • UsingGalleries
    • Views andZoom
    • Live Preview
    • SmartGraphics
    • Themes
  2. Word 2010
    • New Microsoft Office Backstage™ view
    • Improved search and navigation experience
    • Co-Authoring
    • Microsoft Word Web App
    • Microsoft Word Mobile 2010
    • Enhancedvisual effects to your text
    • Enhanced SmartArt Graphics
    • New picture-editing tools
    • Draft Recovery
    • Translation and text-to-speech playback
    • Insert screenshots and handwriting into your documents
    • Applying quick styles
    • Choosing a Document Theme
    • Mail Merge Improvements
  3. Excel 2010
    • Conditional Formatting and Data visualizations
    • Sparkline - Create data charts in a single cell
    • Slicer feature in Pivot Tables
    • ThePowerPivot for Excel add-in
    • Microsoft Excel Web App
    • Microsoft Excel Mobile 2010
    • Co-authoring
    • More interactive and dynamic PivotCharts
    • Choosing themes and setting cell styles
    • Click-and-type Headers and Footers
  4. PowerPoint 2010
    • New Design Theme choices and tools
    • Applying sophisticated photo effects directly in PowerPoint
    • Co-authoring
    • Add a personalized video experience
    • Instantly broadcast
    • Microsoft PowerPoint Web App
    • Microsoft PowerPoint Mobile 2010
    • Stunninggraphics
    • New transitions and improved animations
    • Work on multiple presentations and multiple monitors

Duration: 3 hours


What's New in Microsoft Office 2013 (CSC610)

Date: 10 Jul 2014 (Thu)
Time: 14:15 p.m. - 17:15 p.m
Venue: AC2-4200

Course Outline:

  1. Common New Features for MS Office 2013
    • Understanding File Extensions and Formats
    • The Ribbon
    • Using Tabs and Groups
    • Dialog Box Launcher
    • Contextual Tabs
    • Preparing Documents
    • Quick Access Toolbar
    • Using Galleries
    • Views and Zoom
    • Live Preview
    • Smart Graphics
    • Themes
  2. What’s New in Office 2013
    • Sign-in for Office where you need it
    • Office for the whole family
    • Save and share files in the cloud
    • Shared meetings
    • More choices for getting started
    • Improved Save As and Open
    • Easier file sharing
  3. What’s New in Word 2013
    • New Read Mode
    • Object Zoom
    • Resume Reading
    • Online Video
    • Collapse or expand
    • Work Together
    • Add polish and style
    • Open and edit PDFs
    • Insert online pictures and video
    • Live layout and alignment guides
  4. What’s New in Excel 2013
    • Get started quickly
    • Instant data analysis
    • Fill out an entire column of data in a flash
    • Create the right chart for your data
    • Filter table data by using slicers
    • One workbook, one window
    • New Excel functions
    • Save and share files online
    • Get started quickly
    • New charting features
    • Powerful data analysis
    • New and Improved Add-ins
  5. What’s New in PowerPoint 2013
    • More choices for getting started
    • Hassle-free Presenter View
    • Widescreen friendly
    • Start an online meeting from PowerPoint
    • Better design tools
    • Line-up and space objects equally
    • Motion path improvements
    • Merge common shapes
    • Improved video and audio support
    • New eyedropper for color matching
    • PowerPoint on touch devices
    • Share and save
    • Comments
    • Work together on the same presentation
  6. What’s New in Outlook 2013
    • Communicate
    • Manage
    • Find

Duration: 3 hours


Social Networks and Mobile Security (CSC513)

Date: 10 Jul 2014 (Thu)
Time: 9:30a.m. - 12:30p.m
Venue: AC2-4200

Course Outline:

  1. Mobile and Network Security Fundamental
    • What is Mobile and Network Security?
    • Why Ineed to know about it?
    • Common security myths
  2. Understanding Mobile Network
    • What is Mobile Network?
    • Security Risk of Mobile Device
    • Potential Risk of Mobile Network
  3. Secure your Mobile Network
    • Secured Set Identifier
    • Setup a safe Wi-Fi or peer network
    • Relation between network speed and network security
    • Security concerns of Free public network
    • Make yourself invisible to peers
  4. Understanding Social Network
    • What is Social Network(Facebook / Twitter / Weibo)?
    • Security Risk of Social Network
    • Potential Risk of Social Network
  5. Secure your Social Network
    • Security settings of different social network
    • Privacy settings of different social network
    • Always verify your "Friends?, "Followers", and "Fans"
    • Threats from your "LIKE"
    • The "LIKE" Virus
  6. Securing your Mobile Device
    • Setup a secured password
    • Sync your data to network Cloud services
    • Trusted applications publisher
    • Potential dangers of customizing device OS / ROM
    • Do I need an anti-virus on my mobile device?
  7. Internet Traps
    • Phishing Websites
    • Privacy Control of your web browsers
    • What you clicked is not always where you will go
    • Handling with Junk Mail
    • The threats of "unsubscribing"
    • Understanding Internet Zombie Network

Duration: 3 hours


Effective Use of Android Mobile & Tablet (CSC516)

Date: 31 Jul 2014 (Thu)
Time: 9:30 a.m. - 12:30 p.m.
Venue: AC2-1400 (DEC Lab)

Course Outline:

  1. Introduction to Android Operating System
    • Features in Android
    • Difference between Android 2.x / 3.x / 4.0
  2. Android Operating System Settings
    • User Preference in Android Device
    • Using Android Desktop
    • Customize your Android Device
  3. Android Software Management
    • Install Application
    • Install Application from Google Play Store
    • Install Application from other Markets
    • Software Management in Android
  4. Using Android
    • Mail and Calendar
    • Contacts
    • Input Methods
    • Data synchronization and Document Exchange
    • Google Map in Android
    • Web Browsing in Android
    • Multimedia in Android
  5. CityU Applications
    • Connecting to CityU Wireless Local Area Network
    • Accessing JSMS email via Android tablet built-in email client
    • City University Official Apps Web Site
    • Blackboard Mobile Learn
    • CityU GE
    • CityU Mobile CAP
    • CityU Mobile News
    • CityU Alumni Apps
    • CityU Campus VR
    • What To Do If You Lose Your Tablet

Duration: 3 hours
(Note: Samsung Galaxy Android tablets will be provided in class.)


Effective Use of iPhone & iPad (CSC517)

Date: 22 May 2013 (Thu)
Time: 2:15 p.m. - 5:15 p.m
Venue: AC2-4200

Course Outline:

  1. What is iPhone and iPad
  2. iPhone and iPad Basic Operation
  3. What is iOS?
  4. What is iTunes?
  5. Purchase Apps from App Store
  6. Backup and Sync
  7. Upgrade iOS firmware
  8. What is iCloud?
  9. Using Find My iPhone / iPad
  10. What’s new in iOS5?
    • Notification Area
    • Newsstand Subscription
    • Reminder
    • New features in Camera
    • Wifi Sync
  11. What’s new in iOS5 in iPad?
  12. iPhone / iPad Tips and Tricks
    • Multi-tasking gesture
    • Enhanced Safari
    • Detached keyboard

Duration: 3 hours
(Note: Participants are expected to bring their own iPhones / iPads to the class.)


iPad Application Development (CSC518)

Course Outline:

  1. Module 1: iPad series: a Unique Gadget
    • Setting up the Development Environment
    • Creating your first project in Xcode
    • APP1 – Restaurant Ad
  2. Module 2: Building Your First iPad App
    • Understanding the iPad Platform and SDK
    • Programming for iPad is Different from iPhone
    • Controllers and Event Handling
    • Page-flipping Animation (Magazine like)
    • APP2 – Magazine Viewer
    • Recognizing Finger Gestures
  3. Module 3: Adding More Features
    • iPad Application Architecture and Design
    • How to Play Videos
    • APP3 – Wedding Video Player
    • Using Map View
    • Utilizing Core Location
    • APP4 – Office Locations
    • The Universal Application Type
  4. Module 4: iPad-specific Features and Web Services
    • iPad-Specific Design Considerations
    • UI Design for the Larger 9.7” Screen
    • Developing for all orientations
    • APP5 – Turning Around
    • iPad-Specific UI Controls: Popover and Split View
    • Building a Web Service App using Split View
    • Testing and Debugging
    • APP6 – Web Service App

Duration: 2 days / 12 hours

Pre-requisite(s):  Participants should have knowledge of Programming


Android Tablet Application Development (CSC519)

Course Outline:

  1. Module 1
    • What is Android?
    • Android Framework Fundamentals
    • Android SDK Development Environment
  2. Module 2
    • Android Applications Basic Elements
    • Set up and Design Android UI
    • Creating Your First Android Application
  3. Module 3
    • Accessing Google Maps 
    • Integrating Google Maps to Application
    • Showing Google Maps in Specific Location
    • Adding Landmark Icon in Google Maps
    • Using GPS with Google Maps
  4. Module 4
    • Debugging Application
    • Outputting Android .apk Installation File
    • Uploading .apk File to Android Market
    • Using Sata Storage on Android

Duration: 2 days / 12 hours

Pre-requisite(s): 
Participants should have knowledge of Programming


How to Prepare an On-line Questionnaire (CSC520)

This course is intended for delegates wishing to be introduced to InfoPath 2010 so that they can create forms from templates and customize them, generate forms from scratch and also from data sources. Publish forms to SharePoint with or without form services, run the design compatibility checker, learn how to apply conditional formatting, calculations and formulas to your forms. Explore the new InfoPath 2010 features.

Upon completion of this course, participant will be able to:

  • Create forms by using InfoPath
  • Know how to apply conditional formatting, calculations and formulas to your forms
  • Publish form to SharePoint with or without form service

Course Outline:

  1. An overview of InfoPath
    • Why use InfoPath to create forms
    • Filling out and Emailing a Forms
    • Merging forms with Microsoft Excel
    • Use Outlook to receive and fill out forms
    • Fill out forms using a browser and form services
    • Summary Forms
    • Exporting Forms as PDFs
  2. Creating Form
    • Customize Templates
    • Create forms from Scratch
    • Create forms based on a backend database, XML File, XSD File, or Web Service
  3. Building a Form
    • Data Source creation
    • Controls
    • Views
    • Reusable Template Parts
    • Design Checker
  4. Add rules to your Forms
    • Is Blank
    • Is Equal To
    • Contains
    • This Field Changes 
  5. Calculations and Actions
    • Calculating Fields in InfoPath
    • Actions on Controls
    • Conditional Formatting
    • An overview of Formulas
  6. Workflows
    • Building Workflows in InfoPath
    • Using SharePoint workflows in InfoPath
    • MOSS Approval Workflow
  7. An overview of the Form Library
    • Templates
    • Checking In/Out forms
    • Meta data
    • Versioning
    • Approval

Duration: 1 day / 6 hours

Pre-requisite(s): 
Participants should have basic knowledge of PC.


Microsoft Word 2013 - Introduction (CSC521)

Date: 2014 (Thu)
Time: 9:30 a.m. - 5:15 p.m
Venue: AC2-

Course Outline:

  1. Getting Started with Excel
    • Viewing the Word Window
    • Working with the Ribbon and Toolbars
    • Choosing Dialog Box Options
    • Layout Options
    • Closing a document window
  2. Creating a New Document
    • Creating a Blank Document
    • Creating a new document using a template
  3. Managing Document
    • Opening an Existing Document
    • Reading documents in Word
    • Saving a Document
    • Saving a document in another file format
    • Saving Word 2013 document for compatibility with earlier versions of Word
    • Converting a document to PDF
    • Opening and Editing PDF content in Word
    • Recovering unsaved document
  4. Creating Content
    • Inserting Content Using Quick Parts
    • Inserting text automatically
    • Inserting a Cover Page
    • Inserting symbol
  5. Selecting Techniques
    • Moving Around the document
    • Selecting Text
    • Copying and moving items
    • Using the Office Clipboard
    • Undo, redo, or repeat an action
  6. Finding and Replacing
    • Finding text or other document content
    • Replacing text
  7. Formatting Text
    • Applying Character Formatting
    • Creating a large dropped initial capital letter
    • OpenType options in the Font dialog box
    • Copy formatting using the Format Painter
  8. Formatting Paragraph
    • Align text left or right, center text, or justify text on a page
    • Creating a first line indent
    • Creating a hanging indent
    • Change the line spacing
    • Showing tab stops
    • Aligning Text Using Tabs
    • Clearing tabs
    • Creating and changing a bulleted or numbered list
  9. Style basics in Word
    • Styles save time and make your document look good
    • Using styles
    • Built-in styles turn on timesaving features
    • Changing a style in a Quick Style set
  10. Controlling Page Appearance
    • Inserting Page Break
    • Removing Page Break
    • Inserting Section Break
    • Inserting & deleting Page Numbers
    • Creating & deleting Header/Footer
    • Inserting, changing or Removing Watermark
  11. Document Page Setup
    • Setting page margins
    • Changing the orientation of your entire document
    • Changing the paper size of your entire document
  12. Tables
    • Inserting a Table
    • Designing a Table
    • Formatting a Table
    • Deleting a Table
    • Converting text to a table or a table to text
  13. Working with Graphics
    • Inserting Pictures
    • Working with pictures
    • Inserting a screenshot or screen clipping
    • Inserting online Video
    • Inserting clipart
    • Drawing shape
  14. Proofing a Document
    • Changing the language of a document
    • Checking Spelling and Grammar
    • Recheck the words and grammar that you previously checked and chose to ignore
    • Translating text in a different language
  15. Printing and previewing a Document
  16. Differences between Word 2010 and 2013
    • New Read Mode
    • Object Zoom
    • Resume Reading
    • Collapse or expand
    • Add polish and style
    • Open and edit PDFs
    • Insert online pictures and video
    • Live layout and alignment guides

Duration: One day / 6 hours


Microsoft Word 2013 - Advanced (CSC522)

Date:
Time: 9:30 a.m. - 5:15 p.m
Venue: AC2-

Course Outline:

  1. Managing Lists
    • Creating multi-level list
  2. Styles
    • Using Styles
    • Character and paragraph styles
    • Creating a new Style
    • Changing a style in a Style set
  3. Header/Footer
    • Adding section breaks
    • Adding a header or footer
    • Adding different page numbers or number formats to different sections
    • Adding page number X of Y to a document
    • Deleting page numbers
  4. Working with Charts
    • Creating an Excel chart in Word
    • Editing and customizing your chart
    • Inserting a chart from an Excel spreadsheet into Word
    • Edit a chart in Word
    • More ways to insert Excel charts
  5. Using Mail Merge
    • Mail merge using an Excel spreadsheet
    • Mail merge with dates, currencies, and other numbers
  6. Collaborating on Documents
    • Tracking Changes
    • Changing options for Track Changes
    • Advanced Track Changes Options
    • Accepting or rejecting tracked changes
    • Comparing documents with the legal blackline option
    • Merging comments and changes from several documents into 1 document
    • Inserting or deleting a comment
    • Replying to comments in a document
    • Marking comments as done
  7. Using Reference
    • Table of Contents
    • Footnotes/Endnotes
    • Caption and Table of Figures
    • Indexing
    • Cross reference
  8. Creating a Master Document
    • About master documents
    • Decide on a location for your documents
    • Creating the master document
    • Add subdocuments to the master document
    • Saving the master document
    • Opening Master documents
  9. Securing a Document
    • Password protect a document
    • Changing the password of a document
    • Remove a password from a document
    • Restrict formatting and editing
  10. Using Macros
    • Creating and running a macro
    • Deleting a macro
  11. Differences between Word 2010 and 2013
    • New Read Mode
    • Object Zoom
    • Resume Reading
    • Collapse or expand
    • Add polish and style
    • Open and edit PDFs
    • Insert online pictures and video
    • Live layout

Duration: One day / 6 hours


Microsoft Excel 2013 - Introduction (CSC523)

Date:
Time: 9:30 a.m. - 5:15 p.m
Venue: AC2-

Course Outline:

  1. Getting Started with Excel
    • Viewing the Excel Window
    • Working with the Ribbon and Toolbars
    • Choosing Dialog Box Options
    • Creating a Blank Workbook
    • Opening an Existing Workbook
    • Moving Around the Workbook
    • Viewing two or more worksheets or workbooks at the same time
    • Saving a Workbook
    • Saving a workbook in another file format
    • Save an Excel 2013 workbook for compatibility with earlier versions of Excel
    • Recovering unsaved a Workbook
    • Closing workbooks or workbook windows
  2. Basic Workbook Skills
    • Select specific cells or ranges
    • Selecting Rows, Columns, and Special Ranges
    • Enter data manually in worksheet cells
    • Fill data automatically in worksheet cells
    • Using Flash Fill
    • Split a column of data based on what you type
    • Editing Cell Contents
    • Understanding How Excel Copy and Pastes Data
    • Finding and Replacing
    • Checking Spelling
    • Adding word to your dictionary
    • Undoing and Redoing an Action
  3. Modifying Worksheets and Workbooks
    • Inserting and Deleting a Worksheet
    • Moving and Copying a Worksheet
    • Hiding and Unhiding Worksheets and Workbooks
    • Hiding and Unhiding a Column or Row
    • Inserting and deleting a Column or Row
    • Adjusting Column Width and Row Height
    • Freezing and Unfreezing a Columns or Rows
    • Zooming the View In and Out
  4. Font Formatting
    • Format text in cells
    • Change font style, size, or color
    • More font formatting in font dialog box launcher
    • Clear formatting
  5. Alignment Formatting
    • Align text in a cell
    • Undo alignment changes
  6. Numbers Formatting
    • Format numbers as currency
    • Format a date the way you want
    • Display numbers as percentages
    • Creating or deleting a custom number format
  7. Formatting a Worksheet
    • Applying a cell Styles
    • Copy formatting using the Format Painter
  8. Creating charts from start to finish
    • Create your chart
    • Available chart types
    • Creating a chart
    • Fine-tune your chart
    • Change the data in your chart
    • Save a custom chart as a template
  9. Analysing trends in data using sparklines
    • Analyse trends in data using sparklines
    • Customize your sparklines
  10. Sorting data in a worksheet
    • Select the data that you want to sort
    • Sort quickly
    • Sort by specifying criteria
    • Sorting data by icon set
  11. Use AutoFilter to filter your data
    • Filter a range of data
    • Remove a filter
    • Filtering data by icon set
  12. Understanding Tables
    • Overview of Excel tables
    • Learn about the elements of an Excel table
    • Creating a table in a worksheet
    • Table features that you can use to manage table data
    • Deleting a table without losing the data or table formatting
  13. Working with Formulas and Functions
    • About formulas
    • Using calculation operators in formulas
    • Using functions and nested functions in formulas
    • The syntax of functions
    • Entering functions
    • Using references in formulas
    • The difference between absolute, relative and mixed references
    • Use Formula AutoComplete
    • Excel functions
  14. Define and use names in formulas
    • Defining a name for a cell or cell range on a worksheet
    • Manage names by using the Name Manager dialog box
    • Change a name
    • Delete one or more names
    • Defining and using names
    • Learn about syntax rules for names
    • Use AutoSum to sum numbers
    • Use AutoSum to quickly find the average
    • Calculating Totals with Quick Analysis
    • Copy cell values, not formulas
    • Use error checking to detect errors in formulas
  15. Viewing and Printing Worksheets and Workbooks
    • Previewing a Worksheet
    • Fine-tuning pages before printing
    • Change Margins
    • Change Page Orientation
    • Change Paper Size
    • Set a print area
    • Create manual page breaks in a worksheet
    • Add or remove a sheet background
    • Setting Print Titles
    • Making a worksheet fit the printed page
    • Printing row and column headings
    • Adding Headers and Footers
    • Removing header and footers
    • Printing a Worksheet and Workbook
  16. Differences between Excel 2010 and 2013
    • Get started quickly
    • Instant data analysis
    • Fill out an entire column of data in a flash
    • Create the right chart for your data
    • Filter table data by using slicers
    • One workbook, one window
    • New charting features
    • Powerful data analysis
    • Get started quickly

Duration: One day / 6 hours


Microsoft Excel 2013 - Advanced (CSC524)

Date:
Time: 9:30 a.m. - 5:15 p.m
Venue: AC2-

Course Outline:

  1. Applying Conditional Formatting
    • Adding, changing, conditional formats
    • Clearing conditional formats
    • Apply conditional formatting to quickly analyze data
  2. Inserting subtotals in a list of data in a worksheet
    • Inserting subtotals
    • Removing subtotals
  3. Filter by using advanced criteria
    • Advanced Filter
    • Comparison operators
    • Advanced Filter - Criteria Examples
  4. Using PivotTables / PivotChart to analyze & present your data
    • Creating a PivotTable or PivotChart
    • Changing the format of your PivotTable report
    • Showing PivotTable details
    • Calculating PivotTable values
    • Changing or updating PivotTable data
  5. Creating a formula by using a function
    • About the syntax of functions
    • Creating a formula by using a function
    • Logical function
    • Lookup function
    • Database functions
  6. Importing Data
    • Importing a text file
    • Connecting external data to your workbook – From Web
  7. Data Validation
    • Overview of data validation
    • Adding data validation to a cell or range
    • Display an optional input message
    • Specify an optional alert or error message when invalid data is entered.
  8. Using a shared workbook to collaborate
    • Sharing a workbook
    • Stop sharing a workbook
    • Track changes in a shared workbook
  9. Password protect worksheet or workbook elements
    • Protecting your with passwords, permission, and other restrictions
    • Protecting worksheet elements
    • Removing protection from a workbook/ worksheet
  10. Macro
    • Recording a macro
    • Running a macro
    • Adding a macro button to the Quick Access Toolbar
    • Delete macro
  11. Differences between Excel 2010 and 2013
    • Get started quickly
    • Instant data analysis
    • Fill out an entire column of data in a flash
    • Create the right chart for your data
    • Filter table data by using slicers
    • One workbook, one window
    • New charting features
    • Powerful data analysis
    • Get started quickly

Duration: One day / 6 hours


Microsoft PowerPoint 2013 - Introduction (CSC525)

Date:
Time: 9:30 a.m. - 5:15 p.m
Venue: AC2-

Course Outline:

  1. Creating a basic PowerPoint presentation
    • Choosing the right view for the task in PowerPoint 2013
    • Views for creating your presentation
    • Views for delivering and viewing a presentation
    • Creating a PowerPoint 2013 presentation
    • Adding text to placeholder
    • Adding, rearranging, and deleting slides
    • Saving your presentation file
    • Saving as PDF format
    • Recovering unsaved presentation
  2. Understanding Slide Layout
    • What is slide layout?
    • Applying a layout to a slide
    • Changing the size of your slides
  3. Understanding Theme
    • Overview of Office themes
    • Adding color and design to my slides
    • Creating your own theme in PowerPoint
  4. Working with text
    • Managing text in a placeholder by using AutoFit
    • Splitting body text between two slides
    • Formatting Font
    • Formatting Paragraph
    • Splitting your text into Columns
    • Using Bullet and number list
    • Inserting WordArt
    • Copying and pasting your slides
    • Copying format using the Format Painter
    • Clear all text formatting
    • Checking Spelling
    • Finding and replacing text
  5. Working with Tables
    • Adding a table to a slide
    • Changing the look of a table
    • Formatting a Table
  6. Working with Shapes
    • Adding shapes
    • Selecting a shape or other object
    • Adding a shape fill or effect
    • Moving a text box, WordArt, or shape
    • Grouping or ungrouping shapes, pictures, or other objects
    • Changing the size of a picture, shape, WordArt, or other object
    • Rotating a text box, shape, WordArt, or picture
  7. Working with Graphics
    • Inserting Pictures
    • Working with pictures
    • Inserting a screenshot or screen clipping
    • Inserting clipart
  8. Slide Transitions
    • Adding a transition to a slide
    • Removing a transition
  9. Applying an Animation Effect
    • Applying an animation effect to text or objects
    • More about animating text and objects in PowerPoint 2013
    • Animating text bullets
    • Animating a picture on your slide
    • Removing an Animation Effect
  10. Presenting a Slide Show
    • Using keyboard shortcuts to deliver your presentation
    • Starting a slide show presentation
  11. Printing Presentation Slides
    • Printing your handouts, notes, or slides
    • Showing footer information on your slides
    • Changing the starting slide number
  12. Differences between PowerPoint 2010 and 2013
    • More choices for getting started
    • Hassle-free Presenter View
    • Better design tools
    • Line-up and space objects equally
    • Motion path improvements
    • Merge common shapes
    • Improved video and audio support
    • New eyedropper for color matching

Duration: One day / 6 hours


Microsoft PowerPoint 2013 - Advanced (CSC526)

Date:
Time: 9:30 a.m. - 5:15 p.m
Venue: AC2-

Course Outline:

  1. Using Sections
    • Using sections to organize your slides into groups
    • Adding a section
    • Renaming a section
    • Viewing all sections in a presentation
    • Moving a section up or down in a list of slides
    • Removing a section
  2. Using Slide Master?
    • What is a slide master?
    • Using multiple slide masters in one presentation
  3. Working with Charts
    • Adding a chart to a presentation
    • Creating a chart in Excel 2013
    • Fine-tune your chart
    • Change the data in your chart
    • Save a custom chart as a template
    • Copying an Excel chart to another Office program
  4. Using SmartArt to create Organization Chart
    • What to consider when choosing a layout
    • Create an organization chart with pictures
    • Formatting an organization chart
    • Converting slide text to a SmartArt graphic
    • Changing the colors of an entire SmartArt graphic
    • Applying a style to your SmartArt graphic
  5. Working with Graphics
    • Working with pictures
    • Removing a picture background
    • Changing the brightness, contrast, or sharpness of a picture
    • Recoloring a picture or clip art
    • Applying an artistic effect
    • Cropping a picture or place it in a shape
    • Combining shapes to create a custom shape
    • Using eyedropper to match colors on your slide
    • Aligning or arranging an objects
    • Line-up and space objects equally
    • Compressing a picture
  6. Using Video and Audio
    • Video and audio file formats supported in PowerPoint
    • Adding audio to your slide show
    • Trimming a music or sound clip
    • Setting the playback options for an audio clip
    • Deleting a music clip or another sound
    • Inserting or linking to a video that is stored on my PC
    • Setting the 'Playback' options for a video in your presentation
    • Starting or ending your video with a fade effect
    • Trimming a video
  7. Slide Transitions
    • Adding a transition to a slide
    • Setting the speed and timing of transitions
    • Removing a transition
  8. Applying an Animation Effect
    • Applying an animation effect to text or objects
    • More about animating text and objects in PowerPoint 2013
    • Animating text bullets
    • Applying multiple animation effects to a single object
    • Viewing a list of animations currently on the slide
    • Setting the effect options, timing, or order for an animation
    • Animating a SmartArt graphic
    • Applying a motion path to text or an object
    • Copy animation
    • Removing an Animation Effect
  9. Presenting a Slide Show
    • Using keyboard shortcuts to deliver your presentation
    • Starting a slide show presentation
    • Viewing your speaker notes as you deliver your slide show
    • Create a basic custom show
    • Start a custom show from within PowerPoint
    • Creating a self-running presentation
    • Presenting online using the Office
    • Presentation Service
  10. Import and Export
    • Inserting outline text from Word to your PowerPoint presentation
    • Decreasing or increasing text indents in an outline
    • Writing and printing PowerPoint handouts in Word
    • Saving your presentation as a video
  11. Differences between PowerPoint 2010 and 2013
    • More choices for getting started
    • Hassle-free Presenter View
    • Better design tools
    • Line-up and space objects equally
    • Motion path improvements
    • Merge common shapes
    • Improved video and audio support
    • New eyedropper for color matching

Duration: One day / 6 hours


Microsoft Access 2013 - Introduction (CSC527)

Date:
Time: 9:30 a.m. - 5:15 p.m
Venue: AC2-

Course Outline:

  1. What’s new in Access 2013
    • Getting started with apps
    • Table templates
    • External data
    • Opening in a browser
    • Navigation included
    • The Action Bar
    • Views easier to modify
    • Callouts for
    • New controls for working with related data
    • New deployment options
    • Package and distribute apps
  2. Basic tasks for an Access 2013 desktop database
    • Choose a template
    • Create a database from scratch
    • Add a table
    • Copy and paste data
    • Import or link to data
    • Organize data with the Table Analyzer
  3. Introduction to tables
    • Overview
    • Table and field properties
    • Table relationships
    • Keys
    • Add or change a table’s primary key
    • What makes a good primary key?
    • Examples of poor primary keys
    • Change the primary key
    • Benefits of using relationships
    • Add a table to a desktop database
    • Set table properties in a desktop database
    • Add a field to a table in a desktop database
    • Add a field by entering data
    • Set a field's properties
    • Set field properties in Datasheet view
    • Change a field's data type
    • Change a field's format
    • Set other field properties
    • Set field properties
    • Prepare sample data to follow along with some examples
  4. Introduction to data types and field properties
    • Overview
    • Data types
    • Field properties
    • Supported field properties
    • Control data entry formats with input masks
    • About input masks
    • The three parts of an input mask
    • Characters that define input masks
    • Create an input mask
    • Add input masks by using the Input Mask Wizard
    • Customize input masks from the field property setting
    • Examples of input masks
    • Add a validation rule to a table field or record
    • Enter a validation rule
    • Enter a validation message
    • Create a lookup field in a desktop database
  5. Guide to table relationships
    • Introduction
    • Types of table relationships
    • Create a table relationship by using the Relationships window
    • Edit a relationship
    • Open the Edit Relationships dialog box
    • Set the cascade options
    • Turn cascade update and/or cascade delete on or off
    • Delete a table relationship
  6. Filter data in a desktop database
    • Filters support different data types
    • Different ways to filter
    • Common filters
    • Filter by selection
    • Filter by Form
    • Advanced Filter/Sort
    • Switch between Filtered and Unfiltered views of your data
    • Clear a filter
    • Save a filter and apply it automatically
    • Save a filter as a query
  7. Sort records on text, numeric, or date values
  8. Find and Replace records in Tables
    • Use wildcard characters in find and find-and-replace operations
  9. Create Access Queries
    • Introduction to queries
    • Add tables to a new query
    • Queries help you find and work with your data
    • Create a select query
    • Examples of query criteria
    • Examples of criteria for Text fields
    • Examples of criteria for Number and Currency fields
    • Examples of criteria for a Yes/No field
    • Examples that work with a date or range of dates other than the current date
    • Make calculations based on your data
    • Make summary data easier to read by using a crosstab query
    • Overview
    • Benefits of using the Crosstab Query Wizard
    • Create a crosstab query
    • Create a totals query
  10. Create an Access form
    • Create a form from an existing table or query
    • Create a blank form
    • Create a split form
    • Creating a continuous form with the multiple items template
    • Creating a single record form with the Form Wizard
    • Working with form views
    • Controlling editing and data entry in a form
    • Changing the data source for a form
    • Organizing your database with navigation forms
    • Adding fields to a form in design view
  11. Preparing data to print using reports
    • Creating a tabular report with multiple tables
    • Altering the presentation of controls on a page
    • Working with controls and sections
    • Using the Can Grow and Can Shrink Properties
    • Adding a running sum
    • Managing data and page breaks
    • Keep results together on the same page
    • Adding sorting and grouping on reports
    • Avoiding blank pages
    • Adding conditional formatting
    • Using labels and managing columns and rows
    • Working with layout view, report view, and Print Preview
    • Inserting and formatting the date & time
    • Adding existing fields to a report
  12. Differences between Access 2010 and 2013
    • New database templates
    • Navigation Pane
    • Tabbed objects

Duration: Two days / 12 hours


Microsoft Access 2013 - Advanced (CSC528)

Date:
Time: 9:30 a.m. - 5:15 p.m
Venue: AC2-

Course Outline:

  1. Working in Access more efficiently
    • Changing default program options
    • Identifying new features of Access 2013
    • Upgrading from Access 2010
    • Enabling macros and other active content
  2. Import and Export Data
    • Import data into an Access database
    • External data operations available in apps and desktop databases
    • Importing into an Access app
    • Importing into a desktop database
  3. What is the Relationships window?
    • Types of table relationships
    • Why create table relationships?
    • Understanding referential integrity
    • Set the join type
  4. Restrict data input by using a validation rule
    • Overview
    • Types of validation rules
    • Where you can use validation rules
    • What you can put in a validation rule
    • Add a validation rule to a table
  5. Create a select query
    • Review data from select fields
    • Examples of criteria for Text fields
    • Examples of criteria for Number and Currency fields
    • Examples of criteria for a Yes/No field
    • Examples of using dates as criteria in Access queries
    • Examples that use the current date in their criteria
    • Examples that work with a date or range of dates other than the current date
    • Queries that filter for null (missing) or non-null dates
  6. Create a totals query
  7. Use parameters to ask for input when running a query
    • Add a parameter to a union query
    • Combine parameters with wildcards for more flexibility
    • Return items that don’t match the parameter
    • Specify parameter data types
  8. Crosstab query techniques
    • Overview
    • Create a crosstab query manually in Design view
    • A series of tips for crosstab queries.
    • Display row totals
    • Display zeros (not blanks)
    • Handle parameters
    • Specify column headings
    • Multiple sets of values
  9. Updating records by using queries
    • Create a make table query
    • Create an append query
    • Create an update query
    • Create a delete query
  10. Use a union query to combine multiple queries into a single result
    • Tips for using union queries
  11. Create Custom Form
    • Modifying forms created by using a wizard
    • Create a Form using Form Wizard
    • Adding controls
    • Displaying subforms
  12. Create Custom Reports
    • Creating reports manually
    • Adding hyperlinks, charts, and buttons
    • Modifying report content
    • Layouts
    • Add Page Numbers
    • Adding Subreports
  13. Protect Databases
    • Assigning passwords to databases
    • Splitting databases
    • Securing databases for distribution
  14. Normalize your data using the Table Analyzer
  15. Create a macro that runs when you open a database
    • Create an AutoExec macro
  16. Differences between Access 2010 and 2013
    • New database templates
    • Navigation Pane
    • Tabbed objects

Duration: Two days / 12 hours


csc@cityu.edu.hk