Technical Resource Exchange, Inc.
the online people

What can TREX do for me?

TREX has expertise in various IT areas. The examples on this page show some of the way we can help your business.

I need to get information from my existing database on my web site

Many companies have databases with valuable information about products and customers. You may also already have a basic web site that you are constantly trying to keep updated with information from this database. TREX can show you how you can securely link this database to your web site to keep your online information current. We can also implement such a system, and give you options that will meet your specific needs. Read this example to learn more.

City Recreation Center

A city recreation center maintained a database of all their classes and events that they sponsor. They keep all their records of what classes are available, and information on the people signed up for the events. They also needed to maintain the information on their web site. They did not have to hire out this web site updating, because someone in the office was trained to keep the site up to date. However, entering the same information into the database, and also putting it on the web site was a duplication of work. Furthermore, it was usually a few days before the web site was updated to reflect new classes, or to indicate classes that were full.

TREX proposes a solution

TREX reviewed their current database, and discussed how the system is used. The existing database was developed in an older database application which was not compatible with the latest web integration tools. TREX was able to reproduce the database using Microsoft Access, and was able to link this database with an online SQL database what was updated twice a day from the access database. The new database provided a streamlined interface and corrected some problems they were having with their old system. A few extra inputs were added so that the web site information all resided in the one database. Custom scripting was added to the web site to automatically display the information from the database, and additional search capabilities were added to allow people to easily find an event.

The information is now entered into the local database, and when they dial up to their Internet connection twice a day, the information is copied to the Internet web site database. The information on the web is kept up to date without having to enter the information twice, and their database is easier to maintain.


IT Consulting
how to do it better
where to expand
   or consolidate

share data internally
automatically put
   info on the internet
Business Solutions
network solutions
intranet and

Web Site Design
defining a site
parts and

custom applications
Internet Solutions
domain name

e-mail accounts
web site hosting
site maintenance
where do I start?
I already have a
   database, but want
    info on the Internet

I want to sell my
    product online

I need a
    custom application
About Us
our philosophy
who is TREX
what we can do for
    your company

contact TREX
IT Consulting | Business Solutions | Web Site Design | Web Hosting | Example Stories | Contact TREX