Tux Tech

Pictures are the best way for adding the visual interest to your publication. You can add the picture depending upon your publication. The Picture tool in Publisher 2010 will make it very easy to incorporate the images into your documents and change those images in some interesting ways. In the following tutorial you will learn how you can fit, insert and format your pictures. You can also learn about Working with Shapes and Objects in Publisher 2010.

Adding Pictures:

In order to insert the pictures froma file you need to follow these simple steps.

• 1^st of all select the Insert tab and then locate the Illustrations group.
• Now click on the Picture command.
• You will notice that the Insert Picture dialog box will appear.
• Locate and select the picture you like to insert and the click on Insert.
• The desired picture wil be added into your publication.

Inserting Clip Art:

• 1^st of all select the Insert tab and then locate the Illustrations group.
• Now you need to click the Clip Art command.
• The Clip Art pane will appear on the right.
• Use the search tools for searching for a suitable image.
• Click on Go in order to begin your search.
• Publisher will now display the pictures which will meet your search terms. Once you have found the desired image you need to click it.
• The Clip Art will be added to your publication.
• Fitting Pictures in your Publication:

Resizing a Picture:

• 1^st of all select the picture.
• Now click on the corner sizing handles and then drag your mouse till the picture is of desired size.
• Now you are required to release the mouse and the picture will be resized.

Cropping a Picture:

• 1^st of all select the picture and then click on the Picture Tools Format tab and locate the Crop group.
• Now you need to click the Crop command.
• The black cropping handles will show up.
• Click and drag a handle to crop the picture. The area to be cropped will appear as semi-transparent.
• Once you are satisfied with the appearance of the picture click on Crop command once again.
• The picture will be cropped.

Adjusting the Brightness and Contrast:

• 1^st of all select the picture which you need to adjust and after that select the Picture Tool Format tab and then locate the Adjust group.
• Now you need to click the Brightness drop-down command.
• From the drop-down menu which appears select the desired brightness.
• Positive sign + will make the picture more brighter and negative number – will make the picture darker.
• Now click on the Contrast drop-down command.
• Now you are required to select the desired contrast level. Positive sign will create greater contrast and negative sign will reduce the contrast.

MS PowerPoint 2013 is an application which can be used for creating presentations. In your presentations you can add the text so that you can add the content of your presentations. In this tutorial you will learn about the basics of the text like how can you copy, cut, paste, format and replacing the text. You can also learn about Worksheet Basics in MS Excel 2013.

Selecting the Text:

In order to select the text you need to follow these simple steps.

• Click next to the text you need to select and then drag the mouse over the text. Release the mouse and the text will be selected.

Copying and Moving the Text:

MS PowerPoint lets you copy the text which is already on a slide and then paste it elsewhere which can save your precious time.

Copy and Paste Text:

For copying and pasting the text in MS PowerPoint 2013 you need to follow these simple steps.

• 1^st of all select the text you need to copy and then click the Copy command on the Home tab.
• Now you need to place the insertion point where you need your text to appear.
• Now you need to click the Paste command on the Home tab.
• The copied text will appear.

Cut and Paste Text:

In order to cut and paste the text you need to follow these simple steps.

• 1^st of all select the text which you need to move and then click the Cut command.
• Now place the insertion point where you need the text to appear and then click the paste command.
• The text will appear in the new location.

Using the Find and Replace feature:

While working with the longer presentations it is very difficult as well as time taking activity to locate the specific word or a phrase. MS PowerPoint can search automatically your presentation using the Find feature and it lets you quickly change words or phrase by using the Replace feature.

Finding The Text:

In order to find the text you need to follow these simple steps.

• 1^st of all from the Home tab you need to click the Find command.
• Now a dialog box will appear where you need to enter the text you need to find in the Find what: field and after this click Find Next.
• Now if the text is found it will be selected.
• Now you need to click Find Next in order to find further instances. If nothing is found a dialog box will appear. Click on OK.
• Once you are finished you need to click Close to exit the dialog box.

Replacing a Text:

For replacing the text you need to follow these simple steps.

• 1^st of all from the Home tab you need to click the Replace command.
• Now a dialog box will appear you need to type the text you need to find in the Find what: field.
• Now you need to type the text which you want to replace it with in the Replace with: field and then click Find Next.
• If the text is found it will be selected.
• Now if you need to replace it select one of the replace options which include Replace and Replace All.
• The Selected text will then be replaced.

Each workbook contains at least one worksheet by default. When you are working in a huge amount of data you can create various different worksheet in order to help organize your workbook and make it easier to file content. The worksheets can be grouped for quickly adding information to multiple worksheets simultaneously. You can also learn about Entering and Editing the Data in Tables in MS Access 2007.

Renaming A Worksheet:

In order to rename a worksheet you need to follow these simple steps.

• 1^st of all you need to right click the worksheet which you want to rename and then select Rename from the worksheet menu.
• Now type the desired name for your worksheet.
• Now you need to click anywhere outside of the worksheet or press Enter on your keyboard.
• With these simple steps the worksheet you can easily rename the worksheet.

Inserting a New Worksheet:

• 1^st of all locate and select the New sheet button.
• You will notice that a new blank worksheet will appear.

Deleting a Worksheet:

• 1^st of all right-click the worksheet you need to delete and then select Delete from the worksheet menu.
• The worksheet will be deleted from your workbook.

Copy a Worksheet:

• 1^st of all right-click the worksheet you need to copy and after that select Move or Copy from the worksheet menu.
• The Move or Copy dialog box will appear. Select where the sheet will appear in the Before sheet: field.
• Now check the box located next to Create a Copy and after that click OK.
• With these steps the worksheet will be copies.

Moving a Worksheet:

• 1^st of all select the worksheet which you need to move. (The cursor will become a small worksheet icon.)
• In the next step you need to hold and drag the mouse till a small black arrow appears above your desired location.
• Now you need to release the mouse and the worksheet will be moved.

Changing the Tab Color of the Worksheet:

• 1^st of all right click the desired worksheet tab and then hover the mouse over the Tab Color.
• The Color menu will appear.
• Now you need to select the desired color.
• You will notice that the worksheet tab color will be changed.

Grouping Worksheets:

To group Worksheets:

• 1^st of select the first worksheet you need to include in the worksheet group.
• Now you need to press and hold the Ctrl key on your keyboard.
• Now you need to select the next worksheet which you want in the group. Continue selecting the worksheets till the required number of worksheets are grouped.
• Now release the Ctrl key and the worksheets will now be grouped.

MS Access 2007 databases holds all the actual data records inside the tables. You can easily add, edit and delete all the records from these tables. In this tutorial you will learn how can you add new records aand edit the existing records by using commands like copy and paste. You can also learn about Applying the Styles and Themes in MS Word 2007.

Adding and Editing the Data in Tables:

Adding Records to Tables:

When you enter the records into your table you are actually populating the database. In MS Access 2007 you can perform this in very different ways.

Adding Records in the New Record Row:

• 1^st of all click the record row with the asterisk that appears at the bottom of the table.
• Now type the data into the appropriate fields.
• Now hit the Enter or the Tab key to move to the next field.

Adding Records with the New Record Navigation Button:

• Click on the New Record button in the navigation bar.
• The navigation bar is located in the bottom left corner of the open pbject pane.
• Now you are required to type the data into the appropriate fields.
• Now you need to press Enter or the Tab key to move to the next field.

Adding Records with the New Record Command:

• 1^st of all you are required to click on New Record command in the Records group in the Ribbon.
• Now type in the data into the appropriate fields.
• Now you need to press the Enter button or the Tab key in order to move to the next field.

Editing Records in Tables

Editing the Record Directly:

• 1^st of all you need to scroll through the records or use the navigation buttons on the navigation bar to find the record to edit.
• Now click the cell containing the information that must be edited.
• A Pencil icon appears to indicate edit mode.
• Now you need to type in the new information into the field.
• Now click the outside of the record row to apply the change.

Editing the Record using Find and Replace command:

• 1^st of all click the Find command in the Find group on the Ribbon.
• The Find and Replace dialog box opens.
• Now tell Access what to find by typing it into the Find What: area.
• Now type the replace term in the Replace With: area.
• Now tell Access where to look with the Look In: drop down list. The first choice in the drop-down list is the field you were the last in within the table.
• Now tell Access what to Match: Any part of the field, whole field or just the start of the field.
• In the next step tell Access how to Search: Up finds records above the cursor, All searches all records.
• Now click one of the action options Find Next, Replace or Cancel.

Copy and Paste a Record:

• 1^st of all select the record which you want to copy.
• Right click and then select Copy.
• Now select the New record row.
• Right click and select Paste.

Styles and Themes are very powerful tools which will allow you create professional looking documents easily. A Style isa predefined combination of font style, color and size of the text that can be applied to the selected text. A Theme is the set of formatting choices which can be applied to the whole document and it also include theme color, fonts and effects. You can also learn about Exploring Charts in MS Excel 2007.

Using Styles and Themes:

Selecting a Style:

In order to select a style you need to follow these steps.

• 1^st of all you need to select the text which you need to format.
• Now in the Style group on the Home tab hover over every style to see a live preview in the document.
• Click on More drop-down arrow in order to see additional styles.
• Now you are required to left click a style in order to select it. The selected text will appear formatted in the style.

Modifying a Style:

• 1^st of all you are required to select the text in the style which you need to change.
• Now locate the style in the Styles group.
• Now right click the style and a menu appears.
• Left click on the Modify and Modify Style dialog box will appear.
• Change any of the formatting.
• Click on OK to apply the modifications to the style.

Creating a New Style:

• 1^st of all click on the arrow located in the bottom right corner of the Styles group. This action of yours will open the Styles task pane.
• Now click on the New Style button at the bottom and a dialog box will appear.
• Now enter the name for the style and make all of the formatting decisions.
• Now select the button beside New Document which is based on this template so the style will be available to use in all of your documents.
• Now click OK and you will see a new style will appear in the list.

Applying a Style Set:

• 1^st of all click the Change Styles command on the Ribbon.
• Now select the Style Set from the menu that appears.
• Now left click a style set to select it. You will see that the change is reflected in the whole document.

Applying a Theme:

• 1^st of all select the Page Layout tab.
• Now click the Themes command.
• In the next step you need to hover your pointer over a theme to see it displayed in the document.
• Now left click on the theme in order to select it.

Creating a Custom Theme:

• 1^st of all open the document which you want to format.
• Now select the Page Layout tab.
• Now click on the Colors command.
• Now select the Create New Theme Colors. You will notice that a dialog box will appear.
• Use the drop-down menus in order to change the colors for each part of the document.
• In the next step you are required to enter the name of the theme color.
• Now click on Save.
• In the next step click on Fonts command.
• Now select Create New Theme Fonts. A new dialog box will appear.
• Now use the drop-down menu to change the fonts in the dialog box.
• Now enter the name for theme font.
• Click on Save.
• In the next step click the effects command and select an option from the drop-down menu.
• Now click on the Themes command.
• Select the Save Current Theme and you will notice a dialog box will appear.
• Enter the name of the theme and then click on Save.