Database Development

CompuWorks assists clients in the design, development, integration and support of new or existing Access and SQL database applications. From designing and developing a brand new database to optimizing or integrating existing databases, CompuWorks has over 15 years experience in helping clients create robust, healthy and well-designed applications.

Many of our clients start their own databases using Microsoft Excel. As these applications grow, they find that they need to take their systems to the next level. That is where CompuWorks comes in. We specialize in converting Excel files into robust, expandable databases using Microsoft Access and/or SQL Server. Our consultants understand and adhere to the rules of Relational Database Design theories and handle everything from data conversion to the new interface to helping your users become proficient in daily operations and future enhancements.

If you have an existing database system that is not fulfilling your needs, CompuWorks can help by having one of our professional database developers analyze and recommend enhancements to upgrade your system or design a completely new system for you.

How does it work?

Each database solution consists of a thorough 5-step process. Regardless of the size and scope of your needs, we follow this methodology completely. It is our belief that cutting corners only creates more work and less quality.

  • Analysis – Our database consultant will take time to talk to you to determine your needs. Many times, our clients aren’t aware of feature possibilities because they are too busy. It is our job to analyze your needs and help you understand how a database can assist you in your daily tasks.
  • Design – Once the analysis step is complete, our database consultants will document everything and propose a design for your new system. This includes the different tables and queries the system will require. It is during this phase that the database programmer is planning the interface and the overall flow of the database. Of course nothing is done until you are comfortable with the results.
  • Development – This phase is where the magic happens. Our database developer takes the design and actually creates the new database application. He/she builds the necessary database components and programmatically links them into a cohesive application. During this phase, the database programmer follows the strict rules of Database Normalization, which ensures the system will grow as your needs grow. He/she is also following the strict guidelines for the interface design. This ensures that the interface looks and behaves like a professional application should. All of our databases look and feel like a shrink-wrapped application.
  • Debug – This phase of the development is the most important. Select individuals will receive a “beta” copy of the system. It is here that you and CompuWorks work closer than before. It will be up to the users to determine how well the system matches the needs. If something is found to not work correctly, you will inform the CompuWorks database developer and he/she will make the necessary changes. Nothing progresses until the system is considered “stable”.
  • Delivery – This is the final phase of the methodology. The new system is compiled, and backed up to a DVD. The design is fully documented and the system is delivered to you. At this point, you are an equal partner in the database. You will be surprise at how much you understand about the design and how it works because CompuWorks actively includes you in the entire process.

CompuWorks is a training company. We do not believe in delivering a “black box” database system where any modification requires future costs. It is our belief that when you understand your needs and the solutions created to meet them, you become a stronger user.