Agee Software, Inc.

Custom Microsoft Access Databases 31 - 40

Page 1   Page 2   Page 3   Page 4   Page 5  

Track workers compensation claims in DFW metroplex Workers Comp Tracking System
Handles medical evaluation of workers compensation claims. Forms in this database were generated using Access functions for better consistency.

Create documents for accessibility compliance construction in Texas Compliance Inspection Reports
Creates TDLR documents for RAS Registered Accessibility Specialist inspections.

Questionnaire for environmental inspections Environmental Inspection Database
Generic questionnaire to track environmental inspection issues of facilities or projects. Create custom questions for environmental survey, store answers and schedule and conduct followup surveys. Track outstanding issues for each project. Reports include Permit Memo, Compliance Inspection, Closeout, Application Approved, Applications Awaiting Approval, Approved Board Projects w/Permit Sections, Status of Approval, Inspection Field Form, Non-Compliance Followup and many more.

System tracks inventory of highway construction materials Highway Material Inventory Database
Maintain inventory of raw materials for highway project. Log changes to each product. Track each use and receipt of every commodity.

For TDLR Defensive Driving Course Providers Defensive Driving Certificate Database
Create TDLR compliant certificates for defensive driving course providers. Export and import CSV files. Export PDF for download from secure website.

Invoice for phone service or pager business Phone Service App
Set up and select standard services such as phone, pager service, pest control, lawn maintenance.
sales forecasting database Sales Forecasting Database
Standardizes, consolidates and evaluates regional soft drink sales from over a dozen regional office at corporate level. Reporting system provides thousands of different views of data. Sort and subtotal on channel, division, geographic region, broker, product and size for any month.
hotel reservation convention registration database Marketing Event Planning System
Supports coordination of large corporate conventions and marketing meetings. Handles payment, hotel, airline, ground transportation, entertainment and incentive packages, for registrant and spouse. Reservation system supports reserving a block of rooms from a hotel. OLE interface creates Word documents.
computer hardware auction database 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.
Agriculture lab statistics database Agriculture Lab Statistics Software
Analyzes data for 1.8 million readings of a variety of tests of chemical treatments on thousands of agricultural products. Printed reports save paper by using a compact yet clear open ended layout that handles a large number of columns and rows of blocked data. All data tables and queries can be exported to CSV, DBF, MDB, RTF, TXT or RTF formats. Analysis includes Mean, Least Significant Difference and Duncan multiple range tests to determine if the difference in the means is statistically significant. Response time is one to two seconds. The database includes an update feature to offer the 20 users the latest version of the fully secured database without administrator intervention. Used for two years in Frisco, Texas and at a Fortune 500 company since 2005.

Zip code marketing and planning database Zip Tool
View or export population, city, state & county of zips within a radius using lattitude and longitude for marketing or planning. Export to CSV from command line.

Page 1   Page 2   Page 3   Page 4   Page 5