CUSTOM APPLICATIONS AND CONNECTED DATA
Build software around the work you do.
Give your information a useful structure.
When spreadsheets and separate applications no longer fit the work, Spatial System Designs designs databases, screens, and reports around your business requirements. Work directly with a software engineer to connect the information your staff collects with the tasks and decisions it supports.
Three parts of a connected solution
The database, interface, and workflow are designed together.
Database design
Organize related sales, customer, employee, financial, production, or location records. Define relationships, validation, access, and reporting needs using a database environment suited to the project, including Microsoft SQL Server or Access where appropriate.
Application and interface design
Create screens around the user’s job. Plan clear selections, lookups, entry aids, and review steps for keyboard and mouse, touch-screen, or tablet use. Give staff the information needed at each stage of the process.
Integration and reporting
Connect records across applications, departments, or locations as required. Design searches, summaries, exports, and management reports that help your team use the information it maintains.
Typical reasons to build a custom solution
Start with a concrete problem and define the work the application should support.
Repeated entry
The same customer, item, employee, or job information is maintained in several places. Review the source of each record and build an agreed process for sharing updates.
A workflow that does not fit
Staff rely on side spreadsheets, handwritten notes, or extra steps to make an application work. Design the required entry, approval, correction, and review process with those users.
Information that is hard to use
The records exist, but a manager cannot readily answer an operational question. Plan useful searches, filters, reports, and connections between the relevant data.
Plan the move from the current system
Existing-data conversion, installation, documentation, training, and support are part of defining the project. Review the work in stages with your staff and refine the solution around agreed requirements.
Start with a technology and workflow review →