Agee Software, Inc.

Auction Inventory Software

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
The Microsoft Access auction program's tooltips, status bar and hotkeys are used throughout the auction system in Dallas, Fort Worth, Arlington, Garland, Irving, Plano, Carrollton, Frisco and Denton, Texas. An auction system supports a company who auctions computer equipment for cosignors in DFW metroplex. This Access auction database uses manufacturer's barcode info to scan and print to use to idenify the auction inventory being sold in McKinney, Richardson, Grand Prairie and Mesquite, TX. Our auction application allows cosignors data to be imported from any Excel spreadsheet for quick inventory with manufacturer's barcode. We offer an auction app that uses manufacturer barcode to idenify the auction inventory by scanning and printing it throughout the system in Frisco, Irving, Carrollton, Plano, Arlington, Garland, Dallas, Denton and Fort Worth, Texas. The Microsoft Access auction database includes a kiosk form that polled the table for the auction inventory being auctioned off with displaying digital photo and description on several monitors in Collin County, Dallas County and Tarrant County. From Allen, Texas we have an auction program that offers the customers an audit trail with a real time proift and loss statement in DFW metroplex. Our Access auction system imports data from any spreadsheet to provide a quick inventory list of computer items being sold in Tarrant County, Dallas County and Collin County. An auction app has a front end written in Microsoft Access 97 with user level security and has back end with SQL Server to provide adequate performance for a wireless LAN system in Mesquite, McKinney, Grand Prairie and Richardson, TX. This Microsoft Access auction application has a verification process for customers and their credit cards using customer's zip code along with other business rules to protect against fraud in DFW metroplex. This auction database uses Micorsoft SQL Server 7.0 for the back end and Micorsoft Access 97 for the front end in this auction inventory system. Tooltips, status bars and hotkeys are used in this Access auction app with queries, forms, reports and module which are thoroughly commented to provide an user friendly auction porgram.