Skip to main content

Posts

Showing posts from July, 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 FORMATTING PAGES Tips and Tricks-6

Cover Pages in Word 2010 Almost all the good documents and books have an attractive first page that includes the document title, its subject, author and publisher name etc. This first page is usually called  Cover Page  and Microsoft Word provides an easy way to add a cover page. Add Cover Pages: Following are the simple steps to add a cover page in a word document. Step (1):  Click the  Insert tab , and click  Cover Page  button available in the Pages group. This will display a list of  Built-in Cover Pages  as shown below. Step (2):  Just click the cover page from the gallery that you want to add to your document. Selected cover page will be added as the first page of your document which can you modify as per your need. If you want to place cover page elsewhere except first page, right-click the cover page in the gallery and select the location you want from the menu that appears. Delete Cover Pages: Following are the simple steps to delete an exi

Microsoft word-office FORMATTING PAGES Tips and Tricks-5

Insert Blank Pages in Word 2010 There may be a situation when you would like to insert a blank pages in between your text pages. A blank page is a page which does not have any text or any other content over it. This chapter will teach you how to insert as well as how to delete a blank page from your Microsoft Word document. Insert Blank Pages: Following are the simple steps to insert blank page in a word document. Step (1):  Bring your insertion point immediately before the text that you want to insert a blank page. Step (2):  Click the  Insert tab , and click  Blank Page  button available in the Pages group. Word inserts a new blank page and moves all text after the page break onto a new page. Delete Blank Pages: Following are the simple steps to delete blank page from a word document. Step (1):  Click the  Home tab , and click  Show/Hide ¶  paragraph marks button available in the Paragraph group or simply press  Ctrl + Shift + *  keys. This wi

Microsoft word-office FORMATTING PAGES Tips and Tricks-4

Insert Page Breaks in Word 2010 Microsoft Word automatically starts a new page when the current page becomes filled with text but you can insert a page break to force Word to start text on a new page. You can insert a page break using either the mouse or the keyboard. Insert Page Breaks: Following are the simple steps to insert page breaks in a word document. Step (1):  Bring your insertion point immediately before the text that you want to appear on a new page. Step (2):  Click the  Insert tab , and click  Page Break  button available in the Pages group. Word inserts a page break and moves all text after the page break onto a new page. You can also use  Ctrl + Enter  keys to create a page break at the pointed location. Delete a Page Break Just put insertion point on previous page of the page break you want to delete. Press  Delete  key multiple times until both the pages get merged. The beginner to advance and start up step-4 Thank yo

Microsoft word-office FORMATTING PAGES Tips and Tricks-3

Add Page Numbers in Word 2010 Microsoft Word automatically assign page numbers on the pages of your document. Typically, page numbers are printed either in header or footer but you have option also can display the page number in the left or right margins at the top or the bottom of a page. Add Page Numbers: Following are the simple steps to add page numbers in a word document. Step (1):  Click the  Insert tab , and click  Page Number  button available in header and footer section. This will display a list of options to display page number at the top, bottom, current position etc. Step (2):  When you move your mouse pointer over the available options, it displays further styles of page numbers to be displayed. For example when I take mouse pointer at  Bottom of Page  option it displays following list of styles. Step (3):  Finally select of the page number styles which you like most. I selected  Accent Bar 1  style by clicking over it. After this step y

Microsoft word-office FORMATTING PAGES Tips and Tricks-2

Add Header and Footer in Word 2010 Headers and footers are parts of a document that contain special information such as page numbers and the total number of pages, the document title, company logo, any photo etc. The header appears at the top of every page, and the footer appears at the bottom of every page. Add Header and Footer: Following are the simple steps to add header and footer in a word document. Step (1):  Click the  Insert tab , and click either  Header button  or  Footer button  whatever you want to add first. Assume you are going to add Header, so when you click  Header button  it will display a list of built-in Headers from where you can choose any of the headers by simply clicking on it. Step (2):  Once you select any of the headers, it will be applied to the document in editable mode and the text in your document will appear dimmed,  Header and Footer buttons  appear on the Ribbon and a  Close Header and Footer  button will also appear at

Microsoft word-office FORMATTING PAGES Tips and Tricks-1

Adjust Page Margins in Word 2010 Margins are the space between the edge of the paper and the text. You can adjust the right, left, top, and bottom margins of your document. By default, Word sets all margins left, right, top, and bottom to 1 inch. Below, I have shown top, left and right margins, if you will type complete page, word will leave 1 inch bottom margin as well. Adjust Margins: Following are the simple steps which will be used to set margins for an opened document. Step (1):  Open the document whose margins you want to set. If you want the margins to apply only to a selected part of a document, select that part now. Step (2):  Click the  Page Layout tab , and click  Margins button  in the Page Setup group. This will display a list of options to be selected but you have to click  Custom Margins option  available at the bottom. You can also select any of the predefined margins from the list, but using custom margins option you will have more control on

Microsoft word-office FORMATTING TEXTS Tips and Tricks-11

Copy and Apply Formatting in Word 2010 If you already have a well formatted text and you want to apply similar formatting to another text then Microsoft Word provides a feature to copy and apply a format from one text to another text. This is very useful and time saving operation. Copy and Apply of text formatting works for various text attributes for example text fonts, text colors, margins, headings etc. Copy and Apply Text Formatting: Following are the simple steps to copy and apply text formatting from one portion of your document to another portion of your document in a word document. Step (1):  Select the text containing the formatting that you want to copy. I have selected a text which has bold and underlined font as shown below. Step (2):  click the  Home tab  and click the  Format Painter  button to copy the format of the selected text. As soon as you click the format painter button, the mouse pointer changes to a paint brush when you move the mouse ov

Microsoft word-office FORMATTING TEXTS Tips and Tricks-10

Set Tabs in Word 2010 Microsoft Word tabs help in setting up information properly within a column. Word enables you to set left, center, right, decimal, or bar tabs to line up columnar information. By default, Word places tabs every .5 inch across the page between the left and right margins. Tab Description Left Left-aligns text at tab stop and this is the default tab. Center Centers text over tab stop. Right Right-aligns text at tab stop. Decimal Aligns numbers at decimal point over tab stop. Bar Creates a bar to separate the text. Setting a Tab: Following are the simple steps to set center and right tabs in a word document. You can use similar steps but different tabs to setup decimal and bar tabs. Step (1):  Type some text that you want to line up with tab stops. Press the  Tab  key only once between each column of information you to want to line up. I typed following three lines Step (2):  Select a tab type using  Tab Button , let's say center tab

Microsoft word-office FORMATTING TEXTS Tips and Tricks-9

Borders and Shades in Word 2010 Microsoft Word allows you to place a border on any or all of the four sides of selected text, paragraphs, and pages. You can also add many type of shading to the space occupied by selected text, paragraphs, and pages. This chapter will teach you how to add any of the borders ( left, right, top or bottom) around a text or paragraph or a page and how to add different shadows to them. Add Borders To Text: Following are the simple steps to add border to any text or paragraph. Step (1):  Select the text or paragraph to which you want to add border. You can use any of the text selection method to select the paragraph(s). Step (2):  Click the  Border Button  to display a list of options to put a border around the selected text or paragraph. You can select any of the option available by simply clicking over it. Step (3):  Try to add different borders like left, right top or bottom by selecting different options from the border options.

Microsoft word-office FORMATTING TEXTS Tips and Tricks-8

Set Line Spacing in Word 2010 A line spacing is the distance between two lines in a Microsoft Word document. You can increase or decrease this distance as per your requirement by following few simple steps. This chapter will explain how to set distance between two lines as well as how to set distance between two paragraphs. Spacing between Lines: Following are the simple steps to adjust spacing between two lines of the document. Step (1):  Select the paragraph or paragraphs for which you want to define spacing. You can use any of the text selection method to select the paragraph(s). Step (2):  Click the  Line and Paragraph Spacing Button  triangle to display a list of options to adjust space between the lines. You can select any of the option available by simply clicking over it. Spacing between Paragraphs: You can also set distance between two paragraphs. Following are the simple steps to set this distance. Step (1):  Select the paragraph or paragraphs for

Microsoft word-office FORMATTING TEXTS Tips and Tricks-7

Create Bullets in Word 2010 Microsoft word provides bullets and numbers to put a list of items in a nice order. This chapter will teach you simple steps to create either of the bulleted or numbered lists in simple steps. Create a List from Existing Text: This is very simple to convert a list of lines into a bulleted or numbered list. Following are the simple steps to create either bulleted list or numbered list. Step (1):  Select a list of text to which you want to assign bullets or numbers. You can use any of the text selection method to select the text. Step (2):  Click the  Bullet Button  triangle to display a list of bullets you want to assign to the list. You can select any of the bullet style available by simply clicking over it. Step (3):  If you are willing to create a list with numbers then click the  Numbering Button  triangle instead of bullet button to display a list of numbers you want to assign to the list. You can select any of the numbering styl