You want to look for John Smith in your table emp.
Wouldn't it be great if you just opened a table in a search mode where you have the possibility to enter the terms you are looking for in a form representing all columns of the current selected table?
That would be a bit like the Quickfinder is now, but for values in columns within a specified table.
For example, type 'Smi%' in a field labeled with "Name" as Name is one column of the selected table and get
the result, instead of typing "select * from emp where name like 'Smi%';"