Target your List with Advanced Database Search
The fastest way to search your database is to enter what you are looking for in either the "Keyword:" text box on the database "Quick Search" screen or the "Quick search:" text box on the database "Search Results" screen and click on "Display Data". However, you can focus your search to reach the people you want using the information in 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 the Database icon, at the top of the screen. Then, select the database you would like to search in the Databsase Selection section, in the middle of the screen. Finally, click on Advanced Search, at the top of the screen; you will be presented with the "Advanced Search/Sort" screen, as shown below. For now, leave the radio buttons "Search scope" and "Search mode" with their default selections of "Entire database" and "AND", respectively. To continue the process, select the first field you would like to perform the search on from the top pulldown menu list of fields. We have selected the "State" 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 field, as shown in the image below.
Finally, enter a value in the search field text box and click on "Display Data". For this example, we are looking for all records that contain the word "California" in the State 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 California in our database are displayed.
We could, if we wanted to, focus our search further and target all of the women in our database from the state of California. 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, our database uses a checkbox field for male or female; so, the search will be for all records where the field Female "contains" the value of "x". The "contains" search type is very similar to "is equal to" but it is a little more flexible.
The results of our second search: all of the women in our database from the state California, are displayed in the Search Results screen image below.
However, we could target our search even further by adding an additional search criteria to our search; for example, an age range and interest.
The results of our last search: Women between the ages 35-44 who live in California and are interested in bicycling, are displayed in the Search Results screen image below.