Skip to main content

Posts

Showing posts from May, 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

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 of the font or 75% to reduce the size o

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 the word throu

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): Step (3):  Enter a word which you want to search in the search box,

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 second step, yo