Skilled Bharat
info.s.bharat@gmail.com |
91+ 8900713504

COURSE DETAILS

COM

Certificate in Office Management

Contents

1) MS WORD

  • (HOME MENU)-New,Open,Close, Save, Save As, Formatting Text,Fontsize,Font Style, Font Color,Use The Bold, Italic, And Underlines. Line Spacing, Find ,Replace .Change The Text Case, Shanding With Tabs And Indents
  • (REFERENCES):- Table Of Contents, Add Text, Update Table, Insert Footnote, Insert Endnote, Next Footnote, Show Notes, Insert Citation, Manage Sources, Style, Bibliography, Insert Caption Insert Table Of Figures, Update Table, Cross- References, Mark Entry, Insert Infex, Update Index, Mark Citation, Insert Table Of Authorities
  • (MALLING )-Envelopes, Labels, Start Mail Merge, Select Recipients, Edit Recipients List, Highlight Marge Fields, Address Block, Greeting Line, Insert Merge Field, Rules, Match Fields Update Labels, Preview Results,Previous Record, Next Record, Last Record, Find Recipient, Auto Check For Errors, Finish & Merge
  • (VIEW)- print layout, full screen, web layout, outline, draft, ruler, gridlines, document map, thumbnails, zoom, one page, two, page, page width, new window, arrange all, split, switch windows, macros

2) MS POWERPOINT

  • (GETTING ACQUAINTED WITH POWERPOINT)The PowerPoint envirionmment,the title bar, the ribbon, the Microsoft office button, the quick access toolbar, the scroll bar, the presentation view buttons, the zoom slider, the status bar, the mini Toolbar, keyboard shortcuts
  • ( CREATING BASIC PRESENTATIONS)-opening presentations, cloning presentations, creating new presentations, saving presentations, saving presentations, inserting new slides, applying slide layouts, using the "package for CD feature", working with power point file formats
  • (USING TEXT) adding text to slides, basic object manipulation, font formatting, applying custom bullets and numbering, using tabs, setting text box options, checking spelling
  • (USING SMARTART)-Inserting And Manipulating Smart art, Formatting Smart art,
  • (USING SLIDE SHOW VIEW)-Running a slide show, using custom shows.
  • (PRINTING YOUR PRESENTATION)-

3) MS ACCESS

  • 1. Introduction to Database Management :- Type of Database, Examples of DBMS
  • 2. Definitions :- Table, Field, Field Name, Record, Database, Database Object
  • 3. Opening Microsoft Access :- Start button & Desktop icon
  • 4. Creating a Database file :- Designing a table - Field names, Data Types, Description
  • 5. Data Types :- Text, Number, Data/Time, Yes/No, Currency, Memo, AutoNumber, Ole Object, Lookup Wizard
  • 6. Entering Records within a table
  • 7. Editing parts of a table :- Selecting, Renaming, Inserting, Deleting, Hiding, Freezing, Resizing
  • 8. Sorting Records
  • 9. Moving to specific records :- First, Last, Previous, Next, New
  • 10. Formatting e table :- Font, Cells
  • 11. Checking Spelling , Finding and Replacing data

4) VISULBASIC 6.0

  • Getting Started- Procedure For Starting, Printing the Program, Saving the Program, Reloading a Program, Exiting Basic, Loading .tax Files.
  • Input Values and Output Displays - Data Type Values, Variables, Assignment Statements, Displaying Values, Dialog Boxes, Numeric Values as Input. creating output Menus, Putting it all Together
  • Numeric Calculations- operations, Functions and Expressions, Operation Hierarchy, Sub expressions, Built In Function, Concatenation, Formatting Output, Putting It All Together
  • Decision Making - Simple comparisons, Numeric Comparisons, Strings, Character Representation, Dictionary Ordering, String comparisons, Conditional Statements, Simple if blocks, The Else option, compound conditional if Blocks, Multi-case if Blocks, Putting It All Together
  • Branching - Ling Labels, Unconditional Branching, 3 Repetition of Code, Conditional Branching, Repetition a Number of Times, Sentinels, Prompt and Echo, 8 User Interrogation Technique, 9 Putting It All Together

5) TYPING- ENGLISH(Speed_____word/minute) , BENGALI(______word/minute)& OTHER REGONAL LANGUAGE

  • Typing Practice in Englsh & Any one Regional Language

6) MS EXCEL (Advance)

  • INTRODUCTIONTOCOMPUTERS  Fontformatting  Numberformatting  Tableformatting  Conditionalformatting  Hide/Unhide  Sort/filter  Pastespecial  Findandselect
  • INSERT  Illustrations  Charts  Te
  • PAGE LAYOUT Basic Functions  Sum/Average/Count/Max/ Min  BasicText/date/time/lookup/information functions  Name manager  Formula Auditing
  • DATA  Import from web  Import from text  Text to columns  Remove duplicates  Grouping and ungrouping
  • REVIEW  Proofing  Comments  Protection
  • VIEWS  Typesofviews  Zoom  Windows
  • DEVELOPER  Enable developer  Using checkbox/option buttons
  • BASIC FORMULA  Formulae that Add/Subtract/Multiply/Divide  BODMAS/Formula Error Checking  The Sum Function
Apply Online
Skilled Bharat