Skip to main content

Posts

Showing posts from September, 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 MS EXCEL BASIC Tips and Tricks-2

  Explore Window in Excel 2010 The following basic window appears when you start the excel application. Let us now understand the various important parts of this window. File Tab The File tab replaces the Office button from Excel 2007. You can click it to check the  Backstage view,  where you come when you need to open or save files, create new sheets, print a sheet, and do other file-related operations. Quick Access Toolbar You will find this toolbar just above the  File tab  and its purpose is to provide a convenient resting place for the Excel's most frequently used commands. You can customize this toolbar based on your comfort. Ribbon Ribbon contains commands organized in three components − Tabs  − They appear across the top of the Ribbon and contain groups of related commands. Home, Insert, Page Layout are the examples of ribbon tabs. Groups  − They organize related commands; each group name appears below the group on the Ribbon. For example, group of commands related to fonts
17 comments
Read more

Microsoft Excel-office MS EXCEL BASIC Tips and Tricks-1

  Getting Started with Excel 2010 This chapter teaches you how to start an excel 2010 application in simple steps. Assuming you have Microsoft Office 2010 installed in your PC, start the excel application following the below mentioned steps in your PC. Step 1  − Click on the  Start  button. Step 2  − Click on  All Programs  option from the menu. Step 3  − Search for  Microsoft Office  from the sub menu and click it. Step 4  − Search for  Microsoft Excel 2010  from the submenu and click it. This will launch the Microsoft Excel 2010 application and you will see the following excel window. The beginner to advance and start up step-1 Thank you all very much
Post a Comment
Read more

Microsoft word-office ADVANCED OPERATIONS Tips and Tricks-13

  Set Watermark in Word 2010 A watermark is a picture that shows up faintly behind the text on a word document page. When you drafting a document, you can watermark the document with  Draft Copy  stamp, or you can watermark a duplicate document with  Duplicate  stamp. Microsoft Word allows you to stamp with watermark using simple steps explained in this chapter. Set Standard Watermark: Following are the simple steps to set standard watermark in word document. A standard watermark is the one which is already defined by words and can not modify their font or color etc. Step (1):  Open a word document in which you want to add a watermark. Step (2):  Click the  Page Layout tab  and then click  Watermark  button to display a list of standard watermark options. Step (3):  You can select any of the available standard watermarks by simply clicking over it. This will be applied to all the pages of the word. Assume we select  Confidential  watermark. Set Custom Watermark: Following are the simpl
Post a Comment
Read more

Microsoft word-office ADVANCED OPERATIONS Tips and Tricks-12

Document Security in Word 2010 Microsoft Word provides a high level of security for your word generated documents. You can set a password for a document to stop unauthorized reading and editing of the document or if you want someone just to read the document then you can set editing restriction on your word document. This chapter will teach you how to make your document password protected and restricted from editing and formatting. Set Document Password: Once you set a password for a document then you will be able to open the document only if you know the password. If you lost your password then there is no way to recover it and to open the document. So you need to be careful while setting a password for your important document. Following are the simple steps to set a password for a word document. Step (1):  Open a word document for which you want to set a password. Step (2):  Click the  File tab  and then click  Info  option and finally  Protect Document  button which will display a l
Post a Comment
Read more

Microsoft word-office ADVANCED OPERATIONS Tips and Tricks-11

Compare Documents in Word 2010 Sometime you modify a Microsoft Word document without opening track changing, in such case tracking the changes would become difficult and you would need to compare original document with modified document word by word. But you do not need to compare it manually, Microsoft Word provides an option to compare two documents very easily. Let us see how it can be done. Compare Two Documents: Let us have following two documents (a) Original document (b) Modified version of the same document as follows. Original Document: Modified Document: Following are the simple steps to compare these two documents. Step (1):  Click the  Review tab  and then click  Compare  button which will display two options to be selected. Step (2):  Select  Compare  option simply by clicking over it. This will display an  Compare Documents  dialog box asking two versions of word documents which you want to compare with each other.
Post a Comment
Read more

Microsoft word-office ADVANCED OPERATIONS Tips and Tricks-10

Translate Word 2010 Document Microsoft Word has an option to translate complete word document from one language to another language using simple step. Let us learn how we can translate document content from English to some other language (Spanish). Translate Document Using Microsoft Translator: Following are the simple steps to translate a document from one language to another language. Step (1):  Click the  Review tab  and then click  Translate  button which will display different options to be selected. Step (2):  Select  Choose Translation Language  option simply by clicking over it. This will display a  Translation Language Options  dialog box asking for selecting  from  and  to  languages. Here  From  is the source document's language and  To  is the target document language. Step (3):  After selecting  From Language  and  To Language , click  OK . Now again go to  Review tab  and then click  Translate  button which will display different options t
Post a Comment
Read more

Microsoft word-office ADVANCED OPERATIONS Tips and Tricks-9

Email Documents using Word 2010 Microsoft Word can be used to send a word document in an email as an attachement directly at the given email address without opening your email program. This chapter will teah you simple way of sending email in a variety of formats, including a Word document file (DOC) attachment or a PDF, among others. Mailing Documents: Following are the simple steps to send a word document as an attachement at the given email address. Step (1):  Open the document you want to send using e-mail as an attachement. Step (2):  Click the  File tab  and then click  Save & Send  option from the left most column which will display a number of options to  Save & Send , you would have to select  Send using Email  option available in the middle column. Step (3):  Third column would have various options to send email which allows you to send your document as an attachement in DOC format or you can send your word document in a PDF format. Click a metho
Post a Comment
Read more

Microsoft word-office ADVANCED OPERATIONS Tips and Tricks-8

Printing Documents in Word 2010 Consider you are done with previewing and proofing your document and ready for the final printing. This chapter will teach you how to print a part or complete Microsoft Word document. Printing Documents: Following are the simple steps to print your Microsoft Word Document. Step (1):  Open the document for which you want to see the preview. Next click the  File tab  and then  Print  option which will display a preview of the document in the right column. You can scroll up or scroll down your document to walk through the document using given  Scrollbar . Middle column gives various options to be set before your send your  document to the printer. Step (2):  You can set various other printing options available. Select from among the following options, depending on your preferences. SN Option and Description 1 Copies Set the number of copies to be printed, by default you will have one copy of the document. 2 Print Custom Ran
Post a Comment
Read more

Microsoft word-office ADVANCED OPERATIONS Tips and Tricks-7

Preview Documents in Word 2010 When you are ready for printing your word document, it is always recommended to preview the document before your send document for final printing. During preview of the document you might discover that set margin is not appropriate or many items may not look good after printing so better to fix them after having a preview of the document. You can also have the option to specify which pages to print, select a printer, specify the paper size on which you want to print, and set other printing options. Preview Documents: Following are the simple steps to preview your Microsoft Word Document. Step (1):  Open the document for which you want to see the preview. Step (2):  Click the  File tab  and then  Print  option which will display a preview of the document in the right column. You can scroll up or scroll down your document to walk through the document using given  Scrollbar . In next chapter, we will learn how to print the previewed docum
Post a Comment
Read more

Microsoft word-office ADVANCED OPERATIONS Tips and Tricks-6

Create Table of Contents in Word 2010 A table of contents (or TOC) is a list of the headings in the order in which they appear in the document. You can set a list of headings which should be part of table of contents. Let us learn how to create a Table of Contents. A table of content helps in navigating a word document by providing associated page numbers and direct links to various headings available on those pages. Create Table of Contents: Following are the simple steps to create Table of Contents in your Microsoft Word using various levels of headings. Step (1):  Consider a document having different levels of headings. Step (2):  You can insert a table of content anywhere in the document, but the best place is always at the beginning of the document. So bring your insertion point at the beginning of the document and then click the  References tab  and next  Table of Content  button which will display a list of Table of Contents options. Step (3):
Post a Comment
Read more