Many times, an organization needs to capture specific data and can not find an existing software program to meet their needs.

When you need to capture information specific to the needs of your organization, we can design a custom database for you.  This is an excellent solution when you want the software to work for you, instead of you working around the software.

At Softspan, we use a proven 10 step process to insure that the database meets your needs.

1. Thoroughly define your needs for information gathering and reporting.
2. Optimally design tables for data storage and organization.
3. Design queries and macros to group data for forms and reports.
4. Design efficient and easy-to-use forms for data entry.
5. Design reports for easy review of specific data.
6. Design a Main Menu for easy access to forms and reports.
7. Establish security for access to data.
8. Convert data from your existing database, when applicable.
9. Deploy the database on user workstations – it’s “share-able.”
10. Make modifications as needs change – it’s always customizable.

We have designed custom databases for many different businesses in many different industries.  Examples include:

• Nonprofit - Enter detailed client, volunteer, board and donor information.  Track interactions and activity participation.  Enter client evaluations and calculate outcome statistics.  Track donor history and generate reminder notices.

• Service - Maintain customer and building information. Enter all contracts and services to be provided.  Produce work orders based on contracts and job orders based on new requests.  Record time and materials used on jobs for cost analysis.  Track equipment and vehicle information and produce maintenance reports.  Enter purchase orders, inventory receipts and deliveries.  Provide extensive reports.

• Assembly - Import sales and inventory data from accounting software.  Enter employee time.  Use time for payroll calculations and profitability reports by work order, employee, customer and team.

• R & D - Enter and generate all purchase orders and track all inventory receipts, movement and usage.  Generate related reports.

• Manufacturing - Import timecard information from accounting software.  Maintain all material and spec information for custom metal fabrication.  Enter or select materials and specs needed for specific jobs and provide forms to manufacturing floor.  Use reports to review open jobs by customer, cell and due date.  Review profitability of each job.