• +60377730654


MS Office Full Course:with Access

Provide the knowledge in Ms word, Ms PowerPoint, Ms Excel and open the world of Internet and Emailing


MS Windows, Computer basics

♦ Computer Basic, Creating Folder
♦ Paint,Directories,
♦ input units, Output unit
♦ Central Processing Units
♦ Hardware & Software
♦ Windows short cut keys


Module1:Text Basics
♦ Typing the text, Alignment of text
♦ Editing Text: Cut, Copy, Paste, Select All, Clear
♦ Find & Replace
Module2: Text Formatting and Saving file
♦ New, Open, Close, Save, Save As
♦ Formatting Text: Font Size, Font Style
♦ Font Color, Use the Bold, Italic, and Underline
♦ Change the Text Case
♦ Line spacing, Paragraph spacing
♦ Shading text and paragraph
♦ working with Tabs and Intends
Module3: Working with Objects
♦ Shapes, Clipart and Picture, Word Art, Smart Art
♦ Columns and Orderings - To Add Columns to a Document
♦ Change the Order of Objects
♦ Page Number, Date & Time
♦ Inserting Text boxes
♦ Inserting Word art
♦ Inserting symbols
♦ Inserting Chart
Module 4: Header & Footers
♦ Inserting custom Header and Footer
♦ Inserting objects in the header and footer
♦ Add section break to a document
Module 5: Working with bullets and numbered lists
♦ Multilevel numbering and Bulleting
♦ Creating List
♦ Customizing List style
♦ Page bordering
♦ Page background
Module 6: Tables
♦ Working with Tables, Table Formatting
♦ Table Styles
♦ Alignment option
♦ Merge and split option
Module 7: Styles and Content
♦ Using Build- in Styles, Modifying Styles
♦ Creating Styles, Creating a list style
♦ Table of contents and references
♦ Adding internal references
♦ Adding a Footnote
♦ Adding Endnote
Module8:Merging Documents
♦ Typing new address list
♦ Importing address list from Excel file
♦ Write and insert field
♦ Merging with outlook contact
♦ Preview Result
♦ Merging to envelopes
♦ Merging to label
♦ Setting rules for merges
♦ Finish & Merge options
Module9: Sharing and Maintaining Document
♦ Changing Word Options
♦ Changing the Proofing Tools
♦ Managing Templates
♦ Restricting Document Access
♦ Using Protected View
♦ Working with Templates
♦ Managing Templates
♦ Understanding building blocks
Module10: Proofing the document
♦ Check Spelling As You Type.
♦ Mark Grammar Errors As You Type
♦ Setting AutoCorrect Options
Module 11: Printing
♦ Page Setup, Setting margins
♦ Print Preview, Print


Module12:Introduction to Excel
♦ Introduction to Excel interface
♦ Understanding rows and columns, Naming Cells
♦ Working with excel workbook and sheets
Module13: Formatting excel work book:
♦ New, Open, Close, Save, Save As
♦ Formatting Text: Font Size, Font Style
♦ Font Color, Use the Bold, Italic, and Underline
♦ Wrap text, Merge and Centre
♦ Currency, Accounting and other formats
♦ Modifying Columns, Rows, & Cells.
Module14: Perform Calculations with Functions
♦ Creating Simple Formulas
♦ Setting up your own formula
♦ Date and Time Functions, Financial Functions
♦ Logical Functions, Lookup and Reference
♦ Functions Mathematical Functions
♦ Statistical Functions, Text Functions.
Module15:Sort and Filter Data with Excel
♦ Sort and filtering data
♦ Using number filter, Text filter
♦ Custom filtering
♦ Removing filters from columns
♦ Conditional formatting
Module16:Create Effective Charts to
♦ Present Data Visually
♦ Inserting Column, Pie chart etc.
♦ Create an effective chart with Chart Tool
♦ Design, Format, and Layout options
♦ Adding chart title
♦ Changing layouts
♦ Chart styles
♦ Editing chart data range
♦ Editing data series
♦ Changing chart
Module17: Analyze Data Using PivotTables and Pivot Charts
♦ Understand PivotTables, Create a PivotTable .
♦ Framework Using the PivotTable and PivotChart
♦ Create Pivot Chart from pivot Table
♦ Inserting slicer
♦ Creating Calculated fields
Module 18: Protecting and Sharing the work book
♦ Protecting a workbook with a password
♦ Allow user to edit ranges
♦ Track changes
♦ Working with Comments
♦ Insert Excel Objects and Charts in Word Document and Power point Presentation
Module 19:Use Macros to Automate Tasks
♦ Creating and Recording Macros
♦ Assigning Macros to the work sheets
♦ Saving Macro enabled workbook.
Module 20:proofing and Printing
♦ Page setup, Setting print area, Print titles
♦ Inserting custom Header and Footer
♦ Inserting objects in the header and footer
♦ Page Setup, Setting margins, Print Preview, Print
♦ Enable back ground error checking
♦ Setting AutoCorrect Options


Module 21:Setting Up PowerPoint Environment
♦ New, Open, Close, Save, Save As
♦ Typing the text, Alignment of text
♦ Formatting Text: Font Size, Font Style
♦ Font Color, Use the Bold, Italic, and Underline
♦ Cut, Copy, Paste, Select All, Clear text
♦ Find & Replace
♦ working with Tabs and Intends
Module 22:Creating slides and applying themes
♦ Inserting new slide
♦ Changing layout of slides
♦ Duplicating slides
♦ Copying and pasting slide
♦ Applying themes to the slide layout
♦ Changing theme color
♦ Slide background
♦ Formatting slide background
♦ Using slide views
Module 23:Working with bullets and numbering
♦ Multilevel numbering and Bulleting
♦ Creating List
♦ Page bordering
♦ Page background
♦ Aligning text
♦ Text directions
♦ Columns option
Module 24:Working with Objects
♦ Shapes, Clipart and Picture, Word Art, Smart Art
♦ Change the Order of Objects
♦ Inserting slide header and footer
♦ Inserting Text boxes
♦ Inserting shapes, using quick styles
♦ Inserting Word art
♦ Inserting symbols
♦ Inserting Chart
Module 25:Hyperlinks and Action Buttons
♦ Inserting Hyperlinks and Action Buttons
♦ Edit Hyperlinks and Action Button
♦ Word Art and Shapes
Module 26:Working With Movies and Sounds
♦ Inserting Movie From a Computer File
♦ Inserting Audio file
♦ Audio Video playback and format options
♦ Video options, Adjust options
♦ Reshaping and bordering Video
Module 27: Using SmartArt and Tables
♦ Working with Tables, Table Formatting
♦ Table Styles
♦ Alignment option
♦ Merge and split option
♦ Converting text to smart art
Module 28: Animation and Slide Transition
♦ Default Animation, Custom Animation
♦ Modify a Default or Custom Animation
♦ Reorder Animation Using Transitions
♦ Apply a Slide Transition, Modifying a
♦ Transition, Advancing to the Next Slide
Module 29: Using slide Master
♦ Using slide master
♦ Inserting layout option
♦ Creating custom layout
♦ Inserting place holders
♦ Formatting place holders
Module 30: Slide show option
♦ Start slide show
♦ Start show from the current slide
♦ Rehearse timing
♦ Creating custom slide show
Module 31: Proofing and Printing
♦ Check Spelling As You Type
♦ Setting AutoCorrect Options
♦ Save as video
♦ Save as JPEG files
♦ Save as PowerPoint Show file
♦ Print Preview, Print


Module 32: Get Acquainted with Access
♦ What is access
♦ Introduction to Database
♦ Relational Database management system
♦ Introduction to Database objects
♦ Components of Access User interface
♦ Ribbon, Navigation pane, Back stage view
Module 33: Access startup screen
♦ Creating new blank Database
♦ Closing Database
♦ Creating Database from Template
♦ Opening an existing Database
♦ Backing up Database
Module 34: Using Navigation Pane
♦ Viewing object, Copying object
♦ Renaming Object, Deleting object
Module 35: Access Tables
♦ Planning Tables
♦ Planning fields
♦ Creating tables in Design view
♦ Modifying Tables in Design view
♦ Selecting a primary key
♦ Importing data from excel into new table
♦ Importing data as a linked table
Module 36:
♦ Relationship types
♦ Creating relationship in database
♦ Creating look up filed
♦ Viewing related data
Module 37: Creating Queries
♦ Creating Query in design view
♦ Creating Query with Query Wizard
♦ Modifying Queries
♦ Adjusting Query field
♦ Sorting Query field
♦ Hiding Query field
♦ Adding Query criteria
♦ Adding calculated field to Query
♦ Creating crosstab Query
Module 38: Using Forms
♦ Form views
♦ Creating form with form Wizard
♦ Working with forms in design view
♦ Working with forms in Layout view
♦ Working with padding, Margins and Anchoring
Module 39: Creating Reports
♦ Report sections
♦ Designing a report
♦ Report views, print view, and layout view
♦ Using the report tool
♦ Working with reports in layout view
♦ Working with reports in design view
♦ Creating blank report
♦ The field list pane
♦ Grouping and sorting report
♦ Previewing and printing reports


♦ What is Internet?, Receiving Incoming Messages
♦ Sending Outgoing Messages, Email addressing
♦ Email attachments, Browsing, Search engines
♦ Text chatting, Job Searching
♦ Downloading video and Music
♦ Uploading Video or Music, Voice chatting, Webcam Chatting etc.,
♦ Introduction to Blogging, Facebook
Course Name Duration Entry requirement Fee(SGD)
MS Office Full Course with Access 45 hrs Beginner of MS office S$860
Time Slot

Please call 63360244/96503505


mail to info.my@gteceducation.com.

We also provides flexible timing to meet the customer's requirement,

Brochure Request

Frequently Asked Questions

All the very best for the fure Devolopment..