MS Access SQL Server Oracle Database Development

Online Portfolio | Search Optimization | Archive
Web Design | Custom Scripting | Web Database | E-Commerce | Search Optimization | Flash Web Design | Consulting
Template 'Tuning' | Template Designs
Desktop Solutions | Database Solutions | Automation Solutions | Integration | Project Solutions
Flash | 3D Design | 3D For The Web | Animation | Graphic Design | Conceptual Design | Reality Modeling
E-Learning | Disc Media | Business Graphics | Marketing Media | Custom Documents
Articles | Price Quotes | Site Map | Search Site | Web Links | About Neo•Paradigms | Contact Us
Database Solutions

Neo•Paradigms software engineers have been providing solutions for business computing needs since the late 1980's. Our project development teams provide full and complete solutions - meeting and exceeding our client's expectation. Neo•Paradigms specializes in build-to-suit data solutions. Whether you need to connect to an ORACLE or MS-SQL data server, DBIV, Access or proprietary data format, Excel workbook, flatfile or beads on a string we will provide a smooth, reliable connection to put your data into the hands of your business group so it can do what it does best ...satisfy your customers!

Do you need to provide levels of access to your data both within the data store and inside the retrieval application? No problem. We will utilize the very same security model used in the NTFS file system within your data application and your database if you require it. Do you need to replicate or update your online data in real-time? Neo•Paradigms can help you do exactly that and more.

Introduction

We specialize in the development of custom database applications using SQL Server, Microsoft Access, Visual Basic, ASP, VB.NET and ASP.NET. Applications that we have developed range from small, stand-alone, Microsoft Access databases to large, multi-site, multi-user SQL Server systems with millions of records and hundreds of users. We also develop distributed laptop applications, database enabled Internet and Intranet web sites, replicated SQL Server databases and upsize systems to SQL Server. We undertake projects from initial concept right through to the finished product including Analysis, Design, Programming, Testing, Installation and Support.

In addition to complete projects we are also happy to undertake the development of individual modules and smaller items of work (for example improving a slow running database system). We also supply related services such as software consultancy, data cleansing, Access and SQL Server training, system audits, etc. More details can be found under the 'Services' option in the top menu.

How It Works

We usually start with a specification of your requirements. In an ideal world this would give us enough information to be able to quote you for the work but in practice we usually need to revisit your requirements - even go on-site in some cases, both to clarify what it is that you want and to let you meet us so you can be reassured that we are competent, capable and reliable. When an on-site visit is required we also enjoy being able to put a face on the project - and provide the same in return.

We then issue a fixed price quotation. This will define what it is that we will develop for you, what technical environment we expect to be developing for, what the costs and timescales will be, etc. Once you have accepted the quote we will usually have a further discussion with you following which we will produce an initial database design. We then walk through this with you to ensure that we have correctly understood the relationships between all of the different data entities.

The next delivery will be a preliminary version. This will not be fully functional but will include a basic framework allowing you to fire up your application and to start seeing what it will look like. This will be followed by regular (1-2 week intervals) updates, each filling out more and more of the application.

This iterative approach, which is a variant of the DSDM (Dynamic Systems Development Method) methodology, has many advantages over the old 'waterfall' method. It lets you see the application as it is developing, allows you to influence the design, enables you to correct any misunderstandings at an early stage, lets you check that we are keeping to the agreed timescale and ensures that, at the end of the day, the application that we deliver to you is the same, or better, than the one that you were originally expecting!

We then deliver to you the feature complete version after which you undertake your final acceptance testing before the application 'goes live' (i.e. starts to be used for real work). Inevitably some teething issues may occur in the first few weeks - which is why we include free support for the first three months! Also don't forget our unique software guarantee; any bugs that are traced back to us will be fixed free of charge for the lifetime of your application!

Our Credentials & Facilities

We are professional developers with in-depth technical expertise as well as many years of practical business experience. All of our developers are highly experienced, each having a minimum of seven years hands-on database development experience and some much more! We do not employ trainees or inexperienced staff and when we contract workers - only for very large projects - we employ workers in our community not H1 Visa nor foreign based developers. We believe in Equal Opportunity Employment but we have also witnessed this system abused to the detriment of our own citizens and neighbors.

However our best credentials are the recommendations of our customers. Take a look at our clients, cast your eye over the variety of projects that we have undertaken, request some of our case studies and finally take a look at what our clients say about us. Software development is not a regulated industry, there are many incompetents and one or two sharks out there, the only real way of finding out if a developer is as good as they say they are is to talk to their previous clients.

We regularly contribute to computing publications and on-line forums. We also give seminars and continuation classes in computer literacy for adults, object orient design methodologies and, of course, relation database design and ADO technologies.

We have a wide range of testing servers, clients and workstations so that we can test your application in the environment in which it is going to be used. As well as all the current versions we also keep a number of old computers/operating systems as we know that not all our clients have the latest state-of-the-art machines! [On that note, our senior engineer refuses to give up his dual boot NT4/Linux PC!]

Over the years (we have been in business for 12 years) we have created an extensive in-house VB and SQL code and algorithm library containing thousands of proven routines and components... this allows us to complete your job faster and cheaper as well as helping us to keep to our goal of delivering to you a robust, high quality, product in a reasonable timescale. Reusable code is the cornerstone of successful development (and proof that developers are truly the laziest professional group on the planet).

We also keep a very extensive library of reference books, magazines, articles, support tools and software utilities. We are Microsoft MSDN Universal subscribers which provides us copies of all of Microsoft's Office products, operating systems, servers, applications, etc. so that we can develop and test your application in the correct environment.

Our Design & Coding Practices

All of our software is developed to the highest professional standards and we follow 'Best Practice' principles throughout the development cycle. While we have detailed exactly what this statement entails several times throughout out our development section, we point out here that development practices are honed through years of practices and discipline. Not to put too fine a point on it, there are a great many firms in operation that lack the experience and coding ethics you should be able to expect but may not receive. Navigate the waters of Independent Software Vendors with care.

Pricing & Quality We can either work on a Fixed Price or a Time & Materials basis as you wish, although most of our work is done on a Fixed Price basis.

Are You Cheap? No, we are not cheap, but we do offer excellent value for money. We aim to deliver high quality, robust, professional solutions to you and therefore we do not cut corners. This would normally make our solutions more expensive; however our code libraries (a wide range of routines and functions that we have built up over many years and which have been designed to be re-used in different projects) allow us to bring the costs back down to the industry average, or even below, - so you get a very high quality solution without paying extra for it... and don't forget that, unlike most other developers, our software also comes complete with source code and a lifetime guarantee!

The quality of developed software can vary significantly. Quality is difficult to quantify but all software should be developed to professional, Best Practice standards. Unfortunately most software is not!

The degree of support that you will get can also vary considerably. Make sure that your developer will still be around in a couple of years time and will still be able and willing to support you. Most importantly, make sure you will be supplied with the full source code of your finished application. Then, if your developer does disappear, at least you can hire someone else to make any modifications (and if it was developed to proper standards then this should involve you in considerably less grief than it would do otherwise!).

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 $300. More typical Access based systems usually cost between $500 and $15000 with .NET/SQL Server systems between $10,000 and $30,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. These are only very rough guidelines but if you have need of something non-trivial and expect to be paying under five hundred then you need to reconsider.

2) We can migrate an existing Access database to SQL Server. This can cost anywhere from $1,000 to $10,000 but a 'typical' price would be $5,000. However there are a large number of variables so this price does vary considerably. Internet database requirements are generally far less expensive due to the typically simple needs of most online requirements.

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 $300 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 consultations or visits, phone calls and e-mails and would normally cost from $1,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 center for an existing Access or SQL Server or Oracle database. 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 determined. All support is provided by 'real' developers with practical, 'hardcore', experience. For further details please contact us directly.

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 augment it if required. Again for further details please contact us.

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/Oracle database. Some areas where this might apply include: Database design. Design/Redesign you database using the relational model and normalize 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, e.g. 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 (e.g. mainframes, csv files, etc.).

What To Do Next: If you are interested in pursuing independent software development or if you need support then please get in touch with us. Contact Us for details or request a quote.

                       About Us | Site Map | Privacy Policy | Contact Us | ©1992 - 2005 Neo•Paradigms