what SQL statement can i use to Search a database (MS Access) if a record exist or not, From a Dialog Box Application link to MS Access using the control botton and and Edit Box

i.e Edit control will take the Name or record to search then the Command Button as where the functions stays for searching the database if the Name or record exist or not.