SOLUTIONS

• Solutions List
• Database

1. Database Development
2. Software Development
3. E-Business Solution
4. Microsoft Access Upgrade
5. Data Warehousing

DATABASE DEVELOPMENT

Database Development for SMEs

Many organisations have precise operational requirements that cannot be addressed effectively by an off-the-shelf product. In these situations, custom database development can enable the provision of 100% fit, highly optimised systems to address specific requirements. Using the very latest industry standard technologies, high quality databases can be developed, delivered and implemented in ever decreasing timeframes. To maximise the return on investment and customer experience Codestone utilises System One to deliver significantly richer business applications at reduced investment levels.

SystemOne - Database Development

System One is a revolution in enabling the delivery of business database applications that offer the ‘best of both worlds’, that is the richness, power and flexibility of an off-the-shelf product combined with the 100% fit of a bespoke application.

What is SystemOne

System One is a generic Windows based software ‘framework’ that provides a proven, flexible foundation for any database application with a plethora of generic application features and services. Precise functional requirements are addressed by developing plug-in components to System One to form a powerful and cohesive business application.

Business Benefits

The broad-based benefits of using System One as the foundation for a database development project include: - Reduction in development costs of up to 50% (typically 30-35%)

• An unquestionably richer, more powerful application
• Reduced implementation timescales
• Reduced customer acceptance testing
• Increased application scalability due to the data-driven, plug-in architecture
• Reduced on-going development costs due to self-sufficient features such as custom fields, pick lists & security
• Increased application stability due to the proven underlying foundation to the application

Applications built on System One are specified in the same way as a database development project using Business & Systems Analysis and a fully detailed functional specification.

Look and Feel

System One presents a intuitive, customisable, data driven interface as the main application console. This interface utilises a ‘Shortcut’, ‘Tree’, ‘View’ based presentation so that navigation is completely consistent and extensible, whatever the information.

Features

Features built into System One are automatically inherited by the application built using it. Availability of these features is controlled via a thorough security model. - Create User-Defined Fields within any System or Application Component

• Create multiple, user-defined Views for all information
• Apply real-time Conditional Formatting with Views using Colour, Bold, Underline, Strikethrough etc
• Quick and Advanced Search facilities on any field in any information with using multiple search types such as ‘Equals’, ‘Starts With’, ‘Ends with’, ‘Contains’ etc include wildcards
• User Management & Feature Permissions
• User Groups
• Row Level Data Permissions on all information
• Centralised Pick List Management for data consistency
• Customisable Toolbars
• Customisable Menus
• Activities feature for recalls, to-do’s or application specific reminders
• Relational Document Repository
• NT Authentication and Internal Authentication Options
• Custom Reporting using Crystal Reports™ Integration
• Microsoft® Outlook Integration for inbound and outbound email-tracking against any entity

Architecture & Technology

System One is 32bit Windows Software, with a client-server application architecture. The product utilises best-of-breed technologies from Microsoft including Visual Basic, Visual C++ and SQL Server 2000 for robust and responsive data storage and retrieval.

RESOURCES