Scribd Logo
Upload

Welcome to Scribd!

  • 2K views

    Office Automation PDF

    Uploaded by

    Rizwan Ahmed
    This document provides an outline for a book on office automation. It covers topics like introduction to computers, Microsoft Word, Excel, Access, PowerPoint, business engineering, ERP, and HTML. For each topic, it lists subtopics that will be discussed in individual chapters. The book aims to teach readers key concepts and skills related to office productivity software and business management systems.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Office Automation PDF

    Uploaded by

    Rizwan Ahmed
    2K views7 pages
    This document provides an outline for a book on office automation. It covers topics like introduction to computers, Microsoft Word, Excel, Access, PowerPoint, business engineering, ERP, and HTML. For each topic, it lists subtopics that will be discussed in individual chapters. The book aims to teach readers key concepts and skills related to office productivity software and business management systems.

    Original Title

    Office Automation.pdf

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides an outline for a book on office automation. It covers topics like introduction to computers, Microsoft Word, Excel, Access, PowerPoint, business engineering, ERP, and HTML. For each topic, it lists subtopics that will be discussed in individual chapters. The book aims to teach readers key concepts and skills related to office productivity software and business management systems.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    2K views7 pages

    Office Automation PDF

    Uploaded by

    Rizwan Ahmed
    This document provides an outline for a book on office automation. It covers topics like introduction to computers, Microsoft Word, Excel, Access, PowerPoint, business engineering, ERP, and HTML. For each topic, it lists subtopics that will be discussed in individual chapters. The book aims to teach readers key concepts and skills related to office productivity software and business management systems.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 7

    Office Automation

    (Computer Fundamentals, MS-Word 2010, MS-Excel 2010, MS-Access 2010, MS-


    PowerPoint2010, Business Engineering and ERP)

    By

    Dr.P.Rizwan Ahmed, MCA., M.Sc.,M.A, M.Phil., Ph.D,


    Head of the Department
    Department of Computer Applications &
    Post Graduate Dept. of Information Technology
    Mazharul Uloom College, Ambur - 635 802
    Vellore Dist. Tamil Nadu.
    CONTENTS

    Preface
    Acknowledgement

    Chapter 1 Introduction to Computers

    1.1 Introduction
    1.2 Meaning and Definition
    1.3Capabilities of Computer
    1.4 Characteristics of a Computer
    1.5 Block diagram of Computer
    1.6 Generation of Computers
    1.7 Difference between the Generations of Computers
    1.8 Types of Computers / Classification of Computers
    1.8.1 On the basis of working principle
    1.8.2 On the basis of Size and Capacity
    1.9 The Parts of a Computer System
    1.10 Input Device
    1.10.1 Types of Input Devices
    1.10.1.1 Keyboard
    1.10.1.2 Mouse
    1.10.1.3 Scanners
    1.10.1.4 Joystick
    1.10.1.5 Light Pen
    1.10.1.6 Touch Screen
    1.10.1.7 Magnetic-ink character recognition (MICR)
    1.10.1.8 Optical Mark Reader (OMR)
    1.10.1.9 Optical Character Recognition (OCR)
    1.10.1.10 Optical Bar Code Reader (OBR)
    1.11 Output Devices
    1.11.1 Classification of Output Devices
    1.11.1.1 Dot Matrix Printer
    1.11.1.2 Inkjet Printer
    1.11.1.3 Laser Printers
    1.11.2 LCD Monitor
    1.12 Computer Languages
    1.12.1 Classification of Programming Languages
    1.12.2 Difference between machine, assembly and High-level language
    1.13 Generation of Programming Language
    1.14 Operating System
    1.14.1 Definition
    1.14.2 Evolution of operating systems
    1.14.3 Types of Operating System
    1.15 Function of Operating System

    Summary
    Review Questions

    Chapter 2 MS Word 2010

    2.1 Introduction
    2.2 What’s New in Word 2010
    2.3 Starting Word 2010
    2.4 Components of MS-Word / Microsoft Word Environment
    2.5 Working with word document
    2.5.1Creating a New Document
    2.5.2 Opening a Document
    2.5.3 Save a new document
    2.5.4 Save a document as a different file type
    2.5.5 Closing a Document
    2.5.6 Exiting Word
    2.6 Applying advanced formatting techniques
    2.6.1 Inserting Symbols and Special Characters
    2.6.2 Insert an equation
    2.6.3 Using Word Count and the Thesaurus
    2.6.4 Formatting Characters
    2.6.5 Formatting Paragraphs
    2.6.6 Indenting Paragraphs
    2.6.7 Setting Tab Stops
    2.6.8 Creating Bulleted and Numbered Lists
    2.6.9 Adding Borders and Shading
    2.6.10 Applying Styles
    2.7 Page Formatting
    2.7.1 Headers and Footers
    2.7.2 Inserting Page Numbers
    2.7.3 Page Setup
    2.7.4 Inserting Breaks
    2.7.5 Inserting Section Breaks
    2.8 Working with Columns
    2.9 Constructing high quality tables
    2.9.1 Inserting Tables
    2.9.2 Selecting Table Parts
    2.9.3 Adding Borders and Shading
    2.9.4 Aligning Table Text
    2.9.5 Inserting Rows and Columns
    2.9.6 Resizing Rows and Columns
    2.9.7 Merging and Splitting Cells
    2.9.8 Sorting Table Data
    2.9.9 Deleting Rows and Columns
    2.9.10 Deleting Tables
    2.10 Creating Outlines in Word
    2.11 Mail Merge / Creating Customized Merge Documents
    2.12 Adding reference to documents
    2.13 Working with Complex Documents
    2.13.1Section breaks
    2.13.2 Creating a Table of Contents
    2.14 Preparing a document for distribution
    Summary
    Review Questions

    Chapter 3 MS Excel 2010

    3.1 Introduction
    3.2 Starting Excel 2010
    3.3 Creating Excel Worksheet
    3.4 Entering and Editing Cell Entries
    3.5 Working with Numbers
    3.6 Inserting and deleting of cells, Rows and columns
    3.7 Moving, Copying, Inserting and Deleting Worksheet
    3.8 Changing Worksheet Layout
    3.9 Other Formatting options / Formatting a Worksheet
    3.10 Printing in Excel
    3.11 Using Functions and Reference
    3.12 Naming Ranges
    3.13 Working and entering a Formula
    3.14 Creating Charts
    3.15 Using Custom and Special Effects
    3.16 Elements of an Excel chart
    3.17 Using Financial and Statistical Functions
    3.18 Tracking and analyzing data with Excel
    3.19 Auditing a Worksheet
    Summary
    Review Questions
    Chapter 4 MS Access 2010

    4.1 Introduction
    4.2 Objectives of Access Database
    4.3 Parts of Access Window
    4.4 Starting Microsoft Access
    4.5 Creating a new database
    4.6 Creating table through design window
    4.7 Queries
    4.8 Creating a Form
    4.9 Reports
    Summary
    Review Questions

    Chapter 5 MS PowerPoint 2010

    5.1 PowerPoint 2010


    5.2 Starting PowerPoint2010
    5.3 Creating PowerPoint Presentation
    5.3.1Creating a basic Presentation
    5.3.1.1 Blank Presentation
    5.3.1.2 Adding Text
    5.3.1.3Insert a New Slide
    5.3.1.4 Rearrange the order of slides
    5.3.1.5 Delete a Slide
    5.3.1.6Copy a Slide
    5.3.1.7 Hide a Slide
    5.3.1.8 Saving and Closing a Presentation
    5.3.1.9 Closing a Presentation
    5.3.1.10 Running a Presentation
    5.4 Create a presentation Using template
    5.5 Open an Existing Presentation
    5.6 Building Presentation
    5.7 Modifying Visual Elements
    5.8 Formatting and Checking Text
    5.9 Using Headers and Footers
    5.10 Adding Objects
    5.11 Applying Transitions
    5.12 Animation Effects
    5.13 Preparing Handouts
    Summary
    Review Questions
    Chatper-6 Business Engineering and ERP

    6.1 Introduction
    6.2 Significance
    6.3 Principles
    6.4 Enterprise Resource Planning (ERP)
    6.5 Evolution of ERP
    6.6 What is ERP?
    6.7 Integrated System Approach
    6.8 Business Benefits of ERP
    6.9 ERP in Business Processes
    Summary
    Review Questions

    Chapter 7 HTML

    7.1 History of HTML


    7.2 Introduction
    7.3 HTML Tags
    7.3.1 Paired Tags or Container Tags
    7.3.2 Singular Tags or Empty Tags
    7.4 Advantages of HTML
    7.5 Disadvantages of HTML
    7.6 Structure of HTML document
    7.6.1 Head Section
    7.6.2 Body Section
    7.7 Basic Commands or Tags in HTML
    7.7.1 Bold
    7.7.2 Italic
    7.7.3 Underline
    7.7.4 BODY Tag <BODY>
    7.7.5 Center : <center>---</center>
    7.7.6 Line Break : <br
    7.7.7 Paragraph : <p> --- </p>
    7.7.8 Heading Styles
    7.7.9 Horizontal: <hr> tag
    7.7.10 Font: <Font>---</Font>
    7.8 Lists
    7.8.1 Ordered List
    7.8.2 Unordered List
    7.8.3. Definition List
    7.9 Creating Table
    7.9.1 <Table > Attributes
    7.10 Linking Documents
    7.10.1 Formatting the Link
    7.11 Adding Graphics to HTML documents
    7.11.1 Image Attributes
    7.12 Frames
    7.12.1 <FRAMESET> Tag
    7.12.2 <FRAMESET> Attributes
    Summary
    Review Questions

    You might also like