Search

1. Type the word or name on which you want to search, in the relevant entry field. You may also provide just a partial word, or leave fields empty; as long as at least one value is filled in, you can start the search. Note that a submitted word will only be searched in the relevant field in the database. You can enter multiple words, separated by spaces (then all words must occur in a result).
   
   
2. Behind the Sort by and Sort order options you can choose if you would like the search result to be sorted at all (ascending or descending), and if so, on which field. This is especially handy if your search generates a lot of results. Just mark the relevant Sort by/Sort order radio button by clicking it.
   
   
3. Click the Search button to start the search. Use the Clear button to erase all entry fields here, for a new search.

Expert search

If you have a lot of experience searching databases, and you want to submit complex search statements, then Expert search might be the appropriate search method for you. 

Click the Expert search button in the column on the left, to be able to search on multiple words and combine the search statements through Boolean operators, on the Search tab. 

1. In the drop-down list you must choose a field in which you want to search.
   Depending on the field type, you can sometimes choose another operator than “=” in the drop-down list directly to the right of it (although this list isn't always visible). In that case (e.g. for the Year field), a drop-down list is available in which you can also choose “Between”, “>” (greater than), “<” (smaller than), “<=” (smaller than or equal to) and “>=” (greater than or equal to). You can use these to search on years after 1945, or before 1970 for example. In the entry field next to the operator, type the word, number or name on which you want to search. You may also provide just a partial word, in such a case you search truncated, as we call it; then mark the Truncation checkbox. If the term you enter is already a whole word, e.g. “table”, and you don’t want the search to extend to words like “tablespoon”, then you must deselect this option.
   
   
2. To extend this search statement, click the + sign behind the search line. Now you can enter a second search statement. You have to combine the two search statements with a Boolean operator. For this purpose, at the end of this line a drop-down list is present. From this list, choose either “and”, “or”, or “and not”. With “and” a result must comply to both search lines, with “or” a result must comply to at least one of both search lines, and with “and not” a result must comply to the first search line but not to the second. The search statements are executed from top to bottom. This is important when you combine search statements. The result of the first two lines will be combined with the third line, and the result thereof in turn will be combined with the fourth line, etc. So, place the combined search statement that has to be executed first, at the top.
   
   
3. You may also leave lines empty or remove them by clicking the – sign at the end of the relevant line; as long as at least one value is filled in, you can start the search.
   
   
4. Behind the Sort by and Sort order options you can choose if you would like the search result to be sorted at all (ascending or descending), and if so, on which field. This is especially handy if your search generates a lot of results. Just mark the relevant Sort by/Sort order radio button by clicking it.
   
   
5. Click the Search button to start the search.
   
   
6. Use the Clear button to erase all entry fields here, for a new search.