DATABASE DESIGN

Most businesses need to keep records about their customers and contacts, possibly send letters or invoices to them, create mailing labels, be reminded about actions such as renewals of contracts, keep a history of activity, orders etc.

Using MS ACCESS™ we can create a bespoke solution for your company. If you have existing data (in a spreadsheet or other format) we can often import it for you. If you already have an Access database that needs improving or amending we can often help. Ask us for a quotation or for free advice.

Our databases can add a useful facility - or completely run your company!

We have provided solutions for:-
Van Delivery Routing
Automatic Invoicing
(importing into Sage Line 50)
Order Processing
Customer Contact Management
Charity Membership Management (Renewals/invoicing/mail-shots etc.)
Time Recording
Domestic Staff Recruitment
Bar Code Label Printing and stock control
Exhibition Space Management
Language Translation Job Management
Service Engineer Call Management
Credit Control
(linked to Sage Line 50)
Job Costing
Insurance Renewal Management
Grain Transportation & Invoicing
Building site progress management (using handwriting recognition tablet computers)
Rotary Club membership management
Pallet management
Building site maintenance records
etc.

Pet Care Trust - membership management system including automated subscription invoicing, mailings, training course management and year-book compilation
Bedford Translations - Jobs database to match translators with projects by looking up tables of matching pairs of language skills. Document production.
DP Fabrications - Order processing database for control cabinet manufacturer. Component analysis for manufactured items.. "The best software solution we have ever purchased"
Masseys Agency - Candidates database for domestic staff agency listing skills and experience. Linked with CVs in Word™ format.
Box & Charnock Ltd - Site management facilities for pre-ordering heating & plumbing services. Also boiler service call management (uses SQL data).
Ajay Supplies - Order processing of thousands of nuts and bolts in every size - with pricing discount history, picking lists, invoice production etc.
Karavelle Ltd - Stock (clothings & equipment) management for exhibitions. Dry cleaning management and stock-check facilities.
Sempringham - Mail-order database for history book sales to educational institutions and students.