WORD PROCESSING Microsoft word is Software that helps you to create neat and attractive document easily and quickly. It is Microsoft office suit. Microsoft word also allows you to change the appearance of text and organize the information in your document in a systematic manner.

MS-WORDStarting MS- WORDBefore creating or opening a document in MS-WORD, first you will have to load MS- WORD in memory. This can be done either by clicking at the shortcut of MS-WORD on the desktop, if available or by choosing MICROSOFT WORD application from programs menu pad starts menu.These are the Basic component of MS- WORD:1. Title Bar: It is a horizontal bar that is located at the top of the screen. It displays the name of the application and the active document.2. Menu Bar: It is a horizontal bar that is located below the title bar, its lists the word menu options.3. Formatting Bar: It is the toolbar consists of tools frequently used commands and utilities. 4. Standard Toolbar: it is horizontal bar that appear below menubar. It contains shortcut command buttons.5. Ruler Bar: It allows format the vertical alignment of text in a document.6. Status Bar: It is located below the drawing toolbars. It displays information which includes page numbers, the columns and lines numbers on which your cursor is present at any given point of a time.7. Scroll Bar: It is used to view different areas of the active window.

The Workspace is the area in a document window wherein you enter the text of your document.

All these components are shown in:

DROP CAP: Drop cap is a stylized first character of paragraph that generally has a very big size to grasp the attention of the reader. You must have seen in magazines that the first character from the starting of the articles is bigger size. This is called Drop Cap.

To apply Drop Cap to your paragraph click the cursor in the paragraph and choose. Drop Cap option from format menu.

COLUMNS AND TABLES: Sometimes you need to put your text in multiple columns as in newspapers. This can be done by the creating newspaper columns in the document. The text flow within newspaper columns and related things

TABLEColumn

A table is arrangement of text in form of columns and rows. A table can be useful for enhancing your documents. Table consists of vertical and horizontal rows. The intersection of the columns and rows is called a cell.

To insert a tables using table button1. Place the insertion point where you want to insert a table.2. Click the table button on standard toolbar then drag while holding down the mouse button to highlight the number of rows and columns you want in your table.3. When the displayed grid represents the desired numbers of rows and columns, replace the mouse button. An empty table will be insertion point.MAIL MERGE: Mail Merge is a very useful feature of Microsoft Word. It helps you to quickly produce a personalized letter for each and every person.In this facility, all data is stored in one document. The format of the letter is stored in another document with some special instructions. During the Mail Merge process, the main document is combined and merged with the document containing the data.

To work in a Mail Merge, You need to open Microsoft Word. And follow these steps:1. Click on the start button of taskbar, immediately a push up menu appears on the screen.2. Inside the push-up menu, click on programs option instantly, a second menu gets displayed, as seen in.3. In second menu move the mouse pointer over Microsoft Word option and click the left button. Blank MS- Word document opens up on the screen.4. Now click over the Tools menu bar option. Instantly, a pull- down menu gets displayed on screen.5. Inside the pull- down menu, move the mouse pointer over mail merge. Then a Mail Merge Helper box displayed.

SPELLING AND GRAMMER CHECK:You can search spelling errors in your documents and then correct them by using the spelling feature of word. Green wavy lines are placed possible grammar mistake and red line show spelling mistakes. So you can chose to ignore these errors marking keep typing, or you can correct the mistakes and or add the correction to word dictionary. It corrects our spelling mistakes in the included file.

HEADERS AND FOOTERS:In MS-WORD, header and footer can be created and formatting using the header and footer option of the view menu or insert.The word shows you header area in dotted outline wherein you can

Create and edit header text as you would any other. You paste graphics, apply style and otherwise format your work normally. Use the automatic pages number, time stamping features available on header and footer toolbar. Double click in the main document to return to work there.You enter footer the same way as header as given belowSame as useful features located on header and footer toolbar: Insert auto- text- drop- down menu showing commonly used header and footer information, including, author, page number and date. Insert page number Insert number of pages Formatting page numbers Insert date and time Page set up Close

INSERT PICTURE This option helps us to insert the picture in the worksheet. With the help of the option we can add different kind of picture in our worksheet.

MACRO:A macro is a shortcut to a task you do repeatedly. Think about the center align operation. You first highlight the word. You want center, then click the center icon in the toolbar. This is macro. It is the short way of performing the center task.

Clicking the center icon on the toolbar is much easier- it is a very useful macro built into Microsoft Word.

MS- ACCESSTo start MS-ACCESS, you may follow these steps:1. Click at start button.2. From the start programs, click at MICROSOFT ACCESS.3. And it will be open the access window

MS- ACCESS Window Components When you see an MS- ACCESS window there are various components that may be used for variety to task.1. Title bar2. Menu bar3. Access toolbar4. Database window5. Object button6. Status bar 7. Mode indication

Creating MS- ACCESS DatabaseWhen MS-ACCESS start it option to either create a data or open existing database creating database two methods: 1. Created blank database 2. Created database using wizard.

MS- EXCELL

INTRO: A spreadsheet is software tools that lets one enter, calculate, manipulate analyze set of numbers. Various components of spreadsheet are being discussed below:

WORKSHEET: It is a grid of cells made up of horizontal rows and vertical columns. Number of rows and columns vary from package to package.

MS- EXCELL worksheet contains 65,536 rows and 256 columns. Each rows and columns of intersection is called a cell and wherein data can be stored.ROW NUMBERS: Like 1 ,2 ,3 ,4,........... so as.COLUMNS LETTERS: A and go as B,C,D........Z,AA,AB,AC......AZ,BA,...... So as.Working with formulas:Formulas are entries in worksheet that defines the relationship of two or more cells. You can add formulas that add the point totals, calculate percentage, and assign letter grades. It is all done with the simple mathematic formulas.CONDITIONAL FORMATTING:By applying Conditional Formatting to your data, you can quickly identify variances in range of values with a quick glance. Apply the Conditional Formatting:1. On the HOME tab, in the Styles group, click the arrow next to CONDITIONAL FORMATTING, and then click color scales.

2. Hover over the color scale icons to see a preview of the data will conditional formatting applied.

17