Preventative Measures to Avoid Access Database Corruption

Corruption of MS Access database is deemed an unavoidable issue. However, at times with a little knowledge of ‘how-to repair’ database corruption, you can repair your database and recover data. But, this is not always true. In case of severe Access database corruption, only professional Access database recovery tools can do the needful for you. Since these tools too are expensive options and need rebuilding, replacing, or reentering data, they are not always very appropriate resolutions. A more productive approach

» Read more

Outlook – Arrange Email in Conversation / Thread

In the Microsoft outlook default sort order or email arrangement is Date wise. But you can change the sort order on from, subject, sent date /receive date categories many others. Many of us think how can we set the outlook email arrangement in conversation or thread like Gmail. In this post we will see how to arrange or mange your outlook emails in conversation/Thread. Go to Menu Bar -> View -> Arrange By -> Click Conversation. After the above mentioned

» Read more

Outlook 2007 – Managing email messages with Rules

Microsoft Outlook provides a really useful feature as “Rules and Alerts” for managing emails messages. What is Rule? One or more automatic actions taken on e-mail messages and meeting requests that meet certain conditions, along with any exceptions to those conditions. Rules are also referred to as filters. Rules help you manage your e-mail messages by performing actions on messages that match a specific set of conditions. After you create a rule, Microsoft Outlook applies the rule when a message

» Read more

Excel – VLOOKUP Function – Search the data value in large excel sheet

VLOOKUP function is very useful function if you are dealing with large excel sheet. With the help of this function one can search/find the data value from one or more columns. The V in VLOOKUP stands for vertical. Syntax: VLOOKUP (lookup_value, table_array, col_index_num, range_lookup) Let‘s take a simple example to understand VLOOKUP function Say we have two columns as We need to search/find each data value of column B in the all the data value of Column A So here

» Read more

Excel – Compare data of two different columns – IF Function

Sometime we need to compare the data of two different columns in excel. Here is very simple solution with the help of IF Function. Syntax: IF (logical_condition, value_if_true, value_if_false) Example: Say we have two columns as Now we can use the IF function as IF (A1=B1, TRUE, FALSE) According to our IF condition if the data value of column A and column B are equal/matched then “True” value will be displayed in the  Column C otherwise “False” will be displayed.

» Read more

Outlook 2007 – Delay the delivery of a single email message

With the help of this feature, you can delay the delivery of an individual e-mail message by having them held in the Outbox for a specified time after you click Send. In the message Go to the Options tab Under the More Options group, Click on the Delay Delivery Message Options dialog box will open Under Delivery options, select the Do not deliver before check box, and then click the delivery date and time that you want. After you click

» Read more

Outlook 2007 – Add Tracking to E-mail Message

Email tracking is feature with the help that you can track your email (i.e. whether your email message was delivered to the recipient’s mailbox or recipient opens your email message.) There are two options for email tracking Delivery Receipt Read Receipt A delivery receipt tells you that your e-mail message was delivered to the recipient’s mailbox, but not whether the recipient has seen it or read it. Read receipt tells you that your message has been opened. In both cases,

» Read more

Office 2007 – How to create watermarks in Word 2007

Watermarks are used to print text or a graphic behind document text. Watermarks are transparent, and therefore any text or inserted object printed over a watermark is clearly visible. So, here will see how we can place watermarks on our Word documents in MS Word 2007? Start Word Go to Page Layout Menu Click the Watermark command in the Page Background group It shows a window with different watermark templates as: Confidential, Do Not Copy, Draft, Sample, Urgent, ASAP etc.

» Read more