You can search for records that match any of the words or search criteria you enter.
When you open a table, the bottom of the screen will have two new tabs, one for adding new records and one for viewing records. Choose the browse tab and you should see a search icon.
Clicking on the search icon will bring up the search wizard. You can build a simple field specific search by choosing a field of interest and specifying a value that you are looking for. Click Add and Done
You can build complex queries that include wild card searches and logical expressions using the search wizard. Here is an example that is search for a person called jack, who lives in california OR has the email address as jjack@nowhere.com
Wildcard searches: use * in the search value to match any text that contains the specified expression, example Califor* will match california, californication ...etc