MS Access CRM for Small Businesses

Most CRMs are built for large sales teams. They add a monthly fee per user, a cloud account, and more screens than a consultancy, trade shop, studio, or small agency will use. Those businesses mainly need three answers: who the customers are, what was promised, and what to do next.

This MS Access CRM (Small Business CRM in the download) is a complete Access application, not a blank template. There is no server, no subscription, and no sign-in. Data stays on your PC unless you choose to send it. The download is a Microsoft Access .accdb with fictional sample data you can load, then remove, before going live.

Preview the Access screens from the download. Click or swipe through the dashboard, companies, leads, deals, quotes, reports, import, backup, and setup.

It is a Microsoft Access CRM for one person or a small office that already works on Windows. It keeps these jobs in one file:

Use this file if you run a small pipeline and you can open Microsoft Access on Windows. Typical users:

If you later outgrow a single .accdb, the usual next step is the same Access forms with tables moved to SQL Server, or a front-end / back-end split on a small office network. That is a separate project, not a rebuild of the screens.

Open the application and you land on the dashboard. Tiles show active leads, qualified leads, open deals, weighted pipeline, revenue won this period, tasks due today, and overdue tasks. Below the tiles: pipeline by stage, leads by source, deals won month by month, the task list, and a recent-activity timeline. Quick-add buttons capture a company, contact, lead, deal, task, activity, or quote in two clicks.

The company list shows status, industry, city, phone, and email. Search as you type, filter by status, sort by name, city, or last changed, and export to Excel or CSV. Double-click a company to open related contacts, leads, deals, tasks, activities, notes, and quotes on tabs. Contacts work the same way. A contact can belong to a company or stand alone.

Every enquiry starts as a lead, from a website, referral, call, or trade show. Track source, status, estimated value, and expected close date. Convert lead creates or links the company and contact and opens a deal with the amount and close date carried over. Conversion is all or nothing. Converted leads stay linked. You can undo a conversion if you made a mistake.

Each opportunity shows stage, amount, probability, and weighted value. Totals for the current view sit at the top. Weighted value is amount times probability, so the forecast is not an optimistic total of every open deal. Mark won or mark lost from the deal record. Lost deals take a reason.

Tasks link to any company, contact, lead, or deal. Overdue tasks show in red. The CRM reminds you of upcoming tasks when you open it. Activities log calls, emails, and meetings against the record, so a later call does not start from a blank history.

Set products and services once with SKU, price, and type. Quotes number automatically and use statuses draft, sent, accepted, or rejected. Pick a product to fill a line, or type a custom line. Line discounts, tax, subtotal, and grand total calculate on the form. When you add a product, description and price are copied into the quote, so a later catalogue change does not rewrite a quote you already sent. Preview, print, or save as PDF. You attach that PDF to your own email.

The Find box at the top of any screen searches companies, contacts, leads, deals, quotes, and products at once. Phone numbers match however they were typed, so 2065550100 finds (206) 555-0100. Reports include dashboard summary, open pipeline by stage, won deals, leads by source, tasks due, overdue tasks, company profile, contact profile, and the printable quote. Set a date range where it applies, then preview or save a PDF.

Import companies, contacts, leads, and products from CSV or Excel. You map columns, check a preview, and get warnings on duplicates and invalid values before anything is saved. Backup takes one click and is checked after it is made. Restore takes a safety backup of the current file first.

Settings holds business details for quotes and reports, currency, default tax rate, quote number prefix, date format, and drop-down lists (company statuses, lead sources, deal stages, activity types). The first open shows a short setup screen. You can change those values later. Records with linked history are archived rather than deleted.

The free file is a working CRM for one PC. If you need extra fields, a different pipeline, a multi-user split, SQL Server, or a link to Excel or accounting software, that is custom Access work. We scope it as a fixed project after a short review of your current lists and pain points.