Database Design

Database Design

Many organisations find that off the shelf customer database software can't meet all their needs, and turn instead to bespoke database design for a cost effective solution.

Using the latest Microsoft Office Access tools and methods, we can design and build a custom database solution that applies our innovative software strategies to your unique business requirements.

Database Structure

No matter what your requirements are, we can design a database solution that will satisfy your goal. Database design and data structures play a very vital role in success of complex applications.

We have extensive experience in designing from this perspective. Getting the design right the first time means your application functions perfectly every time.

Multi User Interface

Whatever the size of your database application, we will always supply the end solution in two seperate parts.
  • Back End Database

  • Front End Application

Back End Database

Back End Database

The Back End Database is stored in a central location - either on a server (recommended) or a shared folder on a desktop.

Relational Tables
This database houses all the data entered by you users in a number of relational tables. This means that each piece of data is only stored once within your database. For example, your product details are only stored in one table. Any other table that links to a product contains only a number representing the unique ID of the product it refers to. This greatly reduces the storage space required for your database.

Simultaneous Connections
Placing the data in one central location allows simultaneous use for multiple users across any number of PCs. This ensures that all your users are using the most up to date data possible, reducing the potential for errors.

Possibly the most importat part of any business is a good backup routine! Because your data is stored in one central location, the backup overhead is also greatly reduced as their is only ever one location that requires backing up.

Front End Application

Front End Application

The Front End Application can be installed on any number of PCs allowing simultaneous use for multiple users.

Navigation in our applications is done via a Fully Customised Ribbon. The Ribbon is part of the new the Office Fluent user interface (UI). Throughout the Office suite, Microsoft replaced the traditional menus and toolbars with this new Ribbon so that you can find and use the features you need - and use - a lot easier. It was designed to be intuitive for you and, perhaps most importantly, easy to get accustomed to.

Because the back end database is separated from the front end application, if you need to re-install or renew your PC, you can do so without having to worry about losing your data.

Upgrades are also greatly simplified as these are simply a case of un-installing the old application and installing the new.

Granular Access Control

Granular Access Control

All of our databases include powerful granular access control as standard, putting you in control of your data security. The granular access control enables users roles and responsibilities to be set so that individuals are given access only to relevant areas or functions of the system.

Access rights are defined on a group basis meaning you only need to setup each set of rights once and then simply add the user/s to this group.

For example, your sales team could have access to your customer data but your warehouse would only have access to the tools they need to despatch your products, limiting the potential risk to your organisatin and keeping your sensitive data safe.

Scanner Integration

We have extensive knowledge in integrating scanner hardware into our database applications to interact and automate regular tasks. This can help to greatly reduce the number of data entry errors that occur when users have to input numbers manually using a keyboard or mouse. More on scanner integration ...
Nordic ID Scanner Types

Projects of any size welcome!

Microsoft Access Databases, MS Access Custom Design, VBA, SellerDeck Integration, email automation, contacts, workflow, inventory, stock control, invoicing, payment, debt transactions, accounts software integration ...
SellerDeckMicrosoftredhat Enterprise LinuxMicrosoft Certified ProfessionalDigiCert Affiliate PartnerSophos Silver Partner