Monday, July 28, 2014

How To Entering Data Accurately with AutoCorrect in Access 2003

How To Entering Data Accurately with AutoCorrect in Access 2003

As you enter data in tables, you might occasionally make typing mistakes. For certain errors, Access will correct the errors as soon as you type them and then press the Spacebar or Enter. For example, if you type compnay when you meant to type company, the AutoCorrect feature will correct the error automatically. You can easily customize the preset AutoCorrect options or add errors that you commonly make to the list of AutoCorrect entries.

Set AutoCorrect Options

graphics/1_icon.jpg
Click the Tools menu, and then click AutoCorrect Options.
graphics/2_icon.jpg
Select the Replace Text As You Type check box to enable AutoCorrect.
graphics/3_icon.jpg
Select or clear the Show AutoCorrect Options Buttons check box to show or hide it.
graphics/4_icon.jpg
Select the check boxes with the additional options you want.
  • Correct two initial capital letters so that only the first letter is capitalized.
  • Always capitalize the first word in a sentence.
  • Capitalize the names of days.
  • Correct accidental use of the Caps Lock key.
graphics/5_icon.jpg
Click OK.
graphics/05inf06.jpg

Replace Text as You Type

  • To correct incorrect capitalization or spelling errors automatically, simply continue to type and AutoCorrect will make the required correction.

Examples of AutoCorrect Changes

Type of Correction
If You Type
AutoCorrect Inserts
Capitalization
CAlifornia
California
Capitalization
thursday
Thursday
Common typos
accommodate
accommodate
Common typos
can;t
can't
Common typos
windows
windows

Change Correction as You Type

graphics/1_icon.jpg
After an AutoCorrect correction, point to the AutoCorrect Options button.
graphics/2_icon.jpg
Click the AutoCorrect Options button.
graphics/3_icon.jpg
Click any of the following options:
  • Change Back To.
  • Stop Automatically Correcting.
  • Control AutoCorrect Options to change the AutoCorrect settings.
graphics/05inf07.jpg

Add or Edit an AutoCorrect Entry


graphics/1_icon.jpg
Click the Tools menu, and then click AutoCorrect Options.
graphics/2_icon.jpg
To edit an entry, select the entry you want to change.
graphics/3_icon.jpg
To add an entry, type a word or phrase that you often mistype or misspell.
graphics/4_icon.jpg
Type the correct spelling of the word.
graphics/5_icon.jpg
Click Add or Replace.
graphics/6_icon.jpg
Click OK.
graphics/05inf08.jpg