1	ReferenceUSA National Directory Wm. K. Sanford Town Library http://www.colonie.org/library/ Presented by Richard Naylor, MLS, MBA
2	Getting to the Catalog Internet Start Pages http://www.colonie.org/library/ http://www.uhls.org/UHLS/Databases/index.cfm Click RefUSA Icon Putting in Your Card (remote only) 000001234 (9 digits – all zeros) or 9000012345 (10 digits)
3	Search for a Residence Click <Residential Database> tab Quick Search: Name, City, State Try your Last name, First name, and State Look at entries, Click a name, and look at information Quick Search: Phone: it will search Business too! Try yours or 5184589274 One entry?, Click the name name, and look at information
4	Search for a Business: Quick Click the <Business> tab Quick Search Name, City, State, Phone Try Name=station, State=NY Note that <Station> not always first word Note Linkage: Click the arrow Note Double Linkage: Click the up arrow Click the Name Look at the information Scroll down and look at the officer’s names
5	Search for a Business: Custom (1) Click on “Custom Search” Tab Look at the options Click any you want to search on Most common searches are: Yellow page with geographic limiters Very restrictive address searches Try a Yellow Page/Geographic search Check YP Heading & Zip Code Click “Create Search Form” Click “Search Now” You get a screen from which to choose headings Go to next box ….
6	Search for a Business: Custom (2) Click on the matches in the top two boxes that best meet your needs Note the SIC code translation Headings will move to the bottom “selected box” Click “Search Now” Check the results – does it look right? If not, you may want to redo the search using different terms.
7	Search for a Business by Street On Custom Screen Select “ZIP” and “Address” Click <Create Search Form> Enter for Zip=12205 & for Street=Wolf Click <Search Now> Look over your results Leave the results for the next exercise
8	Saving Data Using the following Search (or make up your own) Zip=12205 & Street=Wolf If you want to save your search you can: Click “ALL” or Check off individual companies Note: There is a limit of 50 per download When done checking (up to 50), Click <Download> Click either “Summary” or “Detailed” Detailed gives you all the data available Click Download Click <SAVE> and choose a place and name Try wolf1_2 and save
9	If You Need More Than 50, … Go to Pages of Checked Choices Click <NONE> to remove all on page Go to next page with checks, Click <NONE> Repeat until you clear all old checks Now go to next desired pages E.g. 3 & 4 and click ALL Repeat rest of the process
10	Opening saved files in Excel Open Excel Click File Open Go to where you saved file, e.g. “Wolf1_2” Change file type to “text files” Choose file you saved and click open
11	Printing Results Using the Search (or any search you want) Zip=12205 & Street=Wolf Click up to 50 records to print: Click “ALL” or Check off individual companies Note: There is a limit of 50 per printing The detailed listing takes quite a bit of space per company. The short list does not include contact name.