What can a "custom DataBased Program" do for you?
Well, the fastest way to explain is through some examples.
Here is a small list of applications that would qualify as DataBased Software.
You can scroll through this document or click on the links to jump to a specific example. (Most examples are really short so I'd suggest you scroll.)
* * * * *
Client list/tracking: Database of clients with pertinent info for each, along with mailing labels for all clients or selected ones. Back to Example ListRepair shop manager Input customer info and repair item, add charges, edit all info, review charges, print invoices.
Back to Example ListCustomer, equipment & contract databases administration,, including a "back office" program for five users to print reports for contract appendices, customer installed base lists, and hardware configuration print outs.
Back to Example ListTrack of all the data from experimental plots Plant breeding company. The main application is used to keep track of all the data from experimental plots, analyze results for seed lots and genealogy for the seed lots. Program used by 5-15 people, some located abroad.
For easy data exchange with other programs, data can be entered or pasted into a spread sheet. Data from the database can also be written to a spread sheet and copied and pasted to other programs.
Back to Example ListDatabase for the local forensic pathologist A program to manage the database for a forensic pathologist. Two pathologists and a clerical staff of two. Local network connecting the two work stations. Hardest part of this one is that one of the pathologists keeps wanting really weird, off the wall queries. Now they can, if they wanted to, find out how many left handed, red-haired, homosexuals shot themselves in the right temple with a 22 caliber gun. The data entry screens are quite extensive.
Back to Example ListManage work orders Program for staff at a city physical facilities to manage work orders. Small office - one manager and one clerk. Volume is low - about 300 records a year.
Back to Example ListManage everything from custodial attendance to work orders to the plumber's inventory. Large plant. They have about half a dozen specialized programs that are used by eight office staff. The programs manage everything from custodial attendance to work orders to the plumber's inventory.
Back to Example ListTrack staff and resident information - a super sized rolodex One program manages requisitions. Another allows the department manager to keep track of staff and resident information - a super sized rolodex with information on where they graduated and details on their long lists of credentials. A third program in this department manages resident's procedures for accreditation.
Back to Example ListHelp with monthly billing, copier charges, and other charges to other departments. A department with a staff of three has several specialty programs that help with monthly billing of copier and other charges to other departments. This is faster than using the forms provided by head office.
Back to Example ListInventory sourcing Lookup vendor, find products, print order, or lookup products find vendor.
Back to Example ListClass reunion manager Database of class members with various information including notes. Prints inquiry forms and mailing labels for initial notice of reunion. Prints labels for follow up mailings when needed for selected individuals. Prints contact information pages for the reunion booklet.
Back to Example ListTrust management program handles bookkeeping functions for two different trusts.
Back to Example ListJob Order Entry application that simplifies the order entry process The main system required more data than needed by the division. This program eliminates the entry fields not needed and provides easy look up for things like customer numbers. Hundreds of jobs are entered each day and many come in groups from the same customer. This "add on" program has a feature that keeps some fields populated with data so the user only need change the due date and job title when working within the same batch of customer jobs.
Back to Example ListAutomated "overnight" routines:
School district's student information management Software created progress reports were designed to be folded and stuffed into envelopes. A small add on application was created to format the reports so they become self-mailers (requires no envelope). This is a significant saving considering the number of students.
Back to Example ListInformation for Long-term care patients and a children's clinic Consumer database tracking demographic information, medical information, services provided, client attendance, reportable incidents and a variety of other information for Long-term care patients and a children's clinic. This is currently used by approximately 15 people to manage almost 500 clients. It is a major project and goes through spurts of development as management decides they have time to move forward with the next segment.
Back to Example ListMaintenance Request system that uses an e-mail form to submit the request The software down loads the mail from the server, dissects the e-mail and places the information into the MR database. Requests are tracked and printed, when finished the system sends a completion e-mail back to the original requester. Any e-mails received that don't fit the MR format are presented to the user as a regular e-mail.
Back to Example ListWorkshop management program to keep track of employee's breaks and what jobs... ...they worked on. They are paid piece-count at different rates for each job. There are "hot-buttons" to simplify data entry.
Back to Example ListManage standings and statistics for racing league Results from the league races are imported (from HTML), the results (starting position, finishing position, qualifying speed, laps completed, intervals, penalties etc) are processed through the league rules and written to the database. The league administrator then creates a complete section of the web site containing all the stats, standings and history of the races/drivers.
Back to Example ListProposal generation and tracking The prices are pulled from a purchasing/inventory module, then, at the click of a button sends the accepted proposal to the project management/job costing module which interfaces with the Purchasing module and automatically generates PO's. When the project is done the information goes to the service management module which tracks service histories and costs, generates service contracts, pm schedules and invoices.
Back to Example ListProgram for dance studios, martial arts studios, or ... ...any sort of operation that has 'students' and 'teachers' and 'classes'. It will produce monthly billing, setting up of special 'contest' classes, info for ordering of costumes and many other capabilities. It is for modest sized dance studios (10-30 teachers).
Back to Example ListData is automatically collected from electronic controls Examples are: shift reports which track tonnage from raw feed belts and clean belts, equipment delays, monthly down time, production, quality sampling, etc.
Back to Example ListBasic input from an office phone system (extension number, type of call (local/long distance The program extracts some basic data from the telephone system. This information will be analyzed for basic department cost allocations and for catching phone abuse.
Back to Example ListInmate "intake" processing Legal firm that provides legal services to inmates at five different prisons. Their "Legal Writers", which are also inmates, take care of intake processing and also do all the data entry work for the attorneys.
They record information each time that an inmate visits the legal office in the prison. The data collected includes the legal writer, date of service, service provided, area of law, and stage of the case. This information is regularly sent to firm's main office and incorporated into a central table. The program of course tests records for duplication before saving them to the central table.
Most data is selected from pick lists. Each pick list is configurable in that the user can mark items on each list as active/inactive. Only active items appear in the pick lists when adding records, etc. This is done because some items become out dated. Also, some legal writers specialize in just a few things and don't need or want to see all pick list items.
Back to Example List* * * * *
Again, this is a small list of applications that would qualify as
DataBased Software.
By now you probably have several of your own ideas. If so call CROM CONSULTING 529-9427 or
e-mail: eric@cromcon.com
Comments or suggestions WELCOMED!
Send mail to
webmaster@cromcon.com