We specialise in creating database applications from small 1 PC systems to large client-server multi PC systems. Below are the main databases types that we use when creating our bespoke software. Feel free to contact us with your database requirements and we will help you.
Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. With Microsoft Access, the user is easily able to modify any data within the database, produce reports from the database and submit queries about all information stored into it.
We have experience of working in all versions from Access 97 (v2) to Access 2016.
We can take your concept and create a new database from scratch or take an existing database and develop it further or upgrade it to a newer version of Access.
Microsoft SQL Server is a relational database management system developed by Microsoft.
As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network (including the Internet).
With SQL Server as the database we use Visual Basic within Microsoft's integrated development environment to create the user interface that is installed on the client's PC. The frontends are flexible, user-friendly and easy to modify.
An example is an engineering company that uses a job costing database to create jobs for the products that they make and then print job cards, monitor costs, run Work In Progress (WIP) reports etc.
MySQL is an open-source relational database management system.
With MySQL as the database we use Visual Basic within Microsoft's integrated development environment to create the user interface that is installed on the client's PC. Examples include an archiving database where boxes and files are stored on pallets and shelves and are then pulled off the shelf as the customer requires.
Another example is an Electrical Testing company who manage their testing schedule via a database which stores customer details along with previous bookings and reminds them when future appointments need to be booked.
We also do lots of development with other parts of Microsoft Office including Excel and Outlook, often integrating functionality from them into our bespoke software.
For example we can construct and initiate emails within the bespoke software and send them through Outlook so that you have a copy of the email in your Sent Folder.
We have helped build and maintain Excel spreadsheets where you enter customer information in and then create test certificates automatically.
We can link our software with accounts packages such as Sage and Quickbooks, both importing and exporting information.