Fix Typos with Field Substitution, Update Queries

In this tutorial, I will show you how to handle field value substitutions in Microsoft Access to manage and correct misspelled entries without restricting user input. We'll explore how to create a standardized list for data such as country names, while still allowing for freeform input. You'll learn how to set up a country table to correct common misspellings like "US" to "USA," and how to create an update query to automate these corrections. This video offers practical solutions for improving data consistency when users enter non-standard spellings in databases.

Brandon from Torrance, California (a Platinum Member) asks: I have a bunch of country names spelled wrong in my Customer table. Is there an easy way to fix them without forcing users to choose from a set list? I still want people to be able to type in whatever they want since I don't want to keep a complete list of all the countries.

Prerequisites

• Default Country
• Relationships
• Update Queries
• Outer Joins

Up Next

• Field Value Substitutions, Part 2

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Access, field value substitutions, automatic value correction, common misspellings replacement, user data standardization, typo correction, customer table update, country names spell check, data entry error handling, advanced queries, update query, database relationships, freeform text standardization, expert level Access tutorial, action queries, database standardization techniques