Wild card % does not work in MS Access for LIKE SQL statement

Using LIKE statement in an SQL query requires specifying wild cards in the search pattern. In C# .NET, the wild card is %, however if you are building your SQL query directly from MS Access, I found out you need to use ...