Skip to main content

Posts

Showing posts from August, 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 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 your inserted picture in different ways, like you can apply quick s

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 our document, so let us click over  Sample Templates  which will displa

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 and you will find that it is has been applied

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):  Try to add and remove dif

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 formula using  Formula List Box . Step (3):  Now cli

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 cells either row-wise or column-wise or both.

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

Split a Table in Word 2010 Sometime there will be a situation when you would like to split an existing table into two or more tables. Microsoft Word allows splitting a table into multiple tables but a single operation will always divide a table into two tables. This chapter will teach you how to split a table into two smaller tables. Split a Table: Following are the simple steps to split a table into two tables in a word document. Step (1):  Bring your mouse pointer position anywhere in the row that should appear as the first row of the new table. Step (2):  Now click the  Layout tab  and then click  Split Table Button  which will split the table into two tables and selected row will become the first row of the lower table. After splitting the table into two tables, you can further divide it into two parts and you can continue dividing word tables as long as a table has more than one number of rows. The beginner to advance and start up step-6

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

Merging Table Cells in Word 2010 Microsoft Word allows merging two or more cells to create one large cell. You would frequently need to merge columns of the top row to create title of the table. You can merge cells either row-wise or column-wise, rather you cannot merge cells diagonally. This chapter will teach you how to merge multiple rows or columns. Merging Cells: Following are the simple steps to merge table cells in a word document. Step (1):  Bring your mouse pointer position inside the first cell you want to merge. Now press  Shift  key and click the cells around the cell which you want to merge into the first cell. This will highlight the cells which you click and they will be ready to be merged. Step (2):  Now click the  Layout tab  and then click  Merge Cells Button  which will merge all the selected cells. After merging the cells, all the content of the cells will be scrambled which you can fix later as you like. For example, you can convert the

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

Resize a Table in Word 2010 Microsoft Word allows to resize a table to make it smaller and bigger as per your requirement. This chapter will give you simple steps to resize a table. Resize a Table: Following are the simple steps to resize a table available in a word document. Step (1):  Bring your mouse pointer over the table which you want to resize. As soon as you bring your mouse pointer inside the table, a small  Cross Icon  will appear at the top-left corner and a small  Resize Icon  will appear at the bottom-right corner of the table as shown below. Step (2):  Bring mouse cursor over the  Resize Icon  till it changes to diagonal double sided arrow and this is the time when you need to press left mouse button and keep holding the button while resizing the table. Drag the table up to make it shorter or down to make it larger. You can drag the table diagonally to simultaneously change both the width and height of the table. The beginner to advance and

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

Move a Table in Word 2010 Microsoft Word allows to move a table from one location to another location along with its content. This chapter will give you simple steps to move a table within the same document, though you can move a table from one document to another document using cut and paste operation. Move a Table: Following are the simple steps to move a table with-in the same word document. Step (1):  Bring your mouse pointer over the table which you want to move from location to another location. As soon as you bring your mouse pointer inside the table, a small  Cross Icon  will appear at the top-left corner of the table as shown below. Step (2):  Click over the small  Cross Icon  which will select the whole table. Once table is selected, use  Cut  button or simply press  Ctrl + X  keys to cut the table from its original location. Step (3):  Bring your insertion point at the location where you want to move the table and use  Paste  button or simply press  Ctr

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

Rows & Columns in Word 2010 As discussed in previous chapter, a table is a structure of vertical columns and horizontal rows with a cell at every intersection. A Word table can contain as many as 63 columns but the number of rows is unlimited. This chapter will teach you how to add and delete rows and columns in a table. Add a Row: Following are the simple steps to add rows in a table of a word document. Step (1):  Click a row where you want to add an additional row and then click  Layout tab  to have following screen. Step (2):  Now use  Row & Column group  of buttons to add any row below or above to the selected row. If you click  Insert Below  button, it will add a row just below the selected row as follows. If you click  Insert Above  button, it will add a row just above the selected row. Delete a Row: Following are the simple steps to delete rows from a table of a word document. Step (1):  Click a row which you want to delete from t