Weekly Admin Hours Eliminated
8 hours per week of manual client lookups, email thread searches, and Excel reconciliation replaced by a single CRM form that loads in seconds.
Case study
Client Visibility in One System: CRM Built in MS Access for a 30-Person Consultancy
A management consultancy was losing deals and billable hours because client history lived in Outlook, project notes lived in Excel, and billing status lived in someone's head. We built a custom Access CRM that put everything in one place.
Client Records Centralised
All 340+ active and past client records consolidated into one database - contacts, project history, billing status, and follow-up notes on one screen.
Proposal Lookup Time
Time to locate a previous proposal scope dropped from 15 minutes of email searching to under 30 seconds via the CRM project history tab.
Missed Follow-Ups Since Go-Live
Automated daily follow-up reminders via Outlook eliminated the category of missed client follow-ups that previously cost the firm renewal opportunities.
First-Year ROI
200% ROI in year one - driven by recovered billable time, higher proposal conversion from faster response, and no ongoing SaaS licence cost.
User Adoption Rate
14 consultants trained in one day. Forms built around their existing workflow meant adoption was immediate - no change management programme needed.
The Problem: Client Knowledge Lived in People, Not Systems
This 30-person management consultancy had three senior consultants who knew every client relationship from memory. New hires, handovers, and holiday cover created constant gaps. When a proposal opportunity came back after six months, whoever fielded the call had to chase five people and three email threads before they could answer basic questions about what had been scoped previously.
The firm tracked active clients in a shared Excel file updated by different people on different schedules. Billing status sat in a separate spreadsheet managed by the finance coordinator. Project notes were split between email, a shared drive, and personal notebooks. There was no single view of a client relationship.
Three Failures That Repeated Every Week
Proposal Scope Rework
Consultants regularly rebuilt proposal sections from scratch because they could not find the previous version quickly. A search through Outlook folders and a shared drive that nobody maintained properly took 15-30 minutes per search - and sometimes found nothing.
Missed Follow-Ups and Lost Renewals
Without a system flagging overdue client touchpoints, follow-ups happened when someone remembered. Three contract renewals in the 12 months before we were engaged went to competitors because the firm simply did not reach out in time.
Billing Disputes From Incomplete Records
Finance raised invoices from the billing spreadsheet. Consultants referenced their own notes. When clients queried charges, reconciling what had been agreed took hours and occasionally resulted in credits that should not have been necessary.
What We Built
We designed a custom MS Access CRM around the consultancy's actual sales and delivery process - not a generic contact management template. The database has three core modules: Client Profiles, Projects, and Billing.
The Client Profile form holds all contact records, relationship history notes, and the assigned consultant. From the profile, a single click opens a full project history showing every engagement the firm has had with that client - scope summaries, fees, outcomes, and the relevant documents stored by file path reference.
The Projects module tracks proposal status through the firm's internal stages: scoping, proposal sent, negotiation, signed, and delivery. Each project links to the client record and the billing entry. Consultants update status from the same form they use to log client calls - there is no separate system to maintain.
A VBA routine runs each morning via Windows Task Scheduler, queries all client records where the follow-up date has passed, and sends each responsible consultant a formatted Outlook email listing their overdue touchpoints with the client name, last contact date, and recorded next action.
Why Access Was the Right Choice Here
The firm evaluated Salesforce and HubSpot. Both required mapping their project-milestone billing model onto an opportunity pipeline designed for product sales. The integration with their Excel fee calculators would have needed middleware. Total licence cost for 14 users was £18,000-£28,000 per year.
The Access build cost a fixed project fee with no recurring licence, ran on the network they already maintained, and was designed around the exact terminology and workflow the consultants already used. Training took one day. The forms did not require anyone to learn a new mental model of how client relationships are managed.
System Capabilities
Client & Contact Management
Full client profiles with contact details, relationship history, assigned consultant, and industry classification. Search by name, company, or industry in under a second.
Project History by Client
Every engagement logged with scope summary, fee, start/end dates, outcome, and document path. One click from the client profile opens the full project list.
Proposal Pipeline Tracking
Stage-based proposal tracking from scoping through signature. Consultants update status in the same form they use for call notes - no parallel system.
Billing Status Linked to Projects
Finance sees billing stage alongside project status. Invoice queries are resolved in seconds by opening the linked project record rather than cross-referencing spreadsheets.
Automated Follow-Up Reminders
Daily Outlook email to each consultant listing overdue client touchpoints - client name, last contact date, and next action recorded in the CRM.
Document Path References
Proposals, contracts, and deliverables stored on the shared drive are linked by file path in the CRM record. Open any document from Access with one click.
After Go-Live: What Changed Day to Day
The senior consultants stopped fielding "what did we scope for them last time?" calls from junior staff. Every team member could open a client record and see the full relationship history without asking anyone.
Proposal preparation time dropped sharply. Instead of reconstructing prior work from email searches, consultants opened the project history, read the previous scope summary, and started from there. Turnaround on proposals improved from an average of 4 days to 1.5 days.
Three renewal cycles after go-live, the firm had not lost a single renewal opportunity to a missed follow-up. The daily reminder email meant every at-risk relationship was on someone's agenda before it became a problem.
“Before this, our best client knowledge walked out the door every time a senior consultant went on leave. Now any of our team can pick up a client call, pull up the full history in thirty seconds, and sound like they've been managing the account for years. That alone was worth the project.
Tech Stack
Microsoft Access - client profiles, project history, billing status, and pipeline forms
VBA automation - follow-up reminder emails, stage change notifications, and report generation
Outlook object model integration - automated daily digest emails to assigned consultants
SQL Server backend (upgrade path) - database split with linked tables, ready for migration when headcount grows past 20 concurrent users
Windows Task Scheduler - triggers the morning follow-up VBA routine without manual intervention
Is This the Right Fit?
A custom Access CRM is the right choice when a standard SaaS platform forces your workflow into someone else's sales model, when you need deep integration with Office tools your team already uses, and when recurring licence costs are a real consideration. Typical fits:
Project-based consultancies and agencies
Where client value is in relationship and project history, not a linear sales pipeline. Access models project-level billing and engagement history naturally.
Professional services firms with 5-30 users
Above 5 users, shared Excel breaks down. Below 30 concurrent users, Access on a properly maintained network server performs well and costs nothing in ongoing licences.
Teams deeply embedded in Microsoft Office
If your workflow involves Excel fee models, Word proposals, and Outlook communication, Access integrates with all three natively via VBA - no middleware required.
Frequently Asked Questions
Why use MS Access for a CRM instead of Salesforce or HubSpot?
Commercial CRMs force consultancies into vendor-defined contact models and opportunity pipelines that rarely match how a project-based firm actually sells and delivers. This client needed billing status linked to project milestones, custom approval chains for proposal sign-off, and deep integration with their existing Excel fee calculators - none of which mapped cleanly to off-the-shelf platforms. Access cost a fraction of the licensing and required no ongoing SaaS fee. The team was trained in a day because the forms reflected exactly how they worked.
How many concurrent users can a shared MS Access CRM support?
A properly split Access database - front-end forms on each workstation, data tables on a shared network location - comfortably supports 10-20 simultaneous users. This consultancy runs 14 users at peak without locking issues. When the firm grows past 30 concurrent users or record volumes climb past 1-2 million rows, migrating the backend to SQL Server keeps the same forms and VBA logic while removing the file-size constraint entirely.
What happens to the CRM data if the network drive goes down?
Users cannot write new records during a network outage because the data tables live on the server. However, the front-end application itself remains open and readable. Critical client information is still visible for calls and meetings. This firm uses standard IT backup practices on the shared folder - daily incremental, weekly full - which is standard for any file-based system including their other business documents.
Can Access send follow-up reminder emails automatically?
Yes - VBA can call Outlook's object model to send emails from within Access. This system generates a daily digest of overdue follow-ups and sends it to the responsible consultant each morning at 8am via a scheduled task that triggers a VBA routine. Emails include the client name, last contact date, and the next action recorded in the CRM record. No third-party add-in required.
Next step
Want similar results in your operations?
Book an Automation Opportunity Assessment. We map workflows and scope a practical build plan.
- No Onsite Visit Required
- No Technical Specification Required
- Assessment Before Commitment
- Clear Scope Before Work Begins
Questions before you book? Speak with our team at +1 385 386 3860
