Database Collection - Software Design and Programming for Business and Construction

Home Software Experience Clients Contact Me Tech Tips

 

 

Software Portfolio

  1. General

    1. Fee Accounts

    2. Vehicle Management

    3. Industrial Training

    4. Staff Allocation
       

  2. Construction

    1. Planned Building Maintenance

    2. Project Management for Water Framework Contracts

    3. Claim Analysis

    4. Project Management

    5. Tender Tracking

    6. Cost Value Reconciliation

    7. Plant Hire (for hirers)

    8. Drawing Management (Contractor)

    9. Drawing Management (Architect)

    10. Site Inspections

    11. Analyse Coins cost reports to WBS Codes
       

  3. Selling

    1. Tele-Sales

    2. Customer Sales/Orders Tracking (MS Access)

    3. Customer Sales/Orders Tracking (SQL Server)
       

  4. Specialised Business Programs

    1. Market Research Survey Management

    2. Accounts For Teachers with Private Pupils

    3. Membership Management and Directory

    4. Fundraiser Results Management

    5. Cruise Bookings
       

A1. Fee Accounts
  Records all data necessary to formulate a firm's fee accounts.  I have been using it for my own fee accounts since 1989.
(MS Access)

Back to Top
A2. Vehicle Management
  Records the dates for  MOT tests, road tax, servicing and return of tachograph records, and  warns when these are due. It also records the costs of servicing and repairs and amounts of off-road time for each vehicle. Used by a Scottish plumbing firm.
(MS Access)

Back to Top
A3. Industrial Training
  Used by a national contractor to manage training and monitoring of staff and operatives involved in railway maintenance.
(MS Access)

Back to Top
A4. Staff Allocation
  Staff time for each month is allocated to projects and other cost heads. Monthly bills for mobile telephones are imported electronically and the costs for each telephone is matched to the appropriate staff member. The programme then exports a report of the percentages of each staff member's salary to be allocated against each cost head.  The programme allocates mobile phone costs in the same pro-rata for each staff member and exports the total mobile phone cost for each cost head.
Used by a national contractor.

(MS Access)

Back to Top
B1. Planned Building Maintenance
  Allows the user to itemise the maintainable components and equipment in buildings and to set up and manage programmes of cyclic maintenance for them. Used by a national contractor for the management of planned preventive maintenance of railway properties.
(MS Access)

Back to Top

B2. Contract Management for Water Framework Contract
  Imports instructions from the client. Allows allocating of work to gangs in up to 3 stages - pipelaying, backfill and reinstatement. Creates schedules of work for the gangs. Allows recording of work quantities, gang times, and materials. Creates valuations, actual cost schedules, and operative time sheets. Also handles instructions relating to alleged defects. Comprehensive reporting system.
Used by a national contractor to manage framework contracts in Wales since 2000.

(MS SQL Server with Access user interface)

Back to Top
B3. Construction Claim Analysis
  I have several versions of this programme which have each been tailored to suit particular projects.  Basically they all have the function of correlating instructions and drawing issues with the programme elements that they affect with provision to enter descriptions of those effects and to flag whether they affect time, cost or both.  The programmes are then able to print or export reports for each programme element showing chronologically the items that affected their progress and/or their cost.
Used in various construction disputes.

(MS Access)

Back to Top
B4. Construction Project Management
  I have several programmes that fall under this heading.  They were written for different projects and each have special features that relate to those projects.  They all have in common that they record instructions for elements of work and then track and report upon the progress of that work.
Used by a national contractor.

(MS Access)

Back to Top
B5. Tender Tracking
  This programme records information about tenders for construction projects including a risk analysis and a probability estimate. It produces tender programmes and forecasts of monthly probable turnover.  For successful Tenders the programme produces Contract Notification datasheets and various templates for reports relating to live contracts.
Used by a national contractor.

(MS SQL Server with Access user interface)

Back to Top
B6. Cost Value Reconciliation
  This programme and the Tender Tracking programme share the same database. This application records monthly actual and forecast cost and value data for each contract and regional monthly budgets. Information from the accounts system is imported into it and augmented by adjustments to give an up to date monthly snapshot of the position on each project. The programme produces reports showing monthly movements, latest forecasts, and budget comparisons in detail and summary form.
Used by a national contractor.

(MS SQL Server with VB.net user interface)

Back to Top
B7. Plant Hire (for hirers)
  Details to follow.
Used by a national contractor.

(MS Access)

Back to Top
B8. Drawing Management (Contractor)
  Details to follow.
Used by a national contractor.

(MS Access)

Back to Top
B9. Drawing Management (Architect)
  Details to follow.
Used by a regional architect.

(MS Access)

Back to Top
B10. Analyse Coins cost reports to WBS Codes
  Details to follow.
Used by a national contractor.

(VB.net)

Back to Top
B11. Site Inspections
  Details to follow.
Used by a national contractor.

(MS SQL Server with VB.net user interface)

Back to Top
C1. Tele-Sales
  Details to follow.
Used by a call centre in Cardiff which has now ceased trading.

(MS SQL Server with VB.net user interface)

Back to Top
C2. Customer Sales/Orders Tracking (MS Access)
  Details to follow.
Used by various companies.

(MS Access)

Back to Top
C3. Customer Sales/Orders Tracking (SQL Server)
  Details to follow.
Used by a supplier of juice bar equipment.

(MS SQL Server with VB.net user interface)

Back to Top
D1. Market Research Survey Management
  Details to follow.
Used by a market research business.

(MS SQL Server with VB.net user interface)

Back to Top
D2. Sound Accounts
  A simple accounts system designed for freelance music teachers. Records pupil/billing details, lesson dates, miscellaneous sales, payments, and purchases from which invoices, reminders and income/expenditure accounts can be printed at the click of the mouse.
(MS Access)

Back to Top
D3. Membership Management and Directory
  Details to follow.
Used by a professional institute.

(MS Access)

Back to Top
D4. Fundraiser Results Management
  Details to follow.
Used by a national fundraising business.

(MS Access)

Back to Top
D5. Cruise Bookings
  Details to follow.
Written for a yacht charter company.

(MS Access)

Back to Top

Based in Devon in southwest UK, Database Collection can provide software and program development for English speaking businesses worldwide.
Last modified: 14 March 2008 Software Development companies