Using AutoCorrect

Most people think about using AutoCorrect in Microsoft Word to fix typos.…But in Access you can creatively use it to create shortcuts for data you type in repeatedly.…For example, let's say you constantly have to type in the same city, product, or…company when you enter records.…Instead of entering it in full over and over and over again, you can type in an…abbreviation and the full text will appear automatically.…To set this up click on the Office button and then on Access options, click on…Proofing and then on AutoCorrect Options.…

A window will open up with a list of common typos.…But instead of entering typos, we are going to enter in an abbreviation and the full text.…Let's say you enter San Francisco for the city on a regular basis.…Click in the Replace box and type SanF and we will replace it with San Francisco.…Then click the Add button.…Do note that capitalization matters.…Also, if the letter combination that I choose is something that occurs naturally…during regular typing, you should choose an abbreviation that you're not likely…

Resume Transcript Auto-Scroll

Author

Released

2/8/2011

In Access 2007 Power Shortcuts, Access expert Alicia Katz Pollock shares hundreds of tips and shortcuts to vastly increase efficiency and get the full power out of Access 2007. The course includes tips for working with the Ribbon and Quick Access toolbar, managing files, customizing and automating Access, rapid data entry and editing, working with tables, queries, forms, and reports, managing your database, and much more. Exercise files accompany the course.