Project Time-Ex Couriers Management Application
Organization TIME-EX & FLASH Couriers, Dallas, Texas
Project Type Off-site Consultant and project development
Duration Apr 1995 – Nov 1998
Platform/OS Windows Server NT 4.0, Windows 2000
Position Access Developer and System Analyst
Software Access 2.0/97/VBA
Description Time-Ex Courier Management Application is full feature of a Courier management program for managing small and medium size Courier businesses. It takes delivery tickets then creates invoices and gets account receivable. It controls each client balance and reports all the activities of the processes. It calculates drivers and salesmen commissions. It shows daily, monthly, yearly income, sales, and payments. Backs up the old data, repairs and compacts the databases.
Key Features 
  • Order Ticket Entry
  • Dispatching
  • Invoice Creation
  • Calculate Commissions (Drivers, salesmen)
  • Account Receivable and Account Payable
  • Reporting (daily, monthly, yearly income, sales, and payments)
  • Security
  • internal e-mail/messaging
  • Back up old data, repair and compact the databases
My Tasks 
  • Designed forms, reports, macros, modules and queries.
  • Analyzed existing order entry, dispatching, invoice creation, commission calculation, A/P, A/R, past due, mailing, clients, and drivers’ info processes and integrate them as one application.
  • Designed internal e-mail/messaging, compact/repair and login security modules.
  • Created reports and graphs for delivery, sales, payment, and expense info by daily, weekly, monthly, quarterly and yearly.