Skip to main content

Posts

Microsoft Access MS Access Basics Tips and Trick-7

Adding Data An Access database is not a file in the same sense as a Microsoft Office Word document or a Microsoft Office PowerPoint are. Instead, an Access database is a collection of objects like tables, forms, reports, queries etc. that must work together for a database to function properly. We have now created two tables with all of the fields and field properties necessary in our database. To view, change, insert, or delete data in a table within Access, you can use the table’s Datasheet View. A datasheet is a simple way to look at your data in rows and columns without any special formatting. Whenever you create a new web table, Access automatically creates two views that you can start using immediately for data entry. A table open in Datasheet View resembles an Excel worksheet, and you can type or paste data into one or more fields. You do not need to explicitly save your data. Access commits your changes to the table when you move the cursor to a new field in the same row, or whe...

Microsoft word-office EDITING DOCUMENTS Tips and Tricks- 8

Zoom In and Zoom Out in Word 2010 Microsoft Word provides a functionality to apply zoom-in and zoom-out operations on a document. When we apply zoom-in operation, it enlarges the size of text whereas applying zoom-out operation reduces the size of text. A zoom operation just changes the size of the font on-screen without impacting any other attribute of the document. You can apply zoom operation in various ways which we are going to explain in this tutorial. Zoom-in & Zoom-out using view tab: Here is the simple procedure to apply zoom-in or zoom-out operation using view tab: Step (1):  Click the  view  tab and then click  Zoom  button which is shown below. Step (2):  When you click  Zoom  button, a Zoom dialog box will appear as shown below and will display zoom options box to select a value to reduce or increase the size of the document on-screen. BY default it will be 100%, you can select 200% to increase the size ...

Microsoft word-office EDITING DOCUMENTS Tips and Tricks- 7

Spell and Grammar Check in Word 2010 Microsoft Word provides a decent Spelling and Grammar Checker which enables you to search for and correct all spelling and grammar mistakes in your document. Word is intelligent enough to identify misspelled or misused, as well as grammar errors and underlines them as follows. A red underline beneath spelling errors. A green underline beneath grammar errors. A blue line under correctly spelled but misused words. Check Spelling and Grammar using Review tab: Here is the simple procedure to find out wrong spelling mistakes and fixing them: Step (1):  Click the Review tab and then click Spelling & Grammar button. Step (2):  A Spelling and Grammar dialog box will appear and will display wrong spellings or grammar and correct suggestions as shown below: Now you have following options to fix the spelling mistake: Ignore:  If you are willing to ignore a word then click this button and word ignores ...

Microsoft word-office EDITING DOCUMENTS Tips and Tricks- 6

Find & Replace in Word 2010 While working on editing a document you come across a situation very frequently when you want to search a particular word in your document and many times you will be willing to replace this word with another word at all the few or all the places throughout of the document. This tutorial will teach you how to find a word or phrase in a word document and how to replace existing word with any other word using simple steps. Find Command: The Find command enables you to locate specific text in your document. Following are the steps to find a word  document  in the following screen: Step (1):  Let us have a sample text available in our word document. Just type  =rand()  and press enter to have the following screen: Step (2):  Click the  Find option  in the  Editing group  on the Home tab or press  Ctrl + F  to launch the Navigation pane shown in step (2): ...

Microsoft word-office EDITING DOCUMENTS Tips and Tricks- 5

Copy, Cut & Paste in Word 2010 Previous tutorial explained how we can select desired text and move it to any other location in the same document or in any other document. This tutorial will teach you how to use copy, cut and paste techniques to duplicate a text leaving original text intact or removing original text completely. To use copy and paste or cut and paste operations, word makes use of a temporary memory which is called  clipboard . When you copy or cut a text then temporarily it stayed in clipboard and in second step you can paste this content at desired location. Copy & Paste Operation: Copy operation will just copy the content from its original place and create a duplicate copy of the content at the desired location without deleting the text from it's the original location. Following is the procedure to copy the content in word: Step (1):  Select a portion of the text using any of the text selection methods. Step (2):  At secon...

Microsoft word-office EDITING DOCUMENTS Tips and Tricks- 4

Move Text in Word 2010 Sometime it is required to move a text from one location to another location in the same document or in any another document. You can move text from one location in a document to another by using drag-and-drop technique with the help of mouse. This tutorial will teach you how to use drag and drop technique to move a text. Move with-in same document: Step (1):  Select a portion of the text using any of the text selection methods. Step (2):  Now take your mouse pointer over the selected text and hold mouse left button and keep holding it while moving around the document. Step (3):  Take your mouse pointer at the place where you want to move selected text and release the mouse button. You will see that selected text is moved to the desired location. Move with-in different documents: You can move selected text from one document to another document. You are comfortable in moving text with-in the same document ...

Microsoft word-office EDITING DOCUMENTS Tips and Tricks- 3

Delete Text in Word 2010 It is very common to delete text and retype the content in your word document. You might type something you did not want to type or there is something extra which is not required in the document. Regardless of the reason, Word offers you various ways of deleting the text in partial or complete content of the document. Using Backspace & Delete Keys: The most basic deletion technique is to delete characters one at a time by pressing either backspace or delete keys. Following table describes how you can delete single character or whole word by using either of these two keys: SN Keys & Deletion Methods 1 Backspace Keep the insertion point just after the character you want to delete and press  backspace  key. Word deletes the character immediately to the left of the insertion point. 2 Ctrl + Backspace Keep the insertion point just after the word you want to delete and press  Ctrl + Backspace  key. Word de...

Microsoft word-office EDITING DOCUMENTS Tips and Tricks- 2

Select Text in Word 2010 Selecting a text is one of the most important skill required while editing a word document. You can perform various operation on a selected text like you can delete it, copy it, move it, apply formatting to it, change its capitalization etc. The most common method of selecting a text is to click and drag the mouse over the text you want to select. Following table lists down few other simple method which will help you in selecting text in different scenarios: Component & Selection Method 1 Selecting text between two points Click at the start of the block of text, hold down Shift, and click at the end of the block. 2 Selecting a single word Simply double click anywhere on the word you want to select. 3 Selecting a paragraph Simply triple click anywhere on the paragraph you want to select. 4 Selecting a sentence Hold down  Ctrl  key and click anywhere in the sentence you want to select. 5 Selecting a column of text Hold down Alt, cl...

Microsoft word-office EDITING DOCUMENTS Tips and Tricks- 1

Insert Text in Word 2010 Many times it is required to go back and insert an additional text in an existing line. Microsoft word provides two ways to insert text in existing text and we will show how to use both the methods of inserting text: Insert and Add Text: First we will see how inserted text will be added into the existing content without replacing any existing content. Step (1):  Click the location where you want to insert text or you can use keyboard arrows to locate the place where you would like to insert the text. Step (2):  Start typing your text you want to insert. Word inserts the text to the left of the insertion point, moving existing text to the right. Insert and Replace Text: In this insertion mode, text will be added into the existing content but same time it will over write all the content which comes in its way. Step (1):  Right-click the status bar and select  Overtype  option from the displayed menu. ...