Agee Software, Inc.
Microsoft Access Databases
Tech Support Database stores contact info on each customer. Logs each incident with description of problem and corrective action. Provides map and logs date and mileage of travel. Reports invoice, accounts receivable, balance sheet, mailing labels, single envelopes, hours worked by tech, customer and date range. General ledger tracks inventory cost, sales tax, payroll and tax withholding. Used in Dallas County, Texas. Also available in Microsoft Access 97. Software Development Company Database log start and end time of each programming task throughout development of a software project. The developer can invoice at any time. Shows accounts receivable, uninvoiced work, hours worked by client or developer during a selected date period. Used in production in Collin County, Texas since 1999. Lawn Service Database lawn maintenance application tracks customers, sales leads, mowing schedule, invoices, accounts receivable, mailing list and credit card payments for Lawn Service Company. Includes user level security. Trucking Company Database schedule pickup and delivery of shipments between consignee and rail terminal. Receive shipments with EDI 204 transaction, respond with EDI 997, accept job with EDI 990 and transmit status with EDI 214 transaction. Send invoice with EDI 210 transaction and log payment. Used in Dallas County, TX Construction Estimating Database application designed for construction contractors and subcontractors. to consolidate estimate for entire job or each single estimate. Calculate labor and materials estimate by inventory item. Support for several rates, functional areas and skill levels of labor. Calculate by labor rate. Adjust parameter to create bid. Microsoft Access 2000 version runs under MS Access XP or 2003. Includes full user level security. Used in Fort Worth, Texas since 2001. Job Cost Accounting Software to account for components of job cost as construction job is completed and compare to estimate. Used in Fort Worth, Texas since 2000. Auction Database Large auction system for a company that sells computer hardware and software on consignment in live auctions. Import from Excel spreadsheets in nearly any format. Scan manufacturer's barcode to identify item and Print barodes or export a list of items for sale on website. Includes video output of item currently being auctioned, logs high bidder in real time to print invoice and verify ownership at security checkpoint. Accounting module shows current and estimated cash flow in real time. Data tables are in SQL Server and stored procedures provide rapid response time even over a wireless network.Small auction system creates printed catalog, bid sheet and invoices. Very simple and low cost. Available in Microsoft Access 2003. Used in North Texas Skip Tracing Application provides information for investigators to document all actions during collateral location. Managers can monitor performance and provide realtime priorities and time management task lists. Creates reports for repo agent, invoice to client, cash flow and accounts receivable to management. Evaluates performance of salespeople and provides audit trail of all actions. Exports selected cases to credit verification agency and imports results back into database using EDI. Supports storage of scanned documents with powerful keyword search feature. MS Access 2000 application used daily by 35 concurrent users in Dallas, Texas.