Services

Example Services

 1) We can develop a complete system. For this we would need a fairly detailed specification and would then give you a fixed price quotation with interim deliverables (ie we would supply you with a gradually more and more complete system over time). A very simple system might cost £5,000. A more typical system will usually cost between £15,000 and £40,000. Complex requirements involving issues such as multiple sites, multiple languages, n-tier, SQL Server Replication, complicated interfaces to third party products or large numbers of forms or tables may push up the cost considerably. These are only very rough guidelines but if you have something non-trivial and expect to be paying only a few thousand pounds then you need to reconsider. 

2) We can migrate an existing Access database to SQL Server. This can cost anywhere from £2,000 to £50,000 but a 'typical' price would be £15,000. However there are a large number of variables (it's not just a case of migrating the data) so this price does vary considerably. 

3) If you have developed a database but are having trouble in getting it to work properly then we can audit it, identify any major problems or inconsistencies; advise you on what to change in the design of the database, tables, forms, etc. and give a guide as to how you should proceed from here. An audit will usually cost £1,000 for an 'average' database. 

4) We can work on a time basis if you prefer. Please ask for details if you prefer this route (typically used when the requirements are not fully known or may change). 

5) We can write a Functional Specification for your proposed system. Typically this would include one or more on-site visits, phone calls and e-mails and would normally cost from £5,000 upwards for a system of average complexity. Note that a proper specification will usually reduce the cost of the final system, so money spent up front is rarely wasted. 

6) Regular Support. We can act as a support centre for an existing SQL Server database (we no longer offer support for other people's Access databases due to the appalling quality of most that we see). Typically this would be an annual fee calculated according to the level of support required, the number of users involved, the size and complexity of the database(s) involved, whether development work is included in the support packages and the amount of on-site support required. This fee therefore varies widely and will need to be individually costed. All support is provided by 'real' developers with practical, 'coal-face', experience. For further details see our support page. 

7) Ad Hoc Support or Timebank. If you don't want or have a regular support contract but do have a problem which you'd like us to solve then we can undertake this on a one-off ad hoc basis. Another variation on this theme that we often use is a timebank. You pre-purchase a block of time, say 20 hours, from us which you can then call-off against as required. We will log all work undertaken against your timebank and provide you with a detailed breakdown of work undertaken on a regular basis. We will also inform you if the timebank is close to being used up so you can top it up if required. Again for further details see our support page. 

8) Technical Management Support. If you have in-house developers writing Access or SQL Server applications and would like some objective assessment that they are undertaking the work to appropriate standards, then we can review the existing work and provide recommendations for changes. If required we can also supply documented standards for future developments. 

9) We can undertake specific items of work to an existing Access or SQL database. Some areas where this might apply include: 

  • Database design. Design/Redesign your database using the relational model and normalise it to the third normal form (this just means making sure that the basic design of the database follows a proper relational model, thus making it easier to code and easier to maintain).
  • Security. Setting up User and Group accounts, defining different access permissions, back-end/front-end table access rights, RWOP queries, locking down applications, adding audit trails, etc.
  • Upgrading of an existing database, eg from Access to SQL Server. Addition of a web based Internet/Intranet interface to an existing database (depending upon circumstances this may also require the setting up of a web server as well).
  • Queries. Developing complex queries, adding functions to queries, union queries, subqueries, etc. Performance.
  • Optimizing queries, forms, stored procedures, code, etc. to make your application run faster.
  • Multi-User. Convert a single user system into a multi-user, networked one including front-end/back-end split, table attachment checks and reattachments, access rights, etc.
  • Extending the existing functionality. For example by adding in automated address lookup from Post Codes.
  • Functions. Developing specific functions (date related, mathematical, validation, string parsing, etc.).
  • Conversion. Conversion from one version of Access to another, from FoxPro to Access, Paradox to SQL Server, etc.
  • Replication. Enabling replication in a SQL Server database or fixing problems that you may be having with replication. Import Routines.
  • Writing custom routines to import and validate data from other systems (eg mainframes, csv files, etc.).