SOFTWARE DEVELOPMENT

We have been developing and maintaining multi-user Microsoft Access databases, utilizing Access and SQL Server as data repositories, for over ten years. Access is an excellent, low cost, development platform for data entry and analysis, allowing our clients to leverage data in local databases as well as interacting with data in existing enterprise databases (SQL Server, Oracle, mySQL, Access, and even Excel). Access can link to data in any of these (and many other) data sources to minimize redundant data entry, decrease opportunities for data entry errors, and improve our ability to create applications and reports which pull data from multiple sources.

    We specialize in
  • Microsoft Access and SQL Server databases and Excel macros
  • Integrating data from multiple sources
  • Creating cross-platform reports
  • Visualization of data (Business Intelligence)
    Operations
  • Oil and Gas Industry
  • Data Extraction, Transformation, Loading (ETL)
  • Production analysis
  • Electronic Data Interchange (EDI)
  • Accounting
    Human Resources
  • Scholarship application processing, award and notification
  • Personnel management
  • Time and attendance
  • Scheduling
    Cleaning Industry – planning, scheduling, and billing
  • Water district management – planning and budgeting
  • Tool calibration, tracking, and certification
  • Manufacturing – part production and shipment processing
  • Mortgage processing, document storage and retrieval
  • Social Service program and client tracking
  • Modeling & Simulation
  • Data creation, loading and validation
    Data analytics
  • Scholarship cost analysis and modeling
  • Decision support software
  • Asset allocation
  • Analysis of modeling and simulation data