Relevant Tools

Digital Marketing Services: Databases – Advanced Search

Target your List with Advanced Database Search

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.

Advanced Database Search Field

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.

Advanced Database Search Field

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.

Advanced Database Search Type

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.

Advanced Database Search Value

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.

Advanced Database Search Results

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.

Advanced Database Search Two

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.

Advanced Database Search Results Two

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.