Comcraft - Access Database Design and programming : Examples

"I could immediately tell on the telephone, that he knew his stuff and that we would be able to work together."
Stephen Slade
Partner
Smooch Rings

"We can highly recommend Comcraft as being helpful, efficient and a company that deserves to do well."
Carol J Broom
Data for learning
The James Hornsby High School

call us now on:
01202 862371

sales@comcraft.co.uk

Examples of our databases

Below are some screen shots of Access databases we have developed for our customers. Click on the pictures to see a full size image.

A screen grab from a database developed for cleaning contractor. When the user has filled in the main Jobs form, they can then press a button to automatically create and email an excel spreadsheet of the job details to the selected supplier.

A screen grab from a database developed for a car hire company. The user can quickly see the history of a hire agreement; from rent payments, to parking fines. If required, an SMS text payment reminder can be sent to the driver.

This customer receives hundreds of purchase orders per month via email. By pressing one button ("Import Orders") this database:

1. Launches Outlook
2. Scans the subject of all new emails for "internet order"
3. Reads and interprets the content of the emails
4. Imports the orders into the database

Press one more button ("Sales report") and the user can see sales figures for the UK, EU and US with a V.A.T. breakdown for that month. This small area of the database saves hours of labour per month.

Office Automation - This form completely automates the mail merge features of Word.

The user can quickly select a group of people based on location, one or more business sectors and which mailing list they subscribe to, and then print a personalised letter or address label for each one. This one form can save hours of labour.

A screen grab from a database developed for a lithographic printer. This system manages all customer records, estimates, sales orders, stock control, production documents and delivery notes.

When creating an estimate the user can manually edit either of the "Mark up" fields or even the "Total" field. Any changes to these fields are immediately reflected in adjacent fields, quickly showing the profitability of the job.

When the "Map" button on this form is pressed a website is launched showing the location of the contact based on their post code.