Skip to main content

Posts

Showing posts from February, 2021

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 Excel-office FORMATTING WORKSHEETS Tips and Tricks-5

  Insert Page Break in Excel 2010 Page Breaks If you don’t want a row to print on a page by itself or you don't want a table header row to be the last line on a page. MS Excel gives you precise control over  page breaks . MS Excel handles page breaks automatically, but sometimes you may want to force a page break  either a vertical or a horizontal one . so that the report prints the way you want. For example, if your worksheet consists of several distinct sections, you may want to print each section on a separate sheet of paper. Inserting Page Breaks Insert Horizontal Page Break  − For example, if you want row 14 to be the first row of a new page, select cell A14. Then choose  Page Layout » Page Setup Group » Breaks » Insert Page Break . Insert vertical Page break  − In this case, make sure to place the pointer in row 1. Choose  Page Layout » Page Setup » Breaks » Insert Page Break to create the page break. Removing Page Breaks Remove a page break you’ve added  − Move the cell poin
Post a Comment
Read more

Microsoft Excel-office FORMATTING WORKSHEETS Tips and Tricks-4

  Header and Footer in Excel 2010 Header and Footer A header is the information that appears at the top of each printed page and a footer is the information that appears at the bottom of each printed page. By default, new workbooks do not have headers or footers. Adding Header and Footer Choose Page Setup dialog box » Header or Footer tab. You can choose the predefined header and footer or create your custom ones. &[Page]  − Displays the page number. &[Pages]  − Displays the total number of pages to be printed. &[Date]  − Displays the current date. &[Time]  − Displays the current time. &[Path]&[File]  − Displays the workbook’s complete path and filename. &[File]  − Displays the workbook name. &[Tab]  − Displays the sheet’s name. Other Header and Footer Options When a header or footer is selected in Page Layout view, the  Header & Footer » Design » Options  group contains controls that let you specify other options − Different First Page  − Check this
Post a Comment
Read more

Microsoft Excel-office FORMATTING WORKSHEETS Tips and Tricks-3

  Page Orientation in Excel 2010 Page Orientation Page orientation refers to how output is printed on the page. If you change the orientation, the onscreen page breaks adjust automatically to accommodate the new paper orientation. Types of Page Orientation Portrait  − Portrait to print tall pages (the default). Landscape  − Landscape to print wide pages. Landscape orientation is useful when you have a wide range that doesn’t fit on a vertically oriented page. Changing Page Orientation Choose Page Layout » Page Setup » Orientation » Portrait or Landscape. Choose File » Print. The beginner to advance and start up step-3 Thank you all very much
Post a Comment
Read more

Microsoft Excel-office FORMATTING WORKSHEETS Tips and Tricks-2

  Adjust Margins in Excel 2010 Margins Margins are the unprinted areas along the sides, top, and bottom of a printed page. All printed pages in MS Excel have the same margins. You can’t specify different margins for different pages. You can set margins by various ways as explained below. Choose Page Layout » Page Setup » Margins drop-down list, you can select Normal, Wide, Narrow, or the custom Setting. These options are also available when you choose  File » Print. If none of these settings does the job, choose Custom Margins to display the Margins tab of the Page Setup dialog box, as shown below. Center on Page By default, Excel aligns the printed page at the top and left margins. If you want the output to be centered vertically or horizontally, select the appropriate check box in the Center on Page section of the Margins tab as shown in the above screenshot. The beginner to advance and start up step-2 Thank you all very much
Post a Comment
Read more

Microsoft Excel-office FORMATTING WORKSHEETS Tips and Tricks-1

  Sheet Options in Excel 2010 Sheet Options MS Excel provides various sheet options for printing purpose like generally cell gridlines aren’t printed. If you want your printout to include the gridlines, Choose  Page Layout » Sheet Options group » Gridlines » Check Print . Options in Sheet Options Dialogue Print Area  − You can set the print area with this option. Print Titles  − You can set titles to appear at the top for rows and at the left for columns. Print  − Gridlines  − Gridlines to appear while printing worksheet. Black & White  − Select this check box to have your color printer print the chart in black and white. Draft quality  − Select this check box to print the chart using your printer’s draft-quality setting. Rows & Column Heading  − Select this check box to have rows and column heading to print. Page Order  − Down, then Over  − It prints the down pages first and then the right pages. Over, then Down  − It prints right pages first and then comes to print the down p
Post a Comment
Read more

Microsoft Excel-office FORMATTING CELLS Tips and Tricks-9

  Apply Formatting in Excel 2010 Formatting Cells In MS Excel, you can apply formatting to the cell or range of cells by  Right Click » Format cells » Select the tab . Various tabs are available as shown below Alternative to Placing Background Number  − You can set the Format of the cell depending on the cell content. Find tutorial on this at MS Excel - Setting Cell Type. Alignment  − You can set the alignment of text on this tab. Find tutorial on this at MS Excel - Text Alignments. Font  − You can set the Font of text on this tab.Find tutorial on this at MS Excel - Setting Fonts. Border  − You can set border of cell with this tab.Find tutorial on this at MS Excel - Borders and Shades. Fill  − You can set fill of cell with this tab. Find tutorial on this at MS Excel - Borders and Shades. Protection  − You can set cell protection option with this tab. The beginner to advance and start up step-9 Thank you all very much
Post a Comment
Read more

Microsoft Excel-office FORMATTING CELLS Tips and Tricks-8

 Borders and Shades in Excel 2010 Apply Borders MS Excel enables you to apply borders to the cells. For applying border, select the range of cells  Right Click » Format cells » Border Tab » Select the Border Style . Then you can apply border by Home Tab » Font group » Apply Borders. Apply Shading You can add shading to the cell from the  Home tab » Font Group » Select the Color . The beginner to advance and start up step-8 Thank you all very much  
Post a Comment
Read more

Microsoft Excel-office FORMATTING CELLS Tips and Tricks-7

  Merge & Wrap in Excel 2010 Merge Cells MS Excel enables you to merge two or more cells. When you merge cells, you don’t combine the contents of the cells. Rather, you combine a group of cells into a single cell that occupies the same space. You can merge cells by various ways as mentioned below. Choose  Merge & Center control  on the Ribbon, which is simpler. To merge cells, select the cells that you want to merge and then click the Merge & Center button. Choose  Alignment tab  of the Format Cells dialogue box to merge the cells. Additional Options The  Home » Alignment group » Merge & Center control  contains a drop-down list with these additional options − Merge Across  − When a multi-row range is selected, this command creates multiple merged cells — one for each row. Merge Cells  − Merges the selected cells without applying the Center attribute. Unmerge Cells  − Unmerges the selected cells. Wrap Text and Shrink to Fit If the text is too wide to fit the column widt
Post a Comment
Read more

Microsoft Excel-office FORMATTING CELLS Tips and Tricks-6

  Text Alignments in Excel 2010 If you don’t like the default alignment of the cell, you can make changes in the alignment of the cell. Below are the various ways of doing it. Change Alignment from Home Tab You can change the Horizontal and vertical alignment of the cell. By default, Excel aligns numbers to the right and text to the left. Click on the available option in the Alignment group in Home tab to change alignment. Change Alignment from Format Cells Right click on the cell and choose format cell. In format cells dialogue, choose Alignment Tab . Select the available options from the Vertical alignment and Horizontal alignment options. Exploring Alignment Options 1. Horizontal Alignment  − You can set horizontal alignment to Left, Centre, Right, etc. Left  − Aligns the cell contents to the left side of the cell. Center  − Centers the cell contents in the cell. Right  − Aligns the cell contents to the right side of the cell. Fill  − Repeats the contents of the cell until the cell’
Post a Comment
Read more