top of page
Picsart_25-11-01_00-39-09-356.png

SidSharmaji

Office Automation (DCA-102)

UNIT - I
Working with MS-Word

UNIT - II
Introduction to MS-Excel 

  1. Introduction and area of use

  2. Working with MS Excel

  3. Concepts of Workbook & Worksheets

  4. Using Wizards

  5. Various Data Types

  6. Cell and Texts

  7. Inserting, Removing & Resizing of Columns & Rows

  8. Formulas – Use of Formulas

  9. Calculations using various types of functions – Logical, String, Date & Time, Math’s and other types

UNIT - III
Working with MS-Power-Point

MS PowerPoint Topics:

  1. Introduction & area of use

  2. Working with MS PowerPoint

  3. Creating a New Presentation

  4. Working with Presentation

  5. Slides & its different views

  6. Inserting, Deleting and Copying of Slides

  7. Working with Notes

  8. Handouts

  9. Columns & Lists

  10. Adding Graphics, Sounds and Movies to a Slide

  11. Working with PowerPoint Objects

  12. PowerPoint Objects – Insert WordArt and other objects like Shapes, ClipArt, Charts and SmartArts

  13. Symbol in PowerPoint

  14. Designing & Presentation of a Slide Show

UNIT - IV
Working with MS-Access

MS Access Topics:

  1. Getting Started

  2. Adding and Changing Data

  3. Simple Queries

  4. Creating Append Queries

  5. Creating QBE Queries

  6. Multi-table QBE Queries

  7. SQL Queries

UNIT - V
Outlook Express

Outlook Express Topics:

  1. Introduction

  2. What is Outlook Express?

  3. Features of Outlook Express

  4. Starting Outlook Express

  5. Concepts of CC and BCC

  6. Email Address

  7. Reading a received message

  8. Composing message

  9. Replying and Forwarding Messages

  10. Attaching files

  11. Creating Signature in Outlook Express

  12. Formatting message text

bottom of page