so just use WHERE FullName = [Input here:];
tell your users to put John* in the box.
if you want the second approach, you need "dynamic building of sql string", which is not available in access, only in SQL Server.
2. IIRC, Access does not support *John*. It only allows John* (or maybe *John ?). Only SQL server support the form %John%