GCFLearnFree.org

Every day I fall a little more in love with your site.”

Online Learner

GCFGlobal.org
Creating Opportunities For A Better Life.®
  • All Topics
  • Access 2003
  • Editing and Deleting Table Records

Access 2003

Single page view print copy

Editing and Deleting Table Records

Check the spelling of data

Spelling data correctly in Microsoft Access is essential. Sloppy data entry work—the customer name Smithsson is mistakenly typed when the name is actually Smithson—can potentially leave a contact out of future queries or reports. The Spelling Check feature searches for spelling errors in a table, form, or query. In a table, Spelling Check specifically checks the spelling of records, fields, or text within a field.

To check spelling in a table:

  • Click the Spelling button, choose ToolsSpelling from the menu bar, or press the F7 shortcut key. The Spelling dialog box opens.

    Spelling Dialog Box
  • Access provides an alert whenever a word is found that is not in the dictionary file. The unrecognized word is displayed in the Not in Dictionary text box.
  • Correct the word by performing one of the following actions:
    • Type the correct word in the Change To field
    • Click the Ignore button to ignore the change and move to the next word
    • Highlight the correct word from a list of Suggestions and click the Change button
    • Click the Add to add the word to the custom dictionary
  • A notification dialog box is opened when Access completes the spelling check. Click the OK button to close the dialog box.

    Spelling Check Completed Notification
previous next
previous 1 2 3 4 5 6 7 8 9 next
Terms Of Use

©1998-2014 Goodwill Community Foundation, Inc. All rights reserved.