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

Microsoft word-office ADVANCED OPERATIONS Tips and Tricks-5

Auto Formatting in Word 2010 The AutoFormat feature automatically formats a document as you type it by applying the associated styles to text. Let us learn how to use auto format option available Microsoft Word 2010 to format the typed content. For example if you type three dashes -- and press enter, Word will automatically create a line for you. Similarly word will automatically format two dashes -- into an em dash (—). Setting AutoFormat: Following are the simple steps to set AutoFormat feature in your Microsoft Word. Step (1):  Click the  File tab , click  Options , and then click  Proofing  option available in the left most column, it will display  Word Options  dialog box. Step (2):  Click the  AutoCrrect Options  button which will display  AutoCorrect  dialog box and then click  AutoFormat As You Type  tab to determine what items Word will automatically format for you as you type. ...
Post a Comment
Read more

Microsoft word-office ADVANCED OPERATIONS Tips and Tricks-4

Auto Correction in Word 2010 The AutoCorrect feature automatically corrects common typographical errors when you make them. Let us learn how to use auto correction option available Microsoft Word 2010 to correct the spelling automatically as you type the words in your documents. Setting AutoCorrect: Following are the simple steps to enable AutoCorrect feature in your Microsoft Word. Step (1):  Click the  File tab , click  Options , and then click  Proofing  option available in the left most column, it will display  Word Options  dialog box. Step (2):  Click the  AutoCrrect Options  button which will display  AutoCorrect  dialog box and then click  AutoCorrect  tab. Now you have to make sure all the options are enabled specially  Replace Text as you type  option, if any of the options needs to be turned off then be careful before turning it off. If you are beginner then I'm sure you would ...
Post a Comment
Read more

Microsoft word-office ADVANCED OPERATIONS Tips and Tricks-3

Use Graphics in Word 2010 You can beautify your Microsoft Word documents by inserting a variety of graphics. There are slight differences in adding graphics in your word document. This chapter will teach you two ways of adding graphics and rest will leave up to you to try. further Adding Picture in Document: Following are the simple steps to add an existing picture in your word document. It is assumed that you already have a picture available on your PC before you add this picture in your word document. Step (1):  Click in your document where you want to add a picture. Step (2):  Click the  Insert tab  and then click  Picture  option available in illustrations group, which will display  Insert Picture  dialog box. Step (3):  You can select a required picture using  Insert Picture  dialog box. When you will click  Insert  button, selected picture will be inserted in your document. You can play with you...
Post a Comment
Read more

Microsoft word-office ADVANCED OPERATIONS Tips and Tricks-2

Use Templates in Word 2010 Microsoft Word template is a collection of styles which defines paragraph styles for regular text paragraphs, a title, and different levels of headings. You can use any of the already existing templates for your word document or you can design a template which can be used for your all the company documents. Using Existing Template: Following are the simple steps to use an already existing template for your newly created word document. A template is selected at the time when you create a new blank document. Step (1):  To start a new document, Click the  File tab  and then click  New  option which will display  Available Templates  to be selected. Step (2):  Microsoft Word provides a list of templates arranged under  Sample Templates  or you can download hundreds of templates from  office.com  which are arranged in different categories. We will use  Sample Templates  for ou...
Post a Comment
Read more

Microsoft word-office ADVANCED OPERATIONS Tips and Tricks-1

Quick Styles in Word 2010 Microsoft Word provides a gallery of Quick Styles that you can apply to headings, titles, text, and lists. Quick styles gives you with sets of canned formatting choices, such as font, boldface, and color which we will see in this chapter. Apply Quick Styles: Following are the simple steps to apply quick styles on selected text. Step (1):  Select a text on which you want to apply a style. Using style you can make selected text as a heading or subheading or title of the document. You can try using different styles on your text based on your requirement. Step (2):  Click the  Home tab  and then move your mouse pointer over the available styles in  Style Gallery  and you will see your selected text will change its style based on the selected style. You can display more available styles by clicking over  More Style  button. Step (3):  Finally to apply a selected style, just click over the style an...
Post a Comment
Read more

Microsoft word-office WORKING WITH TABLES Tips and Tricks-9

Table Borders & Shades in Word 2010 Microsoft Word allows you to place a border on any or all of the four sides of a table very similar to text, paragraphs, and pages. You can also add many type of shading to table rows and columns. This chapter will teach you how to add any of the borders ( left, right, top or bottom) around a table and how to add different shadows to various rows and columns of the table. Add Borders To Table: Following are the simple steps to add borders in a table cell available in word document. Step (1):  Select the table to which you want to add border. To select a table, click over the table anywhere which will make  Cross Icon  visible at the top-left corner of the table. Just click this cross icon to select the table. Step (2):  Click the  Border Button  to display a list of options to put a border around the selected table. You can select any of the option available by simply clicking over it. Step (3...
Post a Comment
Read more

Microsoft word-office WORKING WITH TABLES Tips and Tricks-8

Add Formula to a Table in Word 2010 Microsoft Word allows you to use mathematical formula in table cells which can be used to add numbers, to find average of numbers, or find the largest or smallest number in table cells you specify. There is a long list of formulas from which, a formula can be used based on the requirement. This chapter will teach you how to use formula in word tables. Add a Formula: Following are the simple steps to add formula in a table cell available in word document. Step (1):  Consider the following table where we will have total of the rows. Click in a cell that should contain the sum of a rows. Step (2):  Now click the  Layout tab  and then click  Formula button  which will display a  Formula Dialog Box  which will suggest a default formula, which is  =SUM(LEFT)  in our case. You can select a number format using  Number Format List Box  to display the result or you can change the fo...
Post a Comment
Read more

Microsoft word-office WORKING WITH TABLES Tips and Tricks-7

Split a Table Cells in Word 2010 Previous chapter taught us how to divide a table into multiple tables. Sometime you will need to split a table cell into two or more sub-cells. Microsoft Word allows splitting a cell into multiple cells. This chapter will teach you how to split a cell into multiple smaller sub-cells. Split a Cell: Following are the simple steps to split a cell into two sub-cells of a table available in word document. Step (1):  Bring your mouse pointer position inside a cell that you want to divide into multiple cells. Step (2):  Now click the  Layout tab  and then click  Split Cells Button  which will display a dialog box asking for number of rows and columns to be created from the selected cell. Step (3):  Select the desired number of rows and columns which you would like to have in resultant cell and finally click  OK  button to apply the result. You can divide a cell into multiple c...
Post a Comment
Read more