Skip to main content

Posts

Showing posts from December, 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
Post a Comment
Read more

Microsoft Excel-office EDITING WORKSHEETS Tips and Tricks-9

Zoom In/Out in Excel 2010 Zoom Slider By default, everything on screen is displayed at 100% in MS Excel. You can change the zoom percentage from 10% (tiny) to 400% (huge). Zooming doesn’t change the font size, so it has no effect on the printed output. You can view the zoom slider at the right bottom of the workbook as shown below. Zoom In You can zoom in the workbook by moving the slider to the right. It will change the only view of the workbook. You can have maximum of 400% zoom in. See the below screen-shot. Zoom Out You can zoom out the workbook by moving the slider to the left. It will change the only view of the workbook. You can have maximum of 10% zoom in. See the below screen-shot. The beginner to advance and start up step-9 Thank you all very much    
Post a Comment
Read more

Microsoft Excel-office EDITING WORKSHEETS Tips and Tricks-8

  Spell Check in Excel 2010 MS Excel  provides a feature of Word Processing program called  Spelling check . We can get rid of the spelling mistakes with the help of spelling check feature. Spell Check Basis Let us see how to access the spell check. To access the spell checker, Choose  Review ➪ Spelling  or press  F7 . To check the spelling in just a particular range,  select the range before you activate the spell checker. If the spell checker finds any words it does not recognize as correct, it displays the  Spelling dialogue  with suggested options. Exploring Options Let us see the various options available in  spell check  dialogue. Ignore Once  − Ignores the word and continues the spell check. Ignore All  − Ignores the word and all subsequent occurrences of it. Add to Dictionary  − Adds the word to the dictionary. Change  − Changes the word to the selected word in the Suggestions list. Change All  − Changes the word to the selected word in the Suggestions list and changes all subs
Post a Comment
Read more

Microsoft Excel-office EDITING WORKSHEETS Tips and Tricks-7

  Find & Replace in Excel 2010 MS Excel  provides  Find & Replace  option for finding text within the sheet. Find and Replace Dialogue Let us see how to access the Find & Replace Dialogue. To access the Find & Replace, Choose  Home → Find & Select → Find  or pressControl  + F Key . See the image below. You can see the  Find and Replace dialogue  as below. You can replace the found text with the new text in the  Replace tab . Exploring Options Now, let us see the various options available under the Find dialogue. Within  − Specifying the search should be in Sheet or workbook. Search By  − Specifying the internal search method by rows or by columns. Look In  − If you want to find text in formula as well, then select this option. Match Case  − If you want to match the case like lower case or upper case of words, then check this option. Match Entire Cell Content  − If you want the exact match of the word with cell, then check this option. The beginner to advance and sta
Post a Comment
Read more

Microsoft Excel-office EDITING WORKSHEETS Tips and Tricks-6

  Copy & Paste in Excel 2010 MS Excel  provides  copy paste  option in different ways. The simplest method of copy paste is as below. Copy Paste To copy and paste, just select the cells you want to copy. Choose  copy option  after right click or press  Control + C . Select the cell where you need to paste this copied content. Right click and select paste option or press  Control + V . In this case,  MS Excel  will copy everything such as values, formulas, Formats, Comments and validation. MS Excel will overwrite the content with paste. If you want to undo this, press  Control + Z  from the keyboard. Copy Paste using Office Clipboard When you copy data in MS Excel, it puts the copied content in Windows and Office Clipboard. You can view the clipboard content by  Home → Clipboard . View the clipboard content. Select the cell where you need to paste. Click on paste, to paste the content. Copy Paste in Special way You may not want to copy everything in some cases. For example, you want
Post a Comment
Read more

Microsoft Excel-office EDITING WORKSHEETS Tips and Tricks-5

  Rows & Columns in Excel 2010 Row and Column Basics MS Excel  is in tabular format consisting of rows and columns. Row runs horizontally while Column runs vertically. Each row is identified by row number, which runs vertically at the left side of the sheet. Each column is identified by column header, which runs horizontally at the top of the sheet. For  MS Excel  2010, Row numbers ranges from  1 to 104857;  in total 1048576  rows, and Columns ranges from  A to XFD;  in total  16384  columns. Navigation with Rows and Columns Let us see how to move to the last row or the last column. You can go to the last row by clicking  Control + Down Navigation arrow. You can go to the last column by clicking  Control + Right Navigation arrow. Cell Introduction The intersection of rows and columns is called  cell . Cell is identified with  Combination of column header and row number . For example − A1, A2. The beginner to advance and start up step-5 Thank you all very much  
Post a Comment
Read more

Microsoft Excel-office EDITING WORKSHEETS Tips and Tricks-4

Move Data in Excel 2010 Let us see how we can  Move Data  with  MS Excel . Step 1  − Select the data you want to Move.  Right Click  and Select the  cut option. Step 2  −  Select the first cell  where you want to move the data. Right click on it and  paste the data . You can see the data is moved now. The beginner to advance and start up step-4 Thank you all very much  
Post a Comment
Read more

Microsoft Excel-office EDITING WORKSHEETS Tips and Tricks-3

Delete Data in Excel 2010 MS Excel  provides various ways of deleting data in the sheet. Let us see those ways. Delete with Mouse Select the data you want to delete.  Right Click  on the sheet. Select the  delete option , to delete the data. Delete with Delete Key Select the data you want to delete. Press on the  Delete Button  from the keyboard, it will delete the data. Selective Delete for Rows Select the rows, which you want to delete with  Mouse click + Control Key. Then right click to show the various options. Select the  Delete option  to delete the selected rows. The beginner to advance and start up step-3 Thank you all very much
Post a Comment
Read more