IMTS DCA (Office automation tools)

Page 1

I ns t i t ut eofManage me nt & Te c hni c alSt udi e s

OFFI CEAUTOMATI ONTOOLS 500

Di pl omai nc omput e rAppl i c a t i on www. i mt s i ns t i t ut e . c om


IMTS (ISO 9001-2008 Internationally Certified)

OFFICE AUTOMATION TOOLS

OFFICE AUTOMATION TOOLS

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

CONTENTS:

UNIT-I

01-15

MS Office acess

UNIT-II

16-61

MS OFFICE

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

1

UNIT-I OFFICE ATUOMATION

1:0 INTRODUCTION Microsoft Access is a powerful program to create and manage your databases. It has many built in features to assist you in constructing and viewing your information. Access is much more involved and is a more genuine database application than other programs such as Microsoft Works. 1:1 OBJECTIVES First of all you need to understand how Microsoft Access breaks down a database. Some keywords involved in this process are: Database File, Table, Record, Field, Data-type.

1:2Starting Microsoft Access 

Two Ways 1. Double click on the Microsoft Access icon on the desktop.

2. Click on Start --> Programs --> Microsoft Access

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

2

1.3 Creating New, and Opening Existing Databases

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

3

The above picture gives you the option to: 

Create a New Database from scratch

Use the wizard to create a New Database

Open an existing database o

The white box gives you the most recent databases you have used. If you do not see the one you had created, choose the More Files option and hit OK. Otherwise choose the database you had previously used and click OK.

1:4 Create a database using the Database Wizard 1. When Microsoft Access first starts up, a dialog box is automatically displayed with options to create a new database or open an existing one. If this dialog box is displayed, click Access Database Wizards, pages, and projects and then click OK.

If you have already opened a database or closed the dialog box that displays when Microsoft Access starts up, click New Database on the toolbar. 2. On the Databases tab, double-click the icon for the kind of database you want to create. 3. Specify a name and location for the database. 4. Click Create to start defining your new database

1:5 Create a database without using the Database Wizard 1. When Microsoft Access first starts up, a dialog box is automatically displayed with options to create a new database or open an existing one. If this dialog box is displayed, click Blank Access Database, and then click OK.

If you have already opened a database or closed the dialog box that displays when Microsoft Access starts up, click New Database on the toolbar, and then double-click the Blank Database icon on the General tab. 2. Specify a name and location for the database and click Create. (Below is the screen

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

4

that shows up following this step)

1:6 Tables A table is a collection of data about a specific topic, such as students or contacts. Using a separate table for each topic means that you store that data only once, which makes your database more efficient, and reduces data-entry errors.

Tables organize data into columns (called fields) and rows (called records).

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

5

1:7Create a Table from scratch in Design view 1. If you haven't already done so, switch to the Database Window You can press F11 to switch to the Database window from any other window.

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

6

2. Double-Click on "Create table in Design view". (DESIGN VIEW)

3. Define each of the fields in your table. o

Under the Field Name column, enter the categories of your table.

o

Under Data Type column, enter the type you want for you categories. 

The attribute of a variable or field that determines what kind of data it can hold. For example, in a Microsoft Access database, the Text and Memo field data types allow the field to store either text or numbers, but the Number data type will allow the field to store numbers only. Number data type fields store numerical data that will be used in mathematical calculations. Use the Currency data type to display or calculate currency values. Other data types are Date/Time, Yes/No, Auto Number, and OLE object (Picture).

o

Under the Description column, enter the text that describes what you field is. (This field is optional).

o

For our tutorial enter the following items:

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

7

1:8 Primary Key 

One or more fields (columns) whose value or values uniquely identify each record in a table. A primary key does not allow Null values and must always have a unique value. A primary key is used to relate a table to foreign keys in other tables.

NOTE: You do not have to define a primary key, but it's usually a good idea. If you don't define a primary key, Microsoft Access asks you if you would like to create one when you save the table.

For our tutorial, make the Soc Sec # field the primary key, meaning that every student has a social security number and no 2 are the same. o

To do this, simply select the Soc Sec # field and select the primary key button

o

After you do this, Save the table

1:9 Switching Views 

To switch views form the datasheet (spreadsheet view) and the design view, simply click the button in the top-left hand corner of the Access program.

Datasheet View

Design View

Displays the view, which allows you to Displays the view, which allows you to enter fields, enter raw data into your database

data-types, and descriptions into your database

table.

table.

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

8

1:10 Entering Data 

Click on the Datasheet View and simply start "chugging" away by entering the data into each field. NOTE: Before starting a new record, the Soc Sec # field must have something in it, because it is the Primary Key. If you did not set a Primary Key then it is OK.

1:11 Manipulating Data 

Adding a new row o

Simply drop down to a new line and enter the information

Updating a record o

Simply select the record and field you want to update, and change its data with what you want

Deleting a record o

Simply select the entire row and hit the Delete Key on the keyboard

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

9

1:12Advanced Table Features w/Microsoft Access 

Assigning a field a specific set of characters o

Example) Making a Social Security Number only allows 9 characters. 1. Switch to Design View 2. Select the field you want to alter 3. At the bottom select the General Tab

4. Select Field Size 5. Enter the number of characters you want this field to have 

Formatting a field to look a specific way (HINT: You do not need to assign a field a specific set of characters if you do this) o

Example) Formatting Phone Number w/ Area Code (xxx) xxx-xxxx 1. Switch to Design View 2. Select the field you want to format 3. At the bottom select the General Tab 4. Select Input Mask Box and click on the ... button at the right. 5. Select Phone Number option

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

10

6. Click on Next 7. Leave !(999) 000-0000 the way it is. This is a default. 8. Click Next 9. Select which option you want it to look like 10. Click Next 11. Click Finish 

Selecting a value from a dropdown box with a set of values that you assign to it. This saves you from typing it in each time o

Example)Choosing a city that is either Auburn, Bay City, Flint, Midland, or Saginaw 1. Switch to Design View 2. Select the field you want to alter (City) 3. At the bottom select the Lookup Tab 4. In the Display Control box, select Combo Box 5. Under Row Source Type, select Value List 6. Under Row Source, enter the values how you want them displayed, separated by a comma. (Auburn, Bay City, Flint, Midland, Saginaw) 

NOTE:This will not alphabetize them for you, so you will have to do that yourself. It should look something like this:

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

11

7. Select in the datasheet view and you should see the change when you go to the city field.

1:13 Relationships After you've set up multiple tables in your Microsoft Access database, you need a way of telling Access how to bring that information back together again. The first step in this process is to define relationships between your tables. After you've done that, you can create queries, forms, and reports to display information from several tables at once.

A relationship works by matching data in key fields - usually a field with the same name in both tables. In most cases, these matching fields are the primary key from one table, which provides a unique identifier for each record, and a foreign key in the other table. For example, teachers can be associated with the students they're responsible for by creating a relationship between the teacher's table and the student's table using the TeacherID fields. Having met the criteria above, follow these steps for creating relationships between tables. 1. In the database window view, at the top, click on Tools ---> Relationships 2. Select the Tables you want to link together, by clicking on them and selecting the Add Button

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

12

3. Drag the primary key of the Parent table (Teacher in this case), and drop it into the same field in the Child table (Student in this case.)

4. Select Enforce Referential Integrity

o

When the Cascade Update Related Fields check box is set, changing a primary key value in the primary table automatically updates the matching value in all related records.

o

When the Cascade Delete Related Records check box is set, deleting a record in the primary table deletes any related records in the related table

5. Click Create and Save the Relationship

1:14Forms A form is nothing more than a graphical representation of a table. You can add, update, delete records in your table by using a form. NOTE: Although a form can be named different from a table, they both still manipulate the same information and the same exact data.

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

13

Hence, if you change a record in a form, it will be changed in the table also.

A form is very good to use when you have numerous fields in a table. This way you can see all the fields in one screen, whereas if you were in the table view (datasheet) you would have to keep scrolling to get the field you desire.

1:15Create a Form using the Wizard It is a very good idea to create a form using the wizard, unless you are an advanced user and know what you are doing. Microsoft Access does a very good job of creating a form using the wizard. The following steps are needed to create a basic form: 1. Switch to the Database Window. You can do this by pressing F11 on the keyboard. 2. Click on the Forms button under Objects on the left side of screen 3. Double click on Create Form Using Wizard 4. On the next screen select the fields you want to view on your form. Most of the time you would select all of them. 5. Click Next 6. Select the layout you wish 7. Click Next 8. Select the style you desire...HINT: if you plan on printing your form, I suggest you use a light background to save on printer toner and ink 9. Click Next 10. Give you form a name, and select Open the Form and enter information 11. Select Finish 12. You should see your form. To adjust the design of your form, simply hit the design button (same as with the tables), and adjust your form accordingly 1:16Reports A report is an effective way to present your data in a printed format. Because you have control over the size and appearance of everything on a report, you can display the information the way you want to see it.

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

14

1:17Create a Report using the Wizard As with the Form, it is a very good idea to create a report using the wizard, unless you are an advanced user. Microsoft Access does a very good job using the wizard to create reports. 1. Switch to the Database Window. You can do this by pressing F11 on the keyboard. 2. Click on the Reports button under Objects on the left side of screen 3. Double click on Create Report Using Wizard 4. On the next screen select the fields you want to view on your form. Most of the time you would select all of them. 5. Click Next 6. Select if you would like to group your files. Keep repeating this step for as many groupings as you would like. 7. Click Next 8. Select the layout and the paper orientation you desire 9. Click Next 10. Select the style you desire...HINT: if you plan on printing your report, I suggest you use a light background to save on printer toner and ink 11. Click Next 12. Give you report a name, and select Preview the Report 13. Select Finish 14. You should see your report. To adjust the design of your report, simply hit the design button (same as with the tables), and adjust your report accordingly

1:18Creating Mail Merge Labels using a Wizard Microsoft Access lets you create Mailing Labels for your database that you have. To do this do the following: 1. Switch to the Database Window. You can do this by pressing F11 on the keyboard. 2. Click on the Reports button under Objects on the left side of screen 3. Click on New

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

15

4. Select Label Wizard and the table you would like to get your information from.

5. Click OK 6. Select the layout of your labels 7. Click Next 8. Select the font size and color you want on each label 9. Click Next 10. Select how you want your label to look 11. Click Next 12. Select how you want your labels sorted 13. Give your label report a name and preview it

This tutorial will help you get started with Microsoft Access and may solve some of your problems, but it is a very good idea to use the Help Files that come with Microsoft Access (or any program you use for that matter)

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

16

UNIT –II MS-WORD

Microsoft Word is a powerful tool to create professional looking documents. This tutorial will help you get started with Microsoft Word and may solve some of your problems, but it is a very good idea to use the Help Files that come with Microsoft Word. 2.1

OBJECTIVES

WORD PROCESSING The keyboard of a word processor is similar to that of a typewriter, but its capabilities extend far beyond the typewriter’s. For example, you don’t have to press the Return or Enter key at the end of every line - in word processing, the line “wraps around” when it reaches the margin you’ve set and allows you to continue typing without stopping, you only press Enter (or Return) when you want to start a new paragraph or insert blank lines. If you make a mistake while typing use backspace or delete to erase it. 2.2 MS-WORD There are many commercial word processing programs including Open Office Writer

, Microsoft Word

, Corel WordPerfect

and others. Windows

comes with WordPad to edit and format documents and NotePad to edit text. Mac OS X comes with TextEdit or SimpleText in previous version. Open Office is an Open Source office application that can be downloaded for free at openoffice.org.

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

17

Editing functions such as inserting, deleting, moving, and copying characters, words, lines, and even blocks of text are fast and easy with only a few keystrokes. Advanced programs will number pages, repeat material in the same place on every page automatically, and check the spelling of every word in your document. You print your document only after it looks exactly the way you want it to. Finally, copies of your documents can be stored on a disk, enabling you to retrieve, edit, and print them at any time. The text appears at the cursor. Use the space bar to place spaces between words. Use backspace to erase to the left of the cursor and delete to erase to the right of the cursor. Use Enter (or Return) to move the cursor down a line. Word processors allows you to type your text in Bold, Italics or Underline. This is useful when you wish to highlight some word or line in a document. To activate Bold, Italics or Underline click the icon button on the Toolbar, type the text that you wish to have highlighted then press Toolbar icon again when you are finished. The indicator on the Toolbar will appear highlighted as long as the highlight style is on. The text can also be modified by changing the Font. A font is the shape and size of a character of text. The three main types are serif (with tails); sans-serif (without tails); and script (similar to handwriting). Text colours can also be changed. Text can also be indented and tab settings added which modify where the text is placed on the page. Rather than press the space bar more than once set tabs where you want the cursor to move to. The page can be modified by changing the margins, adding headers or footers (repeating text on each page), page numbering, graphic images and various other ways. The Insert key toggles between Insert and Typeover. Sometimes an indicator on the bottom of the screen will display the typing mode you are in. Normally, any text after the cursor will be pushed across the screen (inserted) as new characters are typed in. With Typeover on the new character will just replace the old character at the cursor. Editing text is quite easy once you get used to it. Select text that you want to modify with the mouse or by holding down Shift and using the arrow keys. Holding Control (CTRL) will select text one word at a time.

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

18

Once you have the text selected use Cut (Ctrl-X) to cut the text off the page and into a clipboard. Use Copy (Ctrl-C) to transfer a copy of the selected text to the clipboard. Use Paste (Ctrl-V) to paste the text into the document at the cursor. The Windows clipboard will only hold a single selection of text which is replaced with each new cut or copy. If you make a mistake most modern programs have an Undo feature (Crtl-Z). Many also have a Redo feature. Most word processors will check your spelling and many have thesauruses and will check your grammar. Don’t rely on the editing tools to replace a good proof reading though! (as this editor tends to do ;) 2.3 STARTING MICROSOFT WORD

Two Ways

1. Double click on the Microsoft Word icon on the desktop.

2. Click on Start --> Programs --> Microsoft Word

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

19

VIEWING THE TOOLBARS

The toolbars in Microsoft Word provide easy access and functionality to the user. There are many shortcuts that can be taken by using the toolbar. First, make sure that the proper toolbars are visible on the screen. 1. Click View 2. Select Toolbars 3. Select Standard, Formatting, and Drawing 4. Other toolbars can be selected if you wish

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

20

3.4 PARTS OF WORD WINDOWS Name

Icon

Description

New Blank Document

Creates a new, blank file based on the default template.

Open (File menu)

Opens or finds a file.

Save (File menu)

Mail Recipient

Print (File menu) Print Preview (File menu)

Saves the active file with its current file name, location, and file format. Sends the contents of the document as the body of the email message. Prints the active file or selected items. To select print options, on the File menu, click Print. Shows how a file will look when you print it.

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

21 Checks the active document for possible spelling,

Spelling

and

Grammar

(Tools menu)

grammar,

and

writing

style

errors,

and

displays

suggestions for correcting them. To set spelling and grammar checking options, click Options on the Tools menu, and then click the Spelling and Grammar tab.

Cut (Edit menu) Copy (Edit menu)

Removes the selection from the active document and places it on the Clipboard. Copies the selection to the Clipboard. Inserts the contents of the Clipboard at the insertion

Paste (Edit menu)

point, and replaces any selection. This command is available only if you have cut or copied an object, text, or contents of a cell. Copies the format from a selected object or text and applies it to the object or text you click. To copy the

Format Painter (Standard

formatting to more than one item, double-click

toolbar)

then click each item you want to format. When you are finished, press ESC or click

, and

again to turn off the

Format Painter. Undo (Edit menu)

Reverses the last command or deletes the last entry you typed.

Redo (Edit menu)

Reverses the action of the Undo command.

Hyperlink

Inserts a new hyperlink or edits the selected hyperlink. Displays the Tables and Borders toolbar, which contains

Tables and Borders

tools for creating, editing, and sorting a table and for adding or changing borders to selected text, paragraphs, cells, or objects.

Zoom

Office Assistant

Enter a magnification between 10 and 400 percent to reduce or enlarge the display of the active document. The Office Assistant provides Help topics and tips to help you accomplish your tasks.

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS 2:4

22

CREATING, EDITING AND SAVING A DOCUMENT

CREATING AND EDITING A DOCUMENT INTRODUCTION Now you are familiar with the basics of Ms-Word. After invoking Ms-Word, the next step is to create a file or document in which you can work. By default Ms-Word opens a new blank document when you start it. As you have seen from fig. 9.2 in the previous lesson, you noticed a blank work area where you can straight away type your text. However, let us close this work area by clicking the left mouse button at file on the main menu bar and then at close. The work area will disappear. Now, suppose you want to create a new document. OBJECTIVES At the end of the lesson you would be able to do the following functions

Creating a file Opening an existing file Insert text in a file Editing the document Deletion of text Let us discuss the important components of the screen. (a) Title Bar The title bar displays the name of the currently active word document. Like other WINDOWS applications, it can be used to alter the size and location of the word window. (b) Tool Bars Word has a number of tool bars that help you perform task faster and with great ease. Two of the most commonly tool bars are the formatting tool bar and the standard tool bar. These two toolbars are displayed just below the title bar. At any point of time any tool bar can be made ON or OFF through the tool bar option of View Menu. (c) Ruler Bar

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

23

The Ruler Bar allows you to format the vertical alignment of text in a document. (d) Status Bar The Status Bar displays information about the currently active document. This includes the page number that you are working, the column and line number of the cursor position and so on. (e) Scroll Bar The Scroll Bar helps you scroll the content or body of document. You can do so by moving the elevator button along the scroll bar, or by click in on the buttons with the arrow marked on them to move up and down and left and right of a page. (f) Workspace The Workspace is the areas in the document window were you enter/type the text of your document. (g) Main Menu The Word main menu is displayed at the top of the screen as shown in the Fig. 9.1. The main menu further displays a sub menu. Some of the options are highlighted options and some of them appear as faded options. At any time, only highlighted options can be executed, faded options are not applicable. Infect if the option is faded you will not be able to choose it. You may not that any option faded under present situation may become highlighted under different situations. MAIN MENU OPTIONS The overall functions of all the items of main menu are explained below. (a) File You can perform file management operations by using these options such as opening, closing, saving, printing, exiting etc. It displays the following sub menu.

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

24

File Sub menu

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

25

(b) Edit Using this option you can perform editing functions such as cut, copy, paste, find and replace etc. It displays the following sub menu.

Edit Sub menu

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

26

(c) View Word document can be of many pages. The different pages may have different modes. Each mode has its limitations. For example in normal mode the graphical picture cannot be displayed. They can only be displayed in page layout mode. Using the option "View" you can switch over from one mode to other. It displays the following Sub menu.

View Sub menu

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

27

(d) Insert Using this menu, you can insert various objects such as page numbers, footnotes, picture frames etc. in your document. It displays the following Sub menu.

Insert Submenu

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

28

(e) Format Using this menu, you can perform various type of formatting operations, such as fonts can be changed, borders can be framed etc. It displays the following Sub menu.

Format Submenu

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

29

(f) Tools Using this menu, you can have access to various utilities/tools of Word, such as spell check, macros, mail merge etc. It displays the following Sub menu.

Tool Submenu

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

30

Table This menu deals with tables. Using this menu you can perform various types of operations on the table. It displays the following Sub menu.

Table Sub menu

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

31

(h) Window This menu allows you to work with two documents simultaneously. This would require two windows to be opened so that each one can hold one document. Using this menu, you can switch over from one window to another. It displays the following Sub menu.

Window Sub menu (i) Help Using this menu, you can get on-line help for any function.

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

32

CREATING A DOCUMENT

Selecting a New Document

Create Document Tool

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

33

ENTERING TEXT IN THE DOCUMENT

After you create a document, you can start typing the required text. The text will appear on the screen at the current location of the cursor. Ms-Word will automatically take care of the right margin of the text. The insertion point moves automatically to the next line. If you want to start a line or paragraph at the middle you have to press Enter key.

CUT, COPY AND PASTE OPTION:

Selecting Text:

Place the mouse pointer at the beginning of the text that you wish to format, Click once, keep the left mouse button pressed and drag till the end of the block. Release the mouse button and you would see that the block selected by you has been highlighted in black color and the text is shown in white color, as displayed here: Now you can apply and formatting command like Bold faced Italics, Underline, Left Align, Center Align, Right Align, Justify, etc. by simply clicking on the correct icon. You can also change the font size, style and type, of this Block.

Cut a Block:

In case you have a block of text that you wish to move to another location , either within the same page or to another page or even to any other document, choose the Cut command

from the Edit Menu , after selecting the desired block. On applying this

command, the block would disappear from its original location. You many now use the paste command to place this block anywhere else. You can also use the Cut command to share data between files created by different applications like Word, Excel, Power Point, etc. This has a great advantage that you can do a specific task in a particular application (which is most appropriate for this task) share this data in other application.

Copy a block:

If you have a block of text that you wish to copy to any other location, choose the Copy command instead of Cut command. Notice the important difference, in case of Cut command the block disappears from the original location and is there only at the new

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

34

location, whereas in case of Copy command the appears both, at the original location as well as the new location.

Paste a block:

Once a block has been either cut or copied using the Cut or Copy command, simply place the cursor at the new location and choose the Paste command to the selected block here.

Delete a block:

Block a piece of text (based upon steps explained earlier) and simple press the Del key from the keyboard to delete this block. Alternatively, you can also use Clear command from the Edit Menu, for this. These and other applications like designing borders and drawing figures, using the toolbars, are explained in detail in subsequent pages.

MOVING AROUND THE DOCUMENT Before you start edit, the cursor must be brought to the desired location. Following are a few of the keys that can be used to move around in a document

Press

Name of key(s)

To move cursor to

Left arrow

Left by one character

Right arrow

Right by one character

Up arrow

Up by one line

Down arrow

Down by one line

Ctrl +

Ctrl and left arrow

Previous word

Ctrl +

Ctrl and right arrow

Next word

Ctrl+Home

Ctrl and Home

Beginning of a line

Ctrl+End

Ctrl and End

End of a line

Page Up

Page Up

Up by one page

Page Down

Page Down

Down by one page

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

35

SAVING A WORD DOCUMENT:

Now since we have put in substantial amount of work creating this document, it might be a good idea to save it for posterity! In fact, for all you subsequent documents you must go on saving your work from time to time. Let us say every 15 Minutes or so, or after completing every section. Doing this ensures that if there is problem like power off or your machine has gone into hung state,etc. you only lose minimal work.

1. Choose Save command from File menu. 2. Type the file name by which you wish to save your file. 3. Click on the Save button.

Note: In the Save As dialog box specify the name of your document.

CHANGE CHARACTER SIZE USING THE FONT DIALOG BOX: Now, let’s begin changing fonts and point sizes.

1.

Highlight the Title.

2.

Choose Font command from Format menu.

3.

Using either the keyboard arrows or the mouse pointer select a font which you like the best.

4.

Select also the desired Font size by clicking once on it.

5.

Click on OK button.

PARAGRAPH FORMATTING: Changing the paragraph in a good form is paragraph formatting.

1. LINE SPACING: Line spacing helps to arrange the vertical space between lines of text within a paragraph. 1. Select FORMAT menu option. 2. Click Paragraph option from the menu. 3. Select Indents and Spacing. 4. Choose any one option in that menu. 5. Finally click OK button.

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

36

The following are the options available in formatting:

1. ALIGNMENT: i) Left ii) Right

: To arrange Left side. : To arrange Right side.

iii) Centered

: To arrange centre.

iv) Justified

: To arrange Scatter.

2. INDENTATION: 1. Left 2. Right

: To leave empty space in Left side. : To leave empty space in Right side.

3. SPACING: 1. Before

: To create empty space on the Top.

2. After

: To create empty space on the Bottom.

1. LINE SPACING:

1. Single

: Sets the Line spacing for each line to that of the largest font in the line.

2. Lines

: Sets the line spacing to one and half times that of single line spacing.

3. Double

: Sets the line spacing to twice that of single line spacing.

4. Exactly

: Sets fixed line spacing.

5. Atleast

: Sets the minimum line spacing and that word can adjust to accommodate largest font size.

6. Multiple

: Allow spacing to increase or decrease by a percentage.

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

37

Entering text in text box: After you have finished typing, your letter should look like this. If you made some mistakes while typing, refer to navigation instruction about how to make modifications, deleting and additions to existing text.

1.

click here and type the slogan” Creativity & Synergy”.

Changing the Font:

1.

Place the mouse pointer at the beginning of the text. Click the left button and start highlighting the entire text by dragging the mouse till the end of the text. Of course, you may alternatively begin from the end and move backwards toward the beginning of the text.

2.

Click at the font box of formatting tool bar. Click once at the pull down arrow symbol and a list of all the available fonts would be displayed. Use the mouse to move up and down in this list. Click at the font that you wish to apply. “Arial” font has to be chosen for our present exercise. The moment you have clicked and chosen a particular font, this pull down list would automatically close and the selected font would be applied to the highlighted text.

Changing font size:

1. Highlight the text .Click here to see a list of point size. These numbers refer to the size of the characters that you wish to format. Higher the point size number, bigger would be the character size for the highlighted text. Please remember that before you choose that point size, the range of text much be selected first.

Aligning the text:

Now let us learnt to change the alignment of text. By default, text is always left aligned. 1.

Highlight the line by dragging the mouse till the end of text.

2.

Choose paragraph from format menu.

3.

Choose indents and spacing folio by clicking on it once.

4.

Choose the option Centered from ‘Alignment’.

5.

Click once on OK button

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

38

In word you can indent any length of selected text. You can indent from left margin, from Right margin or from both margins. There are three options for special indent-None, Firstline and Hanging. Choose all these options by one and after seeing its preview in the preview window remove and select the one you like.

Underline the Text:

Now having centered the text, we wish to underline it.

1.

Highlight the text. Choose Font command from Format menu.

2.

Choose Single line option from the ‘underline’ pull down list.

3.

Click on OK button to continue.

Justifying the Text: Having learnt to align text, we shall now apply this knowledge to justify a whole paragraph between the left and right margin.

1.

Highlight the entire paragraph.

2.

Choose Paragraph command from Format menu.

3.

Choose justified option from Alignment pull down list.

4.

Click once on OK button.

NUMBERING:

One of the really smart features of Word is to create numbered lists. Old word processor users would appreciate, how much time was wasted in trying to manually create a perfectly aligned numbered list. Through this feature, once you have chosen a list of items separated by Enter key, you can ask Word to automatically assign consecutive numbers to this list.

1.

Highlight the Text.

2.

Choose Bullets and Numbering command from Format menu or click once on the numbering icon.

3.

Click here to choose Numbered.

4.

Choose the numbering pattern you wish to apply by clicking anywhere inside the chosen pattern box.

5.

click once on OK button

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

39

Note: items are automatically numbered with hanging indent effect. BULLETS:

Just as we can create numbered lists, we can also create Bulleted lists. The main difference here is that instead of consecutive numbers in case of numbered list, items appear with the same chosen bullet mark. 1.

Highlight the text and choose Bullets and Numbering command from Format menu.

2.

Click on the Bulleted folio/tab.

3.

Choose the Bullet mark you wish to apply by clicking once on it.

4.

Click on OK button to continue.

Note: Individual lines appear with bullet mark with hanging indent effect.

BORDERS:

Now let us start formatting. In order to start formatting our table we would need the Borders Tool bar.

1.

Choose Tables and Borders command from the Toolbar options from the View menu.

2:5

2.

Place the cursor in the first table. Choose select Table from Table menu.

3.

Click here to open borders frame.

4.

Click here to apply style to ‘All’ border frame.

PREVIEWING AND PRINTING A DOCUMENT:

INTRODUCTION Thanks to Chris Maunder for introducing the printing method in Printing without the Document/View framework. Many people have been asking for print preview without the doc/view framework as well. However, so far, no body has proposed a way to do that yet. I have studied on how Microsoft implements print preview in doc/view framework using the class CPreviewView, which is derived from CSrollView. The print preview is called from CView::OnFilePrintPreview ( ) and CView::DoPrintPreview. They are undocumented, the source code can be found from VC\mfc\src\Viewprev.cpp. The implementation relies on CView and CFrameWnd framework extensively.

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

40

In order to use the default print preview functionality in non doc/view framework, like dialog based applications, I played a trick by creating temporary CFrameWnd and CView objects and then calling the default OnFilePrintPreview( ) from the temporary view class. I borrowed Chris Maunder’s CGridCtrl control from MFC Grid control (derived from CWnd) article as an example to illustrate the implementation. I included another demo project, which was modified from Iuri Apollonio’s article: Generic printing class (and how to print list control content). The code was developed under VC5 environment and has been tested in Windows 98 and NT platforms without any problem. :)

PAGE SETUP:

Page formatting is the method by which a page is designed into a good readable form.

1. PAGE MARGINS: i)

Margins are the distance between the text and page of the paper.

ii)

In word text and the graphics are normally printed inside the margins.

iii)

Headers, footers and page numbers are printed in the margins.

iv)

Margins can be set in two ways. a) using the rulers: Drag and Margin boundaries on the Horizontal and Vertical ruler bars. b) Using page setup dialog box: File ->Page setup ->Margins->Choose options->ok.

The following are the options available in the page formatting.

1. Top

: To set the Top margin.

2. Bottom

: To set the Bottom margin.

3. Left

: To set the Left Margin.

4. Right

: To set the Right margin.

5. Gutter

: To set the Left side binding margin.

PAPER SIZE:

1. The paper size tab in the page setup dialog box can be used for selecting the paper size and page orientation. 2. Page orientation can be vertical or horizontal.

File -> Page setup ->Paper size ->Choose options ->ok.

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

41

The following are the options available in the Paper Size:

1. Paper size

: To select standard paper size.

2. Width

: To select paper width.

3. Height

: To select paper height.

4. Orientation i) Portrait ii) Landscape

: To choose paper height wise. : To choose paper Widthwise.

HEADER AND FOOTER:

Another helpful feature of Word is Header and Footers. Using this feature you can print a standard piece of text and or an image at the top or end of each page of your document(s).The most common use of Headers and Footers is to print page numbers and reference titles.

1. Choose Header and Footer command from the View menu. 2. The dashed line box would be displayed below the formatting toolbar. 3. Click once on Page setup icon from the Headers and Footers toolbar. 4. If you take careful look at the sample exercise you will notice that the first page header and footer in different from the rest of the pages. For making this possible click once on different first page checkbox in the dialog box. 5. Click once on OK button to continue. 6. Let us now insert a clip art graphic (which, let us presume, is the logo of total Synergy Consulting) in the first page header. Choose clip art from Picture option of Insert menu. 7. Choose this Academic category from the clip Art Gallery. 8. Choose this Clipart from the clip Art Gallery button. 9. Click once on Insert Clip button. 10. The chosen graphic would be displayed.

PRINT:

Now is the time to actually print our great piece of work!

1.

Choose Print command from file menu.

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS 2.

42

Choose your printer from this list. In most of the cases default printer would be the right one.

3.

Click here to choose All. This would print all the pages of the print document.

4.

Click on OK button to print.

PRINT PREVIEW:

Once you have completed spelling for the entire document, now is the time to sit back and take stock of your work. Because of advanced WYSIWYG feature (What You See Is What You Get) in-built in MS Office, you can see a preview, on screen of what you wish to print. In most cases, this preview would give you an exact replica of what your printer would print. This is very helpful, since you save considerable amount of time and money (in printing and stationary cost) by making sure that your document looks exactly the way it should, before you finally print it.

1.

Choose Print Preview command from File menu.

2.

This is what appears on the screen. An exact copy of the page, which your printer would print. If you are happy with what you see, go ahead and prints the document .If not, goes back to the main screen by clicking on Close button and make necessary changes.

2.6

CREATING TABLES AND WORKING WITH GRAPHICS

Click where you want your table to go 1. Click Table at top of screen 2. Select Insert 3. Select Table 4. Give your table dimensions

Inserting a Picture 1. Click where you want your picture to go 2. Click Insert at top of screen 3. Select Picture 4. Select Clip Art or From File 5. Select picture and click Insert

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

43

Inserting Page Numbers and Date/Time 1. Click Insert at top of screen 2. Select Page Numbers and/or Date & Time

Spell Checking Your Document 1. Click Tools at top of screen 2. Select Spelling and Grammar

2.7 INTRODUCTION TO MS-EXCEL

Introduction into Microsoft Excel Starting Up Microsoft Excel Creating Formulas Order Of Operations Borders and Shading Inserting A Chart

Introduction into Microsoft Excel

Microsoft Excel is allows you to create professional spreadsheets and charts. It performs numerous functions and formulas to assist you in your projects.

This tutorial will help you get started with Microsoft Excel and may solve some of your problems,

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

44

but it is a very good idea to use the Help Files that come with Microsoft Excel , or go to Microsoft’s web site located at http://microsoft.com/office/excel/default.htm for further assistance.

2.9 Starting Microsoft Excel 

Two Ways

1.

Double click on the Microsoft Excel icon on the desktop.

2.

Click on Start --> Programs --> Microsoft Excel

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

45

2.10 Creating Formulas 1. Click the cell that you want to enter the formula. 2. Type = (an equal sign). 3. Click the Function Button 4. Select the formula you want and step through the on-screen instructions

2.11 Order of Operations Excel Uses

Precedence Operation

Operator

1

Exponentiation

^

2

Multiplication

*

2

Division

/

3

Addition

+

3

Subtraction

-

4

Concatenation (putting 2 strings together, like Jenn & ifer) &

5

Equal To

=

5

Greater Than

>

5

Less Than

<

2.12 Adding Borders and Shading to Cells 1. Make sure you have the Formatting toolbar visible o

Click on View --> Toolbars --> Formatting

2. Select cells you wish to format by left clicking on them and highlighting them 3. Click the

button to shade a cell and/or the

to give a cell a border

2.13 Inserting a Chart 1.

Select over the text you want to make your chart with

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

2.

Click Insert --> Chart

3.

Select the type of chart you want

46

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

4.

Confirm or change your data range

5.

Update the Chart Options

47

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

6.

48

Select if you want to put it into the current worksheet or into a new worksheet

INTRODUCTION TO MICROSOFT POWERPOINT

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

49

Introduction into Microsoft PowerPoint Starting Up Microsoft PowerPoint Creating a Presentation Opening an existing Presentation Creating a Blank Presentation Different PowerPoint Views Slide Manipulation Slide Animation Slide Transitions View Slide Show Navigating While in Slideshow Pack up a presentation for use on another computer

Introduction into Microsoft PowerPoint

Microsoft PowerPoint is a powerful tool to create professional looking presentations and slide shows. PowerPoint allows you to construct presentations from scratch or by using the easy to use wizard.

This tutorial will help you get started with Microsoft PowerPoint and may solve some of your problems, but it is a very good idea to use the Help Files that come with Microsoft PowerPoint, or go to Microsoft’s web site located at http://microsoft.com/office/powerpoint/default.htm for further assistance.

2.15 Starting Microsoft PowerPoint 

Two Ways

1. Double click on the Microsoft PowerPoint icon on the desktop.

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

50

2. Click on Start --> Programs --> Microsoft PowerPoint

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

51

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

52

2.16 Creating a Presentation

After you open up Microsoft PowerPoint, a screen pops up asking if you would like to create a New Presentation or Open An Existing Presentation.



AutoContent Wizard o

Creates a new presentation by prompting you for information about content, purpose, style, handouts, and output. The new presentation contains sample text that you can replace with your own information. Simply follow the directions and prompts that are

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

53

given by Microsoft PowerPoint. 

Design Template o

Creates a new presentation based on one of the PowerPoint design templates supplied by Microsoft. Use what is already supplied by Microsoft PowerPoint and change the information to your own.

Blank Presentation o

Creates a new, blank presentation using the default settings for text and colors. Go to next step: Creating A Blank Presentation

2.17 Opening An Existing Presentation 1. Select Open An Existing Presentation from the picture above 2. Click on your presentation in the white box below step 1 o

If you do not see your presentation in the white box, select More Files and hit OK.

o

Locate you existing Presentation and hit the Open button

2.18 Create a Blank Presentation

After you select Blank Presentation a window pops up asking you to select the layout of the first slide.

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

54

Pre-Designed Slide Layouts (Left to Right) 

Title Slide

Bulleted List

Two Column Text

Table

Text & Chart

Chart & Text

Organizational Chart

Chart

Text & Clip Art

Clip Art & Text

Title Only

Blank Slide

NOTE: If you already know what you want in your next slide, it is a very good idea to choose one of the pre-designed layouts from above. However if you do not, then you can still insert what you want in throughout your Presentation anytime you desire. Just choose Blank Slide and insert items as you see fit.

2.19 Different Views That PowerPoint Demonstrates

There are different views within Microsoft PowerPoint that allow you to look at your presentation from different perspectives.

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

Normal View

Outline View

55

Slide View

Slide Sorter View Slide Show View

Switches to normal Switches to

Switches to slide

Displays miniature Runs your slide

view, where you

outline view,

view, where you

versions of all

show in a full

can work on one

where you can

can work on one

slides in a

screen, beginning

slide at a time or

work with the

slide at a time

presentation,

with the current

organize the

structure of your

complete with text slide if you are in

structure of all the file in outline form.

and graphics. In

slide view or the

slides in your

Work in outline

slide sorter view,

selected slide if

presentation

view when you

you can reorder

you are in slide

need to organize

slides, add

sorter view. If you

the structure of

transitions, and

simply want to

your file.

animation effects. view your show You can also set

from the first slide:

the timings for

Click Slide Show

electronic slide

at the top of the

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

56 shows.

screen.Select View Show

2.20 Slide Manipulation 

Inserting A New Slide 1. Click Insert at top of screen 2. Select New Slide

Formatting A Slide Background o

You can format your slide to make it look however you would like, whether it is a background color, picture, or a design template built into Microsoft PowerPoint. The next step will show you how to apply a Design Template, but the other items mentioned above can be accomplished the same way. 1. Click Format at the top of the screen 2. Select Apply Design Template

3. Select Design you wish to apply 4. Click Apply Button 

Inserting Clipart & Pictures 0. Display the slide you want to add a picture to. 1. Click Insert at the top of the screen 2. Select Picture 3. Select Clip Art 4. Click the category you want

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

57

5. Click the picture you want 6. Click Insert Clip on the shortcut menu 7. When you are finished using the Clip Gallery, click the Close button on the Clip Gallery title bar 8. Steps 1-4 are very similar when inserting other Pictures, Objects, Movies, Sounds, and Charts 2.21 Adding Transitions to a Slide Show

You can add customized transitions to your slide show that will make it come alive and become appealing to your audience. Follow these steps when adding Slide Transitions. 1. In slide or slide sorter view, select the slide or slides you want to add a transition to. 2. On the Slide Show menu at the top of the screen, click Slide Transition

3. In the Effect box, click the transition you want, and then select any other options you want 4. To apply the transition to the selected slide, click Apply. 5. To apply the transition to all the slides, click Apply to All. 6. Repeat the process for each slide you want to add a transition to. 7. To view the transitions, on the Slide Show menu, click Animation Preview. 2.22 Viewing The Slide Show

You can view your slide show by any of the following ways: 1. Click Slide Show at the lower left of the PowerPoint window. 2. On the Slide Show menu, click View Show.

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

58

3. On the View menu, click Slide Show. 4. Press F5 on the keyboard 2.23 Navigating While In Your Slide Show 

Forward Navigation o

Reverse Navigation o

Simply click on the left Mouse Button or hit the Enter Button on your keyboard

Hit the Backspace on the keyboard

Exiting the show o

Hit the Esc Button on the keyboard

2.25 Pack up a presentation for use on another computer 1. Open the Presentation you want to pack 2. On the File menu, click Pack and Go 3. Follow the instructions in the Pack and Go Wizard. Unpack a presentation to run on another computer 1. Insert the disk or connect to the network location you packed the presentation to 2. In My Computer, go to the location of the packed presentation, and then double-click Pgsetup 3. Enter the destination you want to copy the presentation to

SELF ASSESMENT QUESTIONS –I ANSWER THE FOLLOWING QUESTIONS

1.

Define word processor

2.

Define document window

3.

Creating – editing and saving a word document

4.

Previewing and printing a documents

5.

Creating tables and working with graphics

6.

Explain about printing a document

7.

Explain how to insert picture

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

59

SELF – ASSESMENT QUESTIONS – II

8.

Reference Unit questions Recommendations for further readings Answers for Self-Assessment Questions

SUMMARY

In Word, many fields are available for insertion into a document. Although not every field is summarized here, the most commonly-used fields are listed below. All of the fields listed in this document can be inserted in a similar manner. For more information, refer to Inserting Fields. Date and Time Document Information User Information UNIT QUESTIONS

1. Explain parts of ms-word 2. How you will create table 3. How you will create picture 4. List out the parts of window

RECOMMENDATIONS FOR FURTHER STUDIES 1. Introduction to Ms-word , Balagurusamy 2. Introduction to Ms-office 3. Fundamentals of computer ,Sugithra publications

ANSWERS FOR SELF-ASSESMENT QUESTIONS

I 1. The keyboard of a word processor is similar to that of a typewriter, but its capabilities extend far beyond the typewriter’s.

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFICE AUTOMATION TOOLS

60

2. Toolbars in Microsoft Word provide easy access and functionality to the user. There are many shortcuts that can be taken by using the toolbar. First, make sure that the proper toolbars are visible on the screen.

II 1. Thanks to Chris Maunder for introducing the printing method in Printing without the Document/View framework. Many people have been asking for print preview without the doc/view framework as well.

---------------------------------------------THE END---------------------------------

FOR MORE DETAILS VISIT US ON WWW.IMTSINSTITUTE.COM OR CALL ON +91-9999554621


OFFI CEAUTOMATI ONTOOLS

Publ i s he dby

I ns t i t ut eofManage me nt& Te c hni c alSt udi e s Addr e s s:E4 1 , Se c t o r 3 , No i da( U. P) www. i mt s i ns t i t ut e . c o m| Co nt a c t :9 1 +9 2 1 0 9 8 9 8 9 8


Turn static files into dynamic content formats.

Create a flipbook
Issuu converts static files into: digital portfolios, online yearbooks, online catalogs, digital photo albums and more. Sign up and create your flipbook.