|
|
|
Samples of Our Work Greg Reid Associates,
Inc. The Contact Management System
(CMS) which is an integral part of the services that they provide by
maintaining detailed information about the universe of potential prospects,
detailed contact history, and accurate reports of pending opportunities. Items of Interest: The
information is structured so that the users can view the data from multiple
perspectives. Prospects can be located within the list of contacts, and then
the user can drill down to the company record. The user can also start at the
company level and use the list of associated contacts to drill down to the
individual contact. Pending opportunities are tracked and presented in a list
that can be sorted by clicking on the column headings. From the list, the
user can drill down to the specific prospect record identified in the
opportunity record. Quick action can be taken by means of an OLE (object
linking and embedding) link with Microsoft Word to generate letters and
automatically update the contact history. John Smith & Sons
Booksellers, Inc.
John Smith & Son Inc.
Booksellers is an associated company of John Smith & Son (Glasgow) Ltd.
of Scotland. They purchase books and periodicals from domestic publishers and
then ship the books back to Scotland or to the final recipient. The incoming
orders are sent from Scotland by electronic mail. On a daily basis the
electronic mail is read into the Book Order Tracking System and then order
letters are generated by publisher. Management reports make it possible to
track the status of all orders. Unfulfilled orders are automatically flagged
after a preset period of time has elapsed. When a sufficient quantity of
books and periodicals arrive, a shipment is created. For each shipment an
invoice and shipping label is then generated. Items of interest:
Importing e-mail directly into the database has dramatically reduced errors
and increased the number of orders that can be handled. By using date
triggers, the system keeps management on top of delayed orders. The date
triggers, default values, and import controls are all stored in a control
table so that management can adjust and tune the system in response to
changing needs. Rodale Press Working in cooperation
with Winston-Wells Design, a graphic design firm, and Lower Mills Group, a
website development firm, Gamma provided the database expertise for the
Gearfinder development effort. The site enables the user to select a category
of equipment, such as backpacks, and then using a series of list boxes, the
visitor is able to define selection criteria such as manufacturer, price,
size, and usage to name but a few. The site is running on a Windows NT
server, using the Internet Information Server. The data resides in an Access
database. It was originally developed using the IDC/HTX files, but it was
subsequently rewritten with expanded functionality using Active Server Pages.
Yahoo! named the site "a pick of the week". For more information, Contact Us |
