UMSP Trichoptera Biota© database

Examples

I want to...

• find all specimen records available for a particular species.
  
  
• create a list of lower taxa (specimens to genera) for a higher taxon (species to family).
  
  
• create a list of all species or specimens collected from a particular place.
  
  
• display a list of all male specimens for a given species.

General tips
Structure of the database
Definitions and codes
Tables and fields
Troubleshooting
Examples

Return to Tutorial Main

Access UMSP Trichoptera database

1. Start from the the main search page, click on "Specimens for a Species". In the next window, type the first few letters of the genus name.

2. After clicking "Find", select the species of interest from the list and click "OK".

3. A list of databased specimens for that species, with individual barcode numbers, locality and collection information with appear.

(return to top) 

1. On the main search page, click "Lower taxon for a higher taxa". In the next window, choose the level of the lower taxa you want to find from the higher taxon and type in the higher taxon name.

2. After clicking "Find", a list of the lower taxa will appear.

(return to top) 

1. Using the "Query Editor", choose "Find Records from the LOCALITY Table". Then click "Next Step".

2. In the Search Editor, select "Search All Locality Records" and make sure "Use Locality Auxiliary Field Values to search is UNCHECKED. Click "Next Step".

3. In the next window, you will see a series of popdown menus. In the first row, choose "Country", "is equal to", and then type the country into the blank field. You can add more information to limit your search. For example, if you wanted to find locality records from only a certain state, you would add a second row, with the desired information. Note: the more you limit your search parameters, the fewer possible results will be displayed. To narrow your search, without compromising flexibility in the spelling of names and other fields, use the "contains" command instead of "is equal to".

4. After clicking "Query", a list is displayed containing the localities specified in the search criteria where Trichoptera have been collected, as recorded in the database.Click "Done" to save this list as a record set. Your browser will take you back to the main search page.

5. In the main menu, click Find "Species or Specimens for a locality or collection set". In the next window, choose your desired target list (Collection, Species, or Specimens) and the record set you have created (in this case, Locality). Click "Find".

6. After a little time (please be patient), the list displaying all the species found from that particular locality is displayed. Click "Done" to save it as a species record set.

(return to top) 

1. From the start page, find "Using the Query Editor".On the next window, select "Specimen" from the popdown menu. Click next step.

2. On the next page, select "Search All Specimen Records" and be sure the "Use Specimen Auxiliary Field Values to search" is UNCHECKED. Click "Next Step".

3. In the first row, select "SpeciesCode", "is equal to" and then enter the species code for that species. (The species code consists of the first 4 letters of the genus name followed by the first 4 letters of the species name, eg. Phylholz is the species code for the species Phylloicus holzenthali. If you do not know the species code, you can find it by searching for that species using the "Search lower taxa for a higher taxon".) In the second row, select "And", "StageSex", "contains". and then type in "male".

4. After clicking "Query", the specimen list will be displayed (please be patient).

(return to top)