Skip to main content

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 Excel-office ADVANCED OPERATIONS Tips and Tricks-13

Translate Worksheet in Excel 2010

Translate Worksheet

You can translate the text written in a different language, such as phrases or paragraphs, individual words (by using the Mini Translator), or translate your whole file with MS Excel 2010.

Translation is available in the review tab of the ribbon in MS Excel 2010. You can quickly translate cell into different language with this option.

Performing Translation Step By Step

  • Select the content, which you want to translate to a different language.

  • Choose review tab » translation.

  • It will open the pane from which you can select the language to which you need to translate.

  • You need to have an internet connection for performing translation. It will translate using the Microsoft Translator.

  • Click on Insert to apply translation changes.

 

The beginner to advance and start up step-13





Thank you all very much

Comments