Skip to main content

Posts

Showing posts from April, 2020

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...
Post a Comment
Read more

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 ...
Post a Comment
Read more

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...
Post a Comment
Read more

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...
Post a Comment
Read more

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. ...
Post a Comment
Read more

Microsoft word-office MS WORD BASIC Tips and Tricks- 9

Context Help in Word 2010 Microsoft Office provides more than one methods for calling up help when you need it. Few easiest methods are given in our tutorial: Context Sensitive Help: This is the easiest way of getting help about any of the options available at word screen. You just need to bring your mouse pointer over an option and wait for 2 seconds, MS Word will pop-up a small balloon help giving you detail about the operation. If word has additional help for that option then it gives option  Press F1 for more help  as shown below when you bring your mouse pointer over colour fill option. You can press  F1  key to get further help on this option. Using F1 Button: You can press F1 when you are in the midst of doing something and office will display you various categories of help as shown below. You can either search a keyword using search option or you can browse listed categories to go through a topic in detail: Using Help Icon: You ca...
Post a Comment
Read more