IT Office Professional Package Jurong East, West

Course details

Course Outline

Computer Basics

This module is delivered through mix lectures, illustrations, demonstrations and hands-on. It covers:

• Computer Operations within Windows
• Introduction to Windows
• Working with Desktops, Taskbars & My Computer
• Managing Files, Folders & Object
• Working With Text in WordPad
• Working with Graphics in Paint

Internet

This module covers:

• History of Internet
• Internet Connection
• Retrieval of Information via the World Wide Web
• News Browsing on the Internet
• Email Features

Microsoft Excel 2010

• Introduction To Microsoft Excel
• Spreadsheets, Worksheets and Workbooks
• Parts of the Excel Screen
• Working with Worksheets
• Creating a Spreadsheets
• Editing and Formatting a Workbook
• Viewing the Worksheet
• Working with Ranges
• Editing data in Worksheets
• Using Styles
• Restructuring the Worksheet
• Sorting Data
• Adding Comments
• Adding Headers and Footers
• Printing from Excel
• Chart Terms and Basics
• Choosing the Right Type of Chart
• Creating a Chart
• Modifying a Chart
• What Are Formulas and Functions
• The parts of a Formula
• Creating a Formula
• Working with Functions
• Copying and Moving Formulas
• Recalculating Formulas
• Viewing Formulas in the Workbook

Microsoft Access 2010

• Introduction To Microsoft Access
• Getting started in Microsoft Access
• Components of a Database
• Navigating in Access
• Entering Data in a Database
• Exporting Information form a Database
• Saving Information in a Database
• Closing a Database and Exiting Access
• Building a Database using the Access Wizards
• Building a Database on your Own
• Working with Tables
• Working with Forms
• Creating Form with the Form Wizard
• Modifying a Form
• Working with Queries
• Creating a Query
• Modifying a Query
• Working with the Reports
• Creating a Report with Report Wizard
• Creating a Report with Auto-Report