home > database design and development > insurance

insurance premiums and claims

A database that tracks the premiums, fees and claims of the policy holders. It also tracks commission of, and payments made to, the agents and brokers.

Recently we have extended the database by adding replication to allow policies to be added and updated by users working away from the office.

value to client

Complete, accurate and secure database:

Premiums, claims, payments and adjustments
Policy, broker and insured details on record
Recording of broker and agent commission and fees
Monthly report for agents and brokers
Management reporting of policies, fees and claims
Strict control over agent and broker payments
Multi-user environment
Provision for remote updating

client

An insurance company.

software development platform

Microsoft Access and VBA.