The fastest way to search your database is to enter a keyword in either the Keyword text box on the database Quick Search screen and clicking on the DISPLAY DATA button or in the Quick search text box on the database Search Results screen and pressing the Enter⁄Return key. On the other hand, you can focus your search to select records in your database based on the information within your database and you don't have to be a database wizard to use the Relevant Tools online database advanced search function.
To begin the process, click on DATABASES, at the top of the screen. Next, select the database you would like to search in the Databsase Selection section, in the lower portion, of the screen. Finally, click on Search, at the top of the screen.
The Advanced Search screen should now be displayed on your screen, as shown below. For now, leave the Search scope and Search mode radio buttons with their default selections.
To continue the process, select the first field from the top pull-down menu that you would like to use in the search criteria. We have selected the State or Provience as the field for this example, as shown in the image below.
Next, select the type of search you would like to preform. For this example, we have selected is equals to so we can find all of the exact matches for the State or Provience field, as shown in the image below.
Finally, enter a keyword value in the search field text box and click on DISPLAY DATA. For this example, we are looking for all records that contain the search term CA in the State or Provience field, as shown in the image below.
After clicking on DISPLAY DATA, the Search Results screen is displayed. For our example, as shown in the image below, all the records from the state CA in our database are displayed.
If we wanted to, we could restrict our search further and target all of the records, in the database, that are within the city of San Rafael from the state of CA. To accomplish this, all we have to do is return to the advanced search screen and add another field to the Search Criteria for the previous search. In this case, use the pull-down menu under the Start or Provience and select the City field, as shown below. Next, leave the pull-down menu with the word contains alone. Finally, enter San Rafael in the text box and click on DISPLAY DATA button. Just so you know, the contains search type is very similar to is equal to; however, it's a little more flexible.
In the Search Results of our second search, all of the records from the city of San Rafael in the state of CA, are displayed in the image below.
In summary, every time an additional field is added to the Search Criteria the search is further restricted by the additional field definitiion in the Search Criteria.