Copyright: Quikthinking Zip Codes Help, Version 4.0


Quikthinking Zip Codes Help

Quikthinking Zip Codes is a complete database of all of the 5 digit USA Zip Codes.  To Learn how to use Help, press F1, or select How to use Help from the Help Menu.

How to Use Quikthinking Zip Codes:

Searching the database

Updating entries

References:

Area Codes

State Abbreviations

Command Buttons

Menu Items

United States Postal Service ZIP + 4 Code Lookup


Quikthinking Zip Codes Help Index

Area Codes

Command Buttons

Menu Items

Searching the database

State Abbreviations

United States Postal Service ZIP + 4 Code Lookup

Updating entries


Updating entries

The Quikthinking Zip Codes database contains over 40,000+ entries representing all of the USA zip codes.  We recommend that you upgrade the information in the database each year so it remains current.  Obtain an update directly from Quikthinking Software (www.quikthinking.com).  The database can be modified in any database manager that is compatible with the dBase file format.  Reindex the database file (qzipw.dbf) if you make changes with a database manager.  Reindexing the large database will take approximately one hour using a 33 MHz 486 PC or about 10 minutes with a 100 MHz Pentium.


Area Codes

201 - NJ	301 - MD	401 - RI	501 - AR	601 - MS	701 - ND	801 - UT	901 - TN
202 - DC	302 - DE	402 - NE	502 - KY	602 - AZ	702 - NV	802 - VT	902 - NS
203 - CT	303 - CO	403 - AB	503 - OR	603 - NH	703 - VA	803 - SC	903 - TX
204 - MB	304 - WV	404 - GA	504 - LA	604 - BC	704 - NC	804 - VA	904 - FL
205 - AL	305 - FL	405 - OK	505 - NM	605 - SD	705 - ON	805 - CA	905 - ON
206 - WA	306 - SK	406 - MT	506 - NB	606 - KY	706 - GA	806 - TX	906 - MI
207 - ME	307 - WY	407 - FL	507 - MN	607 - NY	707 - CA	807 - ON	907 - AK
208 - ID	308 - NE	408 - CA	508 - MA	608 - WI	708 - IL	808 - HI	908 - NJ
209 - CA	309 - IL	409 - TX	509 - WA	609 - NJ	709 - NF	809 - PR	909 - CA
210 - TX	310 - CA	410 - MD	510 - CA	610 - PA	710 -	810 - MI	910 - NC
212 - NY	312 - IL	412 - PA	512 - TX	612 - MN	712 - IA	812 - IN	912 - GA
213 - CA	313 - MI	413 - MA	513 - OH	613 - ON	713 - TX	813 - FL	913 - KS
214 - TX	314 - MO	414 - WI	514 - PQ	614 - OH	714 - CA	814 - PA	914 - NY
215 - PA	315 - NY	415 - CA	515 - IA	615 - TN	715 - WI	815 - IL	915 - TX
216 - OH	316 - KS	416 - ON	516 - NY	616 - MI	716 - NY	816 - MO	916 - CA
217 - IL	317 - IN	417 - MO	517 - MI	617 - MA	717 - PA	817 - TX	917 - NY
218 - MN	318 - LA	418 - PQ	518 - NY	618 - IL	718 - NY	818 - CA	918 - OK
219 - IN	319 - IA	419 - OH	519 - ON	619 - CA	719 - CO	819 - PQ	919 - NC
228 - MS	320 - MN	423 - TN	520 - AZ	626 - CA	724 - PA	830 - TX	920 - WI
240 - MD	323 - CA	425 - WA	530 - CA	630 - IL	732 - NJ	831 - CA	925 - CA
242 - BA	330 - OH	435 - UT	540 - VA	649 - TCA	734 - MI	847 - IL	931 - TN
246 - BRB	334 - AL	440 - OH	541 - OR	650 - CA	740 - OH	850 - FL	937 - OH
248 - MI	336 - NC	441 - BM	561 - FL	660 - MO	757 - VA	860 - CT	940 - TX
250 - BC	340 - VI	443 - MD	562 - CA	664 - MSR	758 -	864 - SC	941 - FL
253 - WA	345 - CYM	456 -	573 - MO	670 - MNP	760 - CA	867 - YK	949 - CA
254 - TX	352 - FL	473 - GRD	580 - OK	671 - GUM	765 - IN	868 - TTO	954 - FL
264 - AIA	360 - WA				767 - DMA	869 -	956 - TX
268 - ATG					770 - GA	870 - AR	970 - CO
281 - TX					773 - IL	876 - JAM	972 - TX
284 - BV					781 - MA		973 - NJ
					784 - VCT		978 - MA
					785 - KS
					787 - PR


International Abbreviations:

AIA	Anguilla
ATG	Antigua and Barbuda
BA	Bahamas
BM	Bermuda
BRB	Barbados
BV	British Virgin Islands
CYM	Cayman Islands
DMA	Dominica
GRD	Grenada
GUM	Guam
JAM	Jamaica
MNP	Commonwealth of Northern Mariana Islands
MSR	Montserrat
PR	Puerto Rico, Virgin Islands, Bahamas
TCA	Turks & Caicos Islands
TTO	Trinidad and Tobago
VCT	St. Vincent & the Grenadines
VI	U.S. Virgin Islands


Canadian Abbreviations:

AB	Alberta
ON	Ontario
MB	Manitoba
SK	Saskatchewan
PQ	Quebec
NB	New Brunswick
BC	British Columbia
NF	Newfoundland
NS	Nova Scotia
YK	Yukon, Northwest Territories


United States Postal Service Zip + 4 Code Lookup
United States Postal Service ®  ZIP + 4 Code Lookup

For up to the minute ZIP + 4 information, you can use the United States Postal Service ZIP + 4 Code Lookup database on their Internet World Wide Web site.  Open your web browser and load the file uspszip4.htm.  This file, (not included in the evaluation version of Quikthinking Zip Codes), was copied to your computer in the Quikthinking Zip Codes application directory when you installed the complete 40,000+ zip code version of the program.  The default Quikthinking Zip Codes application directory is qzipwin (unless you changed it during the program installation).  Click on the Go to the United States Postal Service ZIP + 4 database to find the 9 digit zip codes that you need.


Command Buttons

Exit	Quit Quikthinking Zip Codes.

First	Move to the first database entry.

Previous	Move backwards in the database.

     Next	Move forward in the database.

     Last	Move to the last database entry (record).

Find	Search for a database field entry.

Query	Construct a sophisticated search procedure.

Reset	Used after a Find or Query to reset the database.


Menu Items

File	Menu selection for these options:

Open	Loads the zip code database.

Exit	Quits Quikthinking Zip Codes.

Record       Menu selection for these options:

Next	Move forward in the database.

Previous	Move backwards in the database.

First	Move to the first database entry.

Last	Move to the last database entry (record).

Find	Search for a database field entry.

Query	Construct a sophisticated search procedure.

Reset	Used after a Find or Query to reset the database.

Tools          Menu selection for these items:

Re-Index	Rebuilds all of the database index files.

Pack File	Removes deleted records from the database.

View	Menu selection for these items:

Indexed Order   Displays records according to the selected index.

Natural Order    Order the records were entered into the database.

Query Order	Displays records in query order.

Windows	Menu selection for these items:

Cascade	Displays windows on top of each other.

Tile	Displays windows side by side like a checkerboard.

Arrange Icons 	Arrange icons.

Help	Menu selection for these items:

Contents	Help topics.

About	Copyright information and web site address.


Searching the Database

Searching using FIND

Searching using QUERY


Searching using Find

Select File then Open from the Main Menu.  Once the main database is open,  both the Find and Query search options are available.  Click the Find icon using the mouse, or select Record, then Find from the main menu using the keyboard.  A dialog box will pop up with a search value highlighted.  The default value is CITY.  To change the search field, click the arrow in the search field box and select either State, County, Area Code, or Zip Code.  Next, enter the name of the item you want to find, then click OK.  You can enter text in either lower or upper case.


Searching using Query

You can conduct sophisticated searches of the database using the Query option.

Select File then Open from the Main Menu.  Once the main database is open,  both the Find and Query search options are available.  As an example, suppose you wanted to search through the database for every city with the name of Newport.

Use the following procedure to execute the query:

1)  Select Record, then Query from the menu, or click on the Q icon.

2)  Choose an index from the Order by box (City is the default).  This simply

     means that the database will be sorted according to the option you choose.

     Select either City, State, County, Area Code, or Zip Code.  For this example,

     City should be selected.

3)  From the Field box, choose City.

4)  From the Query Operator box, choose =.

5)  In the Constant box, type in Newport.

6)  Click on Add.

7)  Click on Apply.

You can also include multiple statements in the ALL CONDITIONS APPLIED box.  This is a powerful feature of query searching in Quikthinking Zip Codes.

The database will now be searched according to the criterion you have just entered.  To save your query, pull down the File menu in the Query dialog box, select save, and then enter a name when requested to do so.  You can then reuse this query without having to type it in again.  To reuse the Query in another session,  repeat step 1 above, then select File, then Open from the Query dialog box to load your saved query.

Reset Button

After the Query procedure ends, close the Query window, and observe the information in the database.  Use the command buttons or menu selections to go forward or backwards to view your information.  When you are finished looking at the query information, select Reset from the Record menu, or click the Reset command button.  The query now has been removed...you can start another one, or continue with your session as you wish.


Query Operators

<	less than.
<=	less than or equal to.
<>	not equal to.
=	equal to.
>	greater than.
>=	greater than or equal to.
CT	contains.
NC	does not contain.


State Abbreviations

AL   Alabama	KY    Kentucky	ND   North Dakota
AK   Alaska	LA    Louisiana	OH   Ohio
AZ   Arizona	ME   Maine	OK   Oklahoma
AR   Arkansas	MD   Maryland	OR   Oregon
CA   California	MA   Massachusetts	PA    Pennsylvania
CO  Colorado	MI    Michigan	RI     Rhode Island
CT   Colorado	MN   Minnesota	SC    South Carolina
DE   Delaware	MS   Mississippi	SD    South Dakota
DC   District of Columbia	MO   Missouri	TN    Tennessee
FL    Florida	MT   Montana	TX    Texas
GA   Georgia	NE    Nebraska	UT    Utah
HI     Hawaii	NV    Nevada	VT    Vermont
ID     Idaho	NH    New Hampshire	VA    Virginia
IL     Illinois	NJ     New Jersey	WA   Washington
IN     Indiana	NM    New Mexico	WV   West Virginia
IA     Iowa	NY    New York	WI    Wisconsin
KS    Kansas	NC    North Carolina	WY   Wyoming