The program supports a company who auctions computer equipment for consignors.
The system allows consignor data to be imported from any Excel spreadsheet for quick inventory. Manufacturer barcode information is used to identify the item. The barcode
scanning and printing was used throughout the system. The system includes a Kiosk form which polls a table for the item being auctioned and displays a digital photo and
description of that item on several monitors. Customer data is scanned from the driver license. Absentee bids, winning bids and invoices are posted to the database in
real time. The invoice can handle cash discounts and split payments. The accounting system provides an audit trail and real time profit and loss info.
The system front end was written in Microsoft Access 97 with user level security implemented. The back end was Microsoft SQL Server 7.0 to provide adequate performance
for the wireless LAN connections and portable PCs. Several API calls were used in the system. Each table or query can be exported to text, Excel or DBF. Tooltips, status bar
and hotkeys are used throughout the system. Each query, form, report and module are thoroughly commented. The system checkss credit card numbers for format, validates
the customer’s zip code and applies other business rules to protect against fraud.
Close
Mention your city for a 1% discount on your first order if you are located in one of the following cities:
DFW
- Dallas, TX
- Fort Worth, TX
- Arlington, TX
- Plano, TX
- Garland, TX
- Irving, TX
- Grand Prairie, TX
- McKinney, TX
- Frisco, TX
- Mesquite, TX
- Carrollton, TX
- Denton, TX
- Richardson, TX
- Lewisville, TX
- Allen, TX
- Flower Mound, TX
- North Richland Hills, TX
- Mansfield, TX
- Rowlett, TX
- Euless, TX
- DeSoto, TX
- Grapevine, TX
- Bedford
- Cedar Hill
- Haltom City
- Wylie
- Keller
- Coppell
- Duncanville
- Rockwall
- Hurst
- Burleson
- Lancaster
- The Colony
- Waxahachie
- Cleburne
- Farmers Branch
- Southlake
- Little Elm
- Greenville
- Weatherford
- Balch Springs
- Watauga
- University Park
- Colleyville
- Benbrook
- Sachse
- Corinth
- Saginaw
- Ennis
- Midlothian
- Murphy
- Mineral Wells
- White Settlement
- Terrell
- Highland Village
- Seagoville
- Forney
- Addison
- Crowley
- Forest Hill
- Glenn Heights
- Azle
- Red Oak
- Prosper
- Royse City
- Anna
- Trophy Club
- Fate
- Celina
|
Texas
- Houston
- San Antonio
- Austin
- El Paso
- Corpus Christi
- Laredo
- Lubbock
- Amarillo
- Brownsville
- Pasadena
- Killeen
- McAllen
- Midland
- Waco
- Abilene
- Odessa
- Beaumont
- Round Rock
- The Woodlands
- Pearland
- College Station
- Wichita Falls
- Tyler
- San Angelo
- League City
- Sugar Land
- Edinburg
- Mission
- Longview
- Bryan
- Pharr
- Baytown
- Missouri City
- Temple
- New Braunfels
- Conroe
- Victoria
- Cedar Park
- Atascocita
- Harlingen
- Georgetown
- San Marcos
- Pflugerville
- Port Arthur
- Spring
- Galveston
|
US
- New York, NY
- Los Angeles, CA
- Chicago, IL
- Phoenix, AZ
- Philadelphia, PA
- San Diego, CA
- San Jose, CA
- Jacksonville, FL
- San Francisco, CA
- Columbus, OH
- Indianapolis, IN
- Charlotte, NC
- Seattle, WA
- Denver, CO
- Washington, DC
- Boston, MA
- Nashville, TN
- Memphis, TN
- Portland, OR
- Oklahoma City, OK
- Las Vegas, NV
- Louisville, KY
- Milwaukee, WI
- Albuquerque, NM
- Tucson, AZ
- Fresno, CA
- Sacramento, CA
- Mesa, AZ
- Kansas City, MO
- Atlanta, GA
- Long Beach, CA
- Colorado Springs, CO
- Raleigh, NC
- Miami, FL
- Virginia Beach, VA
- Omaha, NE
- Oakland, CA
- Minneapolis, MN
- Tulsa, OK
- New Orleans, LA
- Wichita, KS
- Tampa, FL
- Bakersfield, CA
- Aurora, CO
- Anaheim, CA
- Santa Ana, CA
- Riverside, CA
- Lexington, KY
- Stockton, CA
- Saint Paul, MN
- Cincinnati, OH
- Henderson, NV
- Greensboro, NC
- Newark, NJ
- Lincoln, NE
- Orlando, FL
- Chula Vista, CA
- Irvine, CA
- Fort Wayne, IN
- Jersey City, NJ
- Durham, NC
- St. Petersburg, FL
- Madison, WI
- Chandler, AZ
- Scottsdale, AZ
- Glendale, AZ
- Reno, NV
- Norfolk, VA
- Winston–Salem, NC
- North Las Vegas, NV
- Chesapeake, VA
- Gilbert, AZ
- Hialeah, FL
- Fremont, CA
- Richmond, VA
- Boise, ID
- San Bernardino, CA
- Spokane, WA
|
Close
|