Compact and repair an Access file

1. If you are compacting a shared Microsoft Access database that is located on a server or shared folder, make sure that no one else has it open.
2. On the Tools menu, point to Database Utilities, and then click Compact and Repair Database/Project.

Insert a check mark or tick symbol MS Word

Resources:

• http://office.microsoft.com/en-gb/word-help/insert-a-check-mark-symbol-HA102684025.aspx

You can easily insert a check mark symbol in your Word documents and Excel workbooks. The Wingdings® font that most Microsoft Windows® users have installed enables you to choose between several symbols that can be used as a check mark. The most common symbols include:

   

In this article / What do you want to do? / I want to

• Insert a symbol by using the Symbol command
• Insert a symbol by using its character code
• Insert a symbol in Word by using AutoCorrect

Insert a symbol by using the Symbol command

1. On the Insert tab, in the Symbols group, click Symbol.
2. In the Symbol dialog box, on the Symbols tab, in the Font box, click Wingdings.
3. Scroll to the bottom of the list, where you will find several common check mark symbols. Double-click the symbol that you want.

 TOP OF PAGE

Insert a symbol by using its character code

You can also use the character code of the symbol as a keyboard shortcut. For example, to insert the check mark symbol, change the font to Wingdings, and then press and hold ALT while typing 0252 on the numeric keypad.

 NOTE   You must use the numeric keypad and not the keyboard to type the numbers. Make sure that the NUM LOCK key is on if your keyboard requires it to type numbers on the numeric keypad.

SYMBOL	CHARACTER CODE
	ALT+0251
	ALT+0252
	ALT+0253
	ALT+0254

Make sure you change the font to your previous font after inserting the symbol.

 TOP OF PAGE

Insert a symbol in Word by using AutoCorrect

AutoCorrect requires that you first define the AutoCorrect text and symbol.

1. On the Insert menu, click Symbol, and then click the Symbols tab.
2. In the Font box, click Wingdings, and then scroll to the bottom of the list.
3. Select the symbol that you want, and then click AutoCorrect.

The selected symbol will automatically appear in the With box.

4. In the Replace box, type a word or phrase that you want to associate with the check mark symbol — for example, type check1.
5. Click Add.
6. Click OK.
7. In your documents, when you want to use the check mark symbol that you just defined, type the replace word that you used in step 4.

MS Excel: Take input day only from one cell and add month and year automatically

B16 is the cell where I would give the input and make the font color to white so that it is not visible and set this formula to any other cell where full date will be displayed.

=IF(B16<>"", TEXT(B16 & "/08/2012","dd/mm/yyyy"), "")