Database Development Norwich Norfolk

Database Development

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

Microsoft Access database exampleMicrosoft 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.

SQL Server

SQL frontend exampleMicrosoft 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

MySQL printout exampleMySQL frontend exampleMySQL 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.

Other Development

Excel spreadsheet exampleWe 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.

What Our Clients Say

"Having used a rather dated MS DOS based system for a number of years which really did not accommodate our growing needs, we wanted to bring our computer system up to date and make it work for us more efficiently. Andrew was very thorough when he met with us to discuss our requirements and took on board all the functions that we wanted the system to perform but also suggested options that we hadn’t considered. He then tailored it to accommodate our needs. He assisted with the implementation of the system and was on hand to help with any teething problems. The aftercare service we have received since is second to none and we are still adding to the system as and when required. We would have absolutely no hesitation in recommending Anzat Software to anyone requiring a thoroughly professional software company."
Lisa Rodgers - Stauff Anglia Ltd

"Anzat Software has revolutionised our job handling with a tailored software solution to meet all of our needs. They are problem solvers and it’s reassuring to know they are there with first class customer service!"
Tony Bayliss - FW Frost (Engineers) Ltd

"It’s been a joy working with Anzat Software, Andrew is clearly an expert in Microsoft Access Databases, he rapidly understood what we wanted and delivered it to budget and on time. I will certainly use them again."
Michael Charles - Green Pebble