Bespoke Databases & Software

- Microsoft Access

Microsoft Access is a solid database platform. It is little known that it can be run for no cost using the free “Access runtime” software provided by Microsoft. Access can be interlinked with other solutions including a MYSQL backend, web interfaces which makes it very versatile. We offer a full design service including the tables, forms, queries and reports. Access databases can be run solely on one machine or can be networked together providing multiple logins. (Please see Case study 1)

- MySQL

MySQL is a database system for storing the data, it is then accessed by a front end interface such as a website or Access forms. Its very stable and securing, capable of holding vast quantities of data.

- Web Based

A lot of clients require there website to be access via the web. Having a web interface makes the database much more portable as it will work on the majority of devices. Its quote possible to have a mixture, so the customer would interact via the web interface and the office has a back order system linked in using access.

- Integrate with other services (such as websites)

Databases can be interlinked. A good example of this is linking a webstore to sage. Rather than having to manually enter every sale, the two databases can talk so one automatically update each other.

- Provide additional features (Additional sage reporting)

Databases can give extra functionality. An example of this is Sage, whilst sage has good reporting and a limited report designer as standard, it can be quite limiting. By linking an access database direct into sage new much more powerful reports can be created to donform to businesses exact requirements.

Some of our software development clients include :

Case study 1: Access Database : Car leasing Company

Basic Brief

The client required a database to record all the information as to the various lease hire agreements they had out. The database started as a one user and got converted to multiple login over a LAN.

(A) Capture information of existing customers

(B) Generate reports based on criteria provided by the client

The client provided a list of all the data fields required as well as examples of the layout and the reports required.

** Example of access database

** Guide Price £1500+ VAT

Case Study 2 : Web Based Database
www.fun-stickers.com

Basic brief

The client sells stickers in bulk to resellers and required an online presence to promote the various stickers they stock as well as their retail solutions (display stands etc). The main requirements of the site were:

A To clearly display the products that were offered

B To clearly show the brands they are affiliated with

The client provided the images they wished to use alongside all text and the various pages they wanted us to create. In this instance the logo and branding were provided by the client but we can offer this as well (For information on these services please click here).

** Example of a basic information website as of Sept 2015.

** Guide Price £1000+ VAT

Case Study 3: Combination Database

Basic Brief

The client operates a retail store but wanted an online presence to sell and advertises the goods and services as well. The site was designed to provide information to potential highstreets clients about the store as well as for those purely looking to buy online. The main requirements of the site were to:

A To sell items from the website and accept payment via PayPal

B To sell electronic tickets to events and provide a calendar displaying these

C To integrate a blog so news could be posted regularly

D To access feeds from Instagram, Facebook and twitter

E To incorporate a gallery showing imagery from the highstreet store

** Example of a basic information website as of Sept 2015.

** Guide Price £1200+ VAT

Case Study 4: (Ecommerce site linked into Ebay)

Basic Brief

The client sells packs of stickers (superman, pirates, from films etc.). The bulk of their sales they want on their website but they want to get their brand out so want to have a presence on eBay (listing approximately a third of their stock). If successful they are looking at integrating an amazon feed later next year. The main requirements of the site are

A To sell items from their website and accept payment using an online card merchant

B To have an automatic unmanaged link to eBay (products are automatically listed and dealt with from the website, no interaction with eBay required

C Have the ability to select which items from the shop to stock in eBay

D Have automated stock control (if an item is sold on the website the stock on eBay goes down and vice versa)

E To have different pricing on website and eBay (eBay will be cheaper to remain completive)