The #Soundex algorithm is a phonetic algorithm to describe how words sound, particularly names. It generates identical “codes” for homophone words and thus allows to search for names by their sound.
Many database systems have a built-in Soundex function. Unfortunately, #MsAccess is not one of them. In this video I’ll show an implementation of Soundex in #VBA and explain how to use it in a Microsoft Access database.
The rules of the Soundex algorithm are maintained by the United States National Archives and Records Administration. You’ll find them at: www.archives.gov/research/cen...
Download the sample database I used for this video here: codekabinett.com/download/Nor...
00:00 Intro
00:33 Explaining Soundex
10:00 Soundex in Access and VBA
22:14 Further thoughts on implementation
Негізгі бет Ғылым және технология Using the Soundex Algorithm in Microsoft Access
Пікірлер: 5