
Closed
Posted
I need a complete Microsoft Access solution that lets me enter both customer information and insurance plan data, then instantly: • calculate personalized premiums, • display several plans in a clear side-by-side view, and • output a polished comparison report I can save or email as PDF/Excel. Clean, well-structured tables, user-friendly data-entry forms, and VBA-driven queries will be essential so the workflow feels seamless to non-technical staff. I’ll supply sample customer and plan records the moment we start; the database must be ready to handle larger real-world datasets without bogging down. Deliverables – A compiled .accdb (or split front-/back-end) with all tables, forms, queries, and reports in place – Source file with commented VBA for future tweaks – Brief setup guide so I can deploy it to other machines Acceptance criteria 1. Enter a customer profile, pick any selection of plans, press “Compare”: premiums auto-calculate and appear in one row per plan. 2. Clicking “Generate Report” produces a print-ready comparison that matches the on-screen figures. 3. All calculations remain accurate when I update base rates or benefit values in the plan table. Speed is crucial—I’m aiming to review a working prototype within days and have the final version signed off as soon as possible.
Project ID: 40672467
10 proposals
Remote project
Active 2 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
10 freelancers are bidding on average ₹1,000 INR/hour for this job

Dear Customer, Thank you for the opportunity to submit this proposal. Scope of Work 1. Split Database: Separated Back-End and Front-End to prevent corruption and boost speed. 2. Intuitive UI: Profiles, plan selection, and instant side-by-side comparison on one screen. 3. VBA Calculation Engine: Automated logic to calculate custom premiums in real time. 4. Export Module: One-click PDF/Excel reports or direct email attachments. Acceptance Criteria ⭐ Criterion 1 (Instant): "Compare" triggers VBA logic and refreshes the view immediately. ⭐ Criterion 2 (Accurate): Generated reports precisely match the values displayed on screen. ⭐ Criterion 3 (Dynamic): Base rate updates will not alter previously saved historical data. Deliverables ⭐ Front-End File: Protected interface to prevent users from breaking formulas. ⭐ Back-End File: Clean, normalized, and indexed relational tables. ⭐ Source Code: Fully commented VBA modules for easy future modifications. ⭐ Deployment Guide: Instructions for multi-user setup and automated table relinking. Timeline ⭐ Day 2: Functional Prototype (MVP) with core tables, UI, and VBA calculation engine. ⭐ Day 4: Revisions, performance testing, and report validation with sample data. ⭐ Day 5: Final Production Version delivery, file compilation, and Installation Guide. Please share the sample records to begin. Ready to start today. Best regards,
₹1,000 INR in 40 days
6.6
6.6

I am a well-experienced MS Access developer, 15 years of working experience on Microsoft Office Application Development I have read your project description with great interests, so that I feel 100% sure on it. I promise A+. I can get started right now and keep your timeline. I hope your kind messages to discuss about this project in more detail. Thanks in advance.
₹1,000 INR in 40 days
4.6
4.6

Hi, I'm Selvakumar, I run UFours IT Solution, a small dev team out of Madurai that's been building business apps for over 10 years now, quite a bit of it in Access/VBA. This is a pretty standard build for us honestly - customer table, plans table, rates/benefits table, all properly normalized so it doesn't slow down once you've got real volume in there. I'll set it up split front-end/back-end so it's easy to deploy across machines later. For the actual workflow: you pick a customer, tick off whichever plans you want to compare, hit Compare, and VBA runs the premium calc for each one and lays them out side by side, one row per plan. Generate Report just takes those same numbers and spits out a clean PDF/Excel version, so what you see on screen is exactly what gets printed or emailed. If you go in and change a base rate or benefit value later, that flows through automatically to every future calc - nothing hardcoded. You'll get the compiled accdb, the source with VBA that's actually commented (not just dumped code), and a short setup doc so you're not stuck if you need to move it to another PC. Since you want to move fast, I can have a working prototype ready in a few days once you send over sample customer/plan data - we can refine from there before final sign-off. Send the data whenever you're ready and I'll get started.
₹1,000 INR in 40 days
3.7
3.7

Hello, You need an Access solution where staff can enter customer and plan data once, compare multiple plans instantly, and generate a report that always matches the calculated figures. I understand you need: * Structured customer and insurance-plan tables * User-friendly data-entry forms * VBA-driven premium calculations and queries * Side-by-side comparison of selected plans * Print-ready PDF/Excel comparison reports * Accurate recalculation when rates/benefits change * A scalable structure for larger datasets * Commented VBA source and deployment documentation My approach: 1. Review your sample customer records, plan data and calculation rules. 2. Design a clean relational Access database structure. 3. Build forms for data entry and plan selection. 4. Implement and test the premium calculation logic. 5. Create the comparison interface and matching report output. 6. Test calculations, edge cases and performance before delivery. The calculation logic will remain driven by the plan data rather than hard-coded values, making future rate updates easier to maintain. A few questions: 1. How are premiums calculated from customer and plan attributes? 2. Can one customer select unlimited plans for comparison? 3. Do you require both PDF and Excel export from the same report? I can begin with a working prototype and refine it from your sample data. Best regards, Ankit
₹1,500 INR in 30 days
3.4
3.4

Hi, I can build the Microsoft Access insurance plan comparator with customer entry, plan management, premium calculations, side-by-side comparison, and PDF/Excel report output. My approach will be to first review your sample customer and plan records, premium rules, benefit fields, and report format. Then I’ll create structured tables, forms, VBA-driven queries, and reports so non-technical staff can use it easily. I can help with: * Access table design * Customer and plan entry forms * Premium calculation logic * Side-by-side plan comparison * VBA queries and buttons * PDF/Excel report export * Updateable base rates and benefits * Setup guide Deliverables: * Complete .accdb database * Tables, forms, queries and reports * Commented VBA source * Compare button workflow * Generate Report button * Print-ready comparison output * Deployment/setup notes I can prepare a working prototype quickly after receiving the sample data and will focus on accuracy, usability, and future maintainability. Best regards Ankit
₹750 INR in 40 days
3.4
3.4

As an expert with over 17 years of experience in Database Management, SQL and Visual Basic, I have encountered and successfully delivered on numerous projects similar to your request. My team's expertise in ASP.NET C#, Python Scraping and Automation Development makes us uniquely positioned to build an optimized solution for your project requirements. We understand the importance of speed and accuracy for your MS Access Insurance Plan Comparator. We have a proven track record of developing high-quality, clean, and user-friendly solutions that meet client's needs. Our approach includes creating well-structured tables, designing intuitive user-friendly data-entry forms, and employing VBA-driven queries to ensure a seamless workflow for all users. Rest assured that all our calculations and reports will remain accurate even when you update base rates or benefit values. Another strength we bring is our commitment to client satisfaction. Our best price guarantee coupled with 24x7 working hours ensures that your project will be given maximum priority and completed to your utmost satisfaction. With our comprehensive experience and skillset,E+ we are ideal candidates for delivering a polished MS Access solution that fits your specific needs. Choose us today, so we can get started on delivering a working prototype within days just as you desire!
₹1,000 INR in 40 days
2.2
2.2

You type a customer, pick plans, hit Compare, and see premiums side by side plus a report you can save or email. I can start right now. In 24-48 hours you get a working sample with your records so you can click Compare and Generate Report yourself. Simple forms for staff, premiums that stay correct when you change rates, and a print-ready comparison that matches the screen. Commented code and a short setup note for other machines included. Share a sample customer and two or three plans so I can build the first compare around your real numbers?
₹850 INR in 3 days
0.0
0.0

Chhendipada, India
Member since Aug 11, 2026
$10-30 USD
$15-25 USD / hour
$2-8 CAD / hour
$30-250 CAD
$10-30 USD
$115-200 HKD / hour
₹1500-12500 INR
$1500-3000 AUD
£250-750 GBP
₹12500-37500 INR
₹750-1250 INR / hour
$250-750 USD
₹750-1250 INR / hour
$25-30 USD
₹750-1250 INR / hour
₹750-1250 INR / hour
$250-750 AUD
$30-250 USD
$15-25 USD / hour
₹12500-37500 INR