Programs and Modules

Programs

The software from Sunburst Database provides solutions for various industries. The programs and development techniques have been refined over the past 20 years to create reusable components for successful applications.

The software is configurable for specific needs, or can serve as the basis for a solution after further modification. The programs run under Microsoft Access and can be installed on a company network or hosted on an Internet server.

Sunburst Database uses base systems which have already been created and modifies them to match client needs through configuration, additional coding, and add-on modules. Following are systems currently available, and some examples of their current use. Contact us to see more specific examples

Lean Manufacturing DMS

This system manages a small manufacturing system from sales order through production, and includes an account receivables module to track invoices, payments, and account balances. There is a complex system to drive work orders and purchase orders from the Bill of Materials for each sales item.

Job Estimate Tracker DMS

This system provides job costing software for engineering firms and construction service companies to manage estimating, time and materials charges, billing, and accounts receivables components. Numerous modules developed over the past ten years have been assembled to manage client contacts, estimating, work orders, time-tracking, purchase orders, vendor payments, inventory, and customer billing. Current users of various versions of this system include painting, roofing, plaster, and plumbing companies. The system integrates with QuickBooks tables to monitor invoicing.

Rental Tracking DMS

This system manages rentals of equipment. It tracks the availability of equiment for any given day by analyzing reservations and multi-day rentals.

Investors Quarterly DMS

This system manages Investors and Assets to help track financial investments, like real estate private equity. Performance is computed from dividend and interest payments. It automates the production of Quarterly Reports, which can automatically be attached to emails as PDF files. Contact us to see samples.

Patient Chart Tracker DMS

This system manages patient medical summaries to help doctors quickly view the essential patient chart data necessary to provide quality medical care. The software can act as a stand-alone program or be integrated with standard medical accounting packages. For many doctors, their EHR/EMR medical billing software makes it difficult to quickly access important health information because the billing software is mainly designed to comply with reporting requirements for government or insurance companies.

Event Response Tracker

This system manages the emergency responses for an organization that has numerous paid or volunteer responders. It can help with tracking of memberships and donations, and can be expanded to provide billing and invoices based on timesheets and materials used in a response.

Adventure Tour Tracker DMS

This system has been in use for over ten years at a local helicopter skiing company. It has modules for managing clients, tours, flight manifestos, invoicing, payments, and other accounting functions. The software has been upgraded to take advantage of some of the newer features in the family of Sunburst Database systems, such as management of documents and broadcast emailing for marketing.

Modules

The various complete systems are integrated with modules that perform specific functions. These modules are well tested and can be added to new custom systems. Examples include:

Client Contact Tracker

This module manages contacts of various types, such as customers, vendors, or staff. It includes contact reports, search and filtering, data export, and broadcast emailing.

File Tracker DMS

This module manages files in Windows folders that are linked to records in the database. It allows users to open a file linked to a database record directly from the database application while viewing the record. Users can open files of any type, like a Word document, Excel spreadsheet, PDF document, or image file. The files can be viewed, edited, or printed without needing to leave the database program. This module is usually integrated with the Client Contact Tracker, but can work with other data tables such as jobs.

Import Templates

This module transfers data from one system to another. Using configurable templates, the fields in a record-based source can be mapped and converted for migration to another destination. The source records can be an SQL database, accounting program, Excel spreadsheet, or text file. The destination can be another database, spreadsheet, or program.

Salesforce Migration

This module uses the algorithms of Import Templates, but with the goal to export data from a Legacy source and convert the records for import into Salesforce. Special subroutines convert standard data to the formats acceptable by Salesforce. The legacy source records might be an accounting program, a database providing an ODBC connection, or spreadsheet files.

Following are two links that describe in greater detail the needs of our customers and how we aim to create custom software to solve their problems.