So you have decided to invest in a new database. Usually, you already know the problems you want to solve and the gains you want to make and those goals determine our starting point. Whether you need to streamline systems, save time, increase productivity, or cut down on duplication, our objective is to design smart database systems to match your known objectives.
We use proven agile methodologies, qualified personnel, and a highly responsive approach to managing deliverables. No excuses and no delays. Just a responsive, seamless service that solves your problem, creates your solution, and allows your business to get on with what it does best. We won’t waste your time.
Creating bespoke databases using Microsoft SQL Server and Microsoft Access is our speciality. We offer a wide range of services based around Microsoft Access, Microsoft SQL Server, and SQL Azure cloud.
Database development is a process of creating data tables, procedures, queries, and then gelling all that together with programming. A database can have a number of different components, such as a web based interface, mobile and tablet application, PC application, links to third party systems, and so on.
Each database development project requires assembling a professional team with the relevant skillsets to tackle each of the customer’s requirements. On smaller projects, such as those that involve Microsoft Access or simple database applications, a single database developer will be sufficient. On bigger projects that involve complex database functionality, such as systems based on Microsoft SQL Server or projects that involve several technologies, multiple developers may be required.
A team leader usually manages the development team, typically the most experienced of the developers. The team leader will work closely with the project manager and the business analyst to ensure the smooth delivery of the project.
During this first stage of development we create a database model or prototype to ensure that the customer gets the system they want.
The database model will give users a good idea of how the new database system will look and feel and can demonstrate how the completed database will function.
For example, the database model will help users visualise how they are going to navigate through menu options, export or import data, create new records, and access reports.
Approving the database model early helps to ensure that the final product is going to be well received by users when it is ready.
Creating database structure
Following the customer’s approval of the database prototype, our database developers will commence work on the database skeleton. This involves creating database tables, procedures, and user interface forms.
On many database projects, we adopt an ‘elastic database structure’ approach, which allows users to adjust their bespoke database structure themselves by adding new fields, tabs, menus, and reports. Eventually, the new database becomes a framework that users can customise to their business requirements without having to come back to database developers and ask them to make the necessary changes.
First database preview (alpha release)
Once your bespoke Access or SQL database has reached the alpha stage, it is ready to be presented to stakeholders. You will be invited to view a demonstration either at our offices or remotely. At this stage, you will be able to test core database components and interface functionality, and provide feedback.
The first database preview is a one of the most important milestones which helps the development team to ensure that they are moving in the right direction and that the emerging product is meeting customer expectations.
The customer is expected to fully evaluate the new database at this stage and provide feedback on the look and feel of the system, its functionality, speed, and performance. While evaluating the database, the customer will need to refer to the original specification to make sure that their feedback is aligned with their initial requirements.
Second Database release (beta version)
Our development team will take note of your feedback from the alpha release and make any necessary improvements, including fixing any bugs found in the initial release. We will then release a beta version of the database and invite you to another demonstration. There could be a number of interim versions before the new database is ready to go live.
Database installation on your network
When you are satisfied with the look and functionality of your bespoke database it is ready to be installed on your network.
Deploying your Access database to users is a straightforward process that usually takes just a few hours, and doesn’t require any modifications to your network environment. You can choose whether you would like us to install the database for you or we can provide instructions to your IT department.
A SQL Server database must be installed on a server or in a cloud with the front-end user application deployed to user PCs. At this point we will also import existing data, if such service is requested, so that users can quickly start working with the new database.