START Search! -  Tutor Home -  How To Get In! -  Interactive Help -  Form Details -  Examples

Detailed Instructions:

The search form has a number of fields where search values can be entered. Below is a copy of the search screen. Additional details about the search values are in the yellow bars above each search screen option row. More details are available on separate pages. Most fields can be left blank if you do not wish to use them for search criteria.

Main header shows 31,148 records in the Source database
Search : Media Sources DB (31148 entries)
Subheader shows current user's login name (Jo-D) and search privledges (Administrator)
Jo-D   role:Administrator
The row below allows you to search on any field in the database! First click on the field pulldown ( SourceName ) to select the field. The next field ( contains ) allows you to search for text in selected field, search for blank fields ( is null ) or search for any non-blank fields ( is not null ). Enter the text your looking for in the last field.
SourceName mediaID MediaType Address State ZipPC ZipFour Province GAC Location Ph_area Ph_number Fax_area Fax_number Email WebsiteUrl FeedbackUrl ForumUrl Notes Warning Copyright Ranking Circulation Frequency Readership Editor Network Rating Alias Test Any Field	contains is null is not null	PhraseAll wordsAny wordsRegexp
The row below allows you to search for sources by location. You can take the default distance ( Nearest ) or specify the distance ( Near ) from a city/state or zip code. NEAR: The first column in the Near row allows you to specify the distance from a city/state or zip code. Type the number of miles or kilometers in next text box ( blank ). The pulldown ( miles ) lets you specify miles or kilometers. NEAREST: If you leave the miles/kilometers text box blank the search will default to 50 miles. The next column allows you to specify a target. Enter a city/state or zip code in the space provided.
Near	within outside of miles kilometers of	city, state/prov. , or zip code
Nearest	to
Sources are also organized by media type which allows you to list all records within a media type. Click the pulldown arrow to select a media type to search on. Scan through our media type listing to view all media types.
MediaType	equals	any newspapers any print media any broadcast any radio Newspaper Daily Newspaper Weekly Newspaper Magazine Radio Radio, AM Radio, FM Radio, Internet Radio, Shortwave Radio, Simulcast, Mixed Mode Television
The row below allows you to search for source information from our location list. Click the pulldown to view/select a location.
Location	equals	IS NULL A Wire Service Alabama Alaska Alberta Arizona Arkansas Asia Australia Bahamas Bahrain Bangladesh Barbados Bermuda Botswana Brazil British Columbia Bulgaria California Cameroon Canada Cayman Islands China Colombia Colorado Connecticut Cuba Cyprus Czech Republic Delaware Denmark District of Columbia Ethiopia Europe Fiji Finland Florida France Gambia Georgia Germany Ghana Guam Guatemala Hawaii Hungary Idaho Illinois India Indiana Indonesia International Iowa Iran Ireland Israel Jamaica Japan Kansas Kentucky Kenya Korea Kuwait Latin America Lebanon Liberia Louisiana Luxembourg Maine Malaysia Malta Manitoba Mariana Islands Maryland Massachusetts Mexico Michigan Minnesota Mississippi Missouri Montana Namibia Nebraska Nepal Netherlands Netherlands Antilles Nevada New Brunswick New Guinea New Hampshire New Jersey New Mexico New York New Zealand Newfoundland Nigeria North Carolina North Dakota Northwest Territories Norway Nova Scotia Nunavut Ohio Oklahoma Oman Ontario Oregon Pakistan Papua New Guinea Pennsylvania Philippines Poland Prince Edward Island Quebec Rhode Island Russia Rwanda Saskatchewan Saudi Arabia Singapore South Africa South Carolina South Dakota Spain Sri Lanka Sweden Switzerland Taiwan Tanzania Tennessee Texas Thailand Trinidad Uganda United Arab Emirates United Kingdom United States Utah Vermont Virgin Islands Virginia Washington West Virginia Western Samoa Wisconsin Wyoming Yemen Yukon Territory Zambia
As records are entered into our database they receive a database ID. The row below allows you to search for a specified database ID
mediaID	equals
The row below allows you to specify how the search results will be sorted. Leaving the field blank will default to alphabetical listing. The other choices are zip code and circulation size.
sort results	by	area code circulation
The row below allows you to specify the detail of the search results. Click the pulldown to select from low, medium or high detailed listings.
Detail	Low Medium High