Entering Data Using AutoCorrect
When you enter data into a table, Access examines what you type and corrects any common spelling errors it knows about. You can also add your own AutoCorrect values to streamline data entry—for example, you could have Access recognize the abbreviation sarsp and replace it with sarsaparilla. If you find that Access insists on changing a text entry that you know is correct, you can delete a particular AutoCorrect entry. As an example, one of your projects might have the code name AMDE, which Access automatically changes to MADE.
Add Text with AutoCorrect
Open a table in Datasheet view.
Begin typing text in a cell.